-
Notifications
You must be signed in to change notification settings - Fork 4
6. OLAP Features
The query /DMO/ANA_C_OLP_CurMem_Sng shows how to define restrictions relative to the values of a time-dimension in drill-down (e.g. the previous month). These values are called "current member". The key modeling approach is an association to the cube itself with an on-condition on the dimension in drill down. On the other side there is a single value defined relative to the current member. Typically the functions CALENDAR_OPERATION or CALENDAR_SHIFT are used (for fiscal times FISCAL_CALENDAR_OPERATION, FISCAL_CALENDAR_SHIFT). The association can be used for any measure of the cube.
Very similar to the query /DMO/ANA_C_OLP_CurMem_Sng that showed the current member being relative to a single date. In the query /DMO/ANA_C_OLP_CurMem_Itv there is an interval which defines a range relative to the current member (e.g. Quarter to Date). The association to the cube uses a between condition in this case.
The query /DMO/ANA_C_OLP_Elimination shows how the feature "elimination of inter business volume" works. This feature requires a cube with pairs of fields with a foreign key association to the same dimension. Usually this dimension supports hierarchies. In this example the pair of fields consists of DepartureAirportID and DestinationAirportID. A flight for a hierarchy node on departure airport is called "inner", if the destination airport is a descendent of that node. So it can happen that for one node the flight is not "inner" but for another node it is "inner". If a flight is "inner", then data is ignored ('eliminated') in the result. In the example, this feature is used to get the number of seats which leave the country/region (element OccSeatsExternal) or which originate in the same country/region as the destination airport (element OccSeatsInternal). With the annotation AnalyticsDetails.elimination the pairs for elimination are defined. Multiple pairs can be defined. In addition a rule can be set, if "inner" is applied if one pair fulfills the "inner" rule or if all pairs must fulfill the "inner" rule.
Also see the blog post How to use the AnalyticsDetails.elimination annotation.
The query /DMO/ANA_C_OLP_Total_Grand includes a formula which references the grand total of a measure. The formula is defined as a scalar function. The GRAND_TOTAL function sums up the aggregate on all dimensions. It takes all filters (static and dynamic) into account.
The query /DMO/ANA_C_OLP_Total_Rows includes a formula which references the next subtotals of a measure. The function ROW_TOTAL addresses the next subtotal level for the dimensions on rows and COLUMN_TOTAL the next subtotal level on columns. CURRENT_TOTAL references the next subtotal level of the axis the dimensions are assigned to. If dimensions are assigned to both axis, the function doesn't return a result.