How status / non-additive parameters

Status / non-additive measures include among other typical indicators of BI. Their use is most common in repotech depicting initial or final state in time (ie over the time dimension), such as the status (number of) items in stock, when the state quarter for 2001-Q1 is equal to the state last month in the quarter, ie 2001-March and the state for 2001 is the state Rove last quarter of the year ie 2001-Q4.In contrast, when analyzing the same indicator over another dimension, so the data should be aggregated according to the used functions such as SUM () . How to do it 1 / In the BI metadata repository and load the physical layer above it to create a business model including hierarchies for dimensions. 2 / For the selected indicator in the "Aggregation" check "Based on dimensions." Where first for the other (Other) dimension, select the desired aggregate function, then add the time dimension (New ... button) and selecting a function LAST () or FIRST (). Erik Eckhardt.