Guest_imported
New member
- Jan 1, 1970
- 0
I've got some questions re best practices for BO. My environment uses two star schemas joined by conformed dimensions. Not totally clear from the manuals how you would model a generic universe for the following. Sorry for all the questions in one post!
1. semi-additive measures. Can I automate the process whereby a measure is automatically managed as semi-additive? What if I have two dimensions in my mart where the measure might be semi-additive over?
2. fact sparsity. some of my users might author reports where there are no facts - can they (without editing the SQL) denote that they want all customers including those without sales?
3. how do I denote that I have two marts at different grains and get BO to automatically rollup up or allocate down the measures?
4. how can I create a 'period-average' measure - i.e. I need to divide the sum of a measure by the # of members in the level in the dimension (i.e. months in the quarter) without hard coding the #? Can I make this more dynamic and allow my user to request an average or perhaps the end of month balance instead?
1. semi-additive measures. Can I automate the process whereby a measure is automatically managed as semi-additive? What if I have two dimensions in my mart where the measure might be semi-additive over?
2. fact sparsity. some of my users might author reports where there are no facts - can they (without editing the SQL) denote that they want all customers including those without sales?
3. how do I denote that I have two marts at different grains and get BO to automatically rollup up or allocate down the measures?
4. how can I create a 'period-average' measure - i.e. I need to divide the sum of a measure by the # of members in the level in the dimension (i.e. months in the quarter) without hard coding the #? Can I make this more dynamic and allow my user to request an average or perhaps the end of month balance instead?