Tag: OLAP

Enabling OLAP drill-through to detail for web reports

I mentioned back in 2008 that Web Reports with OLAP source can drill-through to detail (or display the raw data records for the corresponding cross tabular cell) only after the source information map has drill-through to detail enabled. Well, there are…

Create a fully summarized table for OLAP Cubes

SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one.
Included is a sample. The key option to set is the NWAY – this generates the lowest level of summary for use in the OLAP cube.

Essentially – the class s…

Create a fully summarized table for OLAP Cubes

SAS procedure SUMMARY is a quick method of converting your detail table to a fully summarized one. Included is a sample. The key option to set is the NWAY – this generates the lowest level of summary for use in the OLAP cube. Essentially – the class st…

Star Schema Options in OLAP Cubes

In the past couple months, this scenario has occurred twice. So thought I’d share a quick remedy ~ and save for my future reference when this occurs again :).
In Star Schemas, there are sometimes occasions where the data quality isn’t exactly perfec…

Star Schema Options in OLAP Cubes

In the past couple months, this scenario has occurred twice. So thought I’d share a quick remedy ~ and save for my future reference when this occurs again :). In Star Schemas, there are sometimes occasions where the data quality isn’t exactly perfec…