Case Study: Adding Sales to Global Using OLAP_EXPRESSION - OLAP

Enablement for the BI Beans created two views of the Units cube, one for each of the two hierarchies for the CUSTOMER dimension. The following SELECT statement queries one of the views and generates a new column for Sales. The SALES column is calculated in the analytic workspace.

The result set of this SELECT statement is sorted so that the sales figures are listed in descending order.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd Protection Status

OLAP Topics