Report Portal

Inferred members in SSAS2005

This is about you can handle new fact records that have one or many dimension keys that is not part of your dimension table or a dimension key is null or blank.

Either you can solve this in the ETL process by adding an inferred member in each dimension, like 'N/A' or 'unknown', or you can let SSAS2005 handle this.

This post is about the last scenario.

Read more...

Tags: mdx

 

2007-2015 VidasSoft Systems Inc.