CE_OLAP_VIEW return results for an existing OLAP view (also known as Analytical view). It takes the name of OLAP view and an optional list of key figures and dimensions as parameters. The OLAP view is grouped by dimensions and the key figures are aggregated using the default aggregation of the OLAP view.

Example:
 out = CE_OLAP_VIEW (“OLAP_view”,[“Dim1”, “kf”]);
Is equivalent to
 out = SELECT dim1, SUM(kf) FROM OLAP_view GROUP BY dim1;

Related questions