Blogs

Blogs

Special request for star schema OLAP cubes

2
By

When creating an OLAP Cube from a Star Schema table, the Dimensions / Hierarchies created must be free of all blanks. This is because the name is used as a table alias in the SQL Join.

The obvious error in the resulting code example below:
proc sql; create table geography dimension as select city, state from dimension_table geography dimension inner join fact_table on geography dimension.id = fact_table.id;

Tags business intelligence OLAP
Share

About Author

Angela Hall

Senior Technical Architect

Angela offers tips on using the SAS Business Intelligence solutions. She manages a team of SAS Fraud Framework implementers within the SAS Solutions On-Demand organization. Angela also has co-written two books, 'Building BI using SAS, Content Development Examples' & 'The 50 Keys to Learning SAS Stored Processes'.

2 Comments

Back to Top