Drill-through to detail is the ability to right click within a cell of a web report or OLAP viewer and request the detail source records that make up that specific cell’s measure. The maximum number of records, by default, is set to 300,000. Feasibly t…
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…
Making OLAP Drill Through to Detail Data Available as Dataset in EG Project
In order to make the OLAP drill through data available as data tables in the Enterprise Guide, all you need to do is change the option to automatically insert the results as a data set in the project. This is extremely useful if part of your workflow i…
Making OLAP Drill Through to Detail Data Available as Dataset in EG Project
In order to make the OLAP drill through data available as data tables in the Enterprise Guide, all you need to do is change the option to automatically insert the results as a data set in the project. This is extremely useful if part of your workflow i…
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…