var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: OLAP - custom member formulae
I have a parent-child dimension in in an OLAP database. With some members I only want to aggregate a certain percentage of the measures in the fact table.
I know I need to create a column in the underlying dimension table to hold an MDX expression, but what is the syntax of the expression?
I have tried: H_Cons.& * 0.33 and Measures.[value] *0.33 etc etc.
All I get is #ERR when i browse the cube data post processing.
I have found an example in the Foodmart database but it doesn't bear the slightest resemblence to what I am trying to do.
Anyone got any ideas??? Maybe an example???