Report Portal

Inferred Members Implementation Best Practise

Just last week Paul Hales and I did a very thorough research on the best implementation practises in regards to Inferred Members. We went through a few web sites and we also had a look at previous implementations through SSIS. There are quite a few resources on the subject and the best two methods we found were based on Project REAL and a SQL CAT recommendation. So, in the end we agreed that we can recommend three approaches, which have their advantages and disadvantages and could be all successfully used when we need to have Inferred Member (early arriving dimensions = late arriving facts) support in a solution.

Read more...

Tags: design

 

2007-2015 VidasSoft Systems Inc.