Star Schema Options in OLAP Cubes

2

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 perfect. And sometimes, for some users/companies, this is acceptable. By default, SAS will not allow missing dimension keys into OLAP cubes and generate an error and stop processing altogether. However if missing dimension keys are okay for your situation, click the Advanced button on the initial edit/create cube screen, move to the Star Schema Options tab and select something other than 'Print the error & stop processing'.

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'.

Related Posts

2 Comments

  1. Harry,It would be nice to have that information immediately in the proc OLAP log. In the meantime, here is a quick example of how to retrieve the missing keys using a proc SQL statement. The work.keys table was simply the dimension table example with a missing key (select distinct region from sashelp.shoes where region ne 'Canada'). The sashelp.shoes table would then act as the FACT table.proc sql;select distinct shoes.region, keys.region as regionkeyfrom sashelp.shoes full join work.keyson shoes.region = keys.regionwhere regionkey = '';quit;~ Angela

  2. Angela:I've sent a couple suggestions to SAS Tech Support regarding the missing dim key issue. It'd be really helpful to have an option to create a dataset of the fact table rows that have dimension key issues, and/or display in the log how many fact rows were affected by the dim key not found.

Leave A Reply

Back to Top