Some of the the identifiers available in Inforiver Matrix are showcased with examples in the below .pbix file.
| IDENTIFIER | USAGE | DESCRIPTION | EXAMPLE | EXPLANATION |
|---|---|---|---|---|
| CLOSEDPERIOD | Calculated measure formula | Checks if the forecast measures belong to the closed or open period | ||
| COLUMN.DATE | Calculated measure formula | Returns the date in a measure's header/title | ||
| COLUMN.PARENT | Calculated column measure | Returns the column's immediate parent in a column hierarchy | ||
| COLUMNS | Calculated measure formula | Returns a reference to a specific column in the report | IF(COLUMN == "AC", 5000, 6000) | On using in the row formula, returns 5000 for AC column and 6000 for other columns |
| CURRENT_PERIOD | Calculated measure formula | Returns a reference to each period in the report | ||
| DESCENDANTS | Calculated row formula | Returns all the children's values (till the leaf level) as an array | ||
| FORECAST.CLOSED_END | Calculated measure formula | Returns the end date of closed forecasts | ||
| FORECAST.CLOSED_START | Calculated measure formula | Returns the start date of closed forecasts | ||
| FORECAST.OPEN_END | Calculated measure formula | Returns the end date of open forecasts | ||
| FORECAST.OPEN_START | Calculated measure formula | Returns the start date of open forecasts | ||
| GROUP_INDEX | Calculated row/column formula | Returns the position of a column | IF(GROUP_INDEX = 1, [Sales],([Sales].RELATIVE(-1) - [Sales].RELATIVE), | With Months in column, Displays the Sales value when it is the 1st month/column(group_index =1), else returns for all other months, the variance between previous and current month |
| HAS | Calculated column formula | Checks if the specified value is part of the list | ||
| HAS_ALL | Calculated column formula | Checks if all the specified values are part of the list | ||
| HAS_SOME | Calculated column formula | Checks if one or more of the specified values are part of the list | ||
| LEVEL | Calculated column formula | Returns the row level in the hierarchy | IF(LEVEL = 3, 10, 5) | For each row where the heirarchy level is 3, returns 10; for other hierarchy levels, returns 5 |
| LOGGEDIN_EMAIL | On change formula | Returns the email ID of the user making data input updates | ||
| LOGGEDIN_NAME | On change formula | Returns the name of the user making data input updates | ||
| MATCH | Calculated column formula | Checks whether the specified value is an exact match | ||
| MAXDATE | Calculated measure formula | Returns the latest date available in a report. | ||
| MEMBERS | Calculated row formula | Returns all the immediate children's values as an array | ||
| MINDATE | Calculated measure formula | Returns the earliest date available in a report. | ||
| RELATIVE | Calculated column formula | Changes the absolute cell/column reference to a relative reference | IFNA(([Sales].RELATIVE(-1) - [Sales].RELATIVE), [Sales].RELATIVE) | When Months in the columns, formula returns Sales of Previous month - Current Month Sales except when there is an error, then it returns the Sales of Current Month |
| RELATIVE_COLUMN | Calculated row formula | Returns the value of the column relative to the current column | ||
| ROW.LABEL | Calculated row formula | Returns field values used to populate rows in the report | ||
| ROW.PARENT | Calculated row formula | Returns a reference to the parent levels in the hierarchy | ROW.PARENT.AC + ROW.PARENT.PY | For each row it adds the value of its parent row's AC column and PY column |
