Execution of MDX for ASO Cube
Summary
Execution of MDX for ASO CubeContent
Hi All,
We are loading a specific KPI via Data Management into ASO Cube. But this data needs to be multiplied by 1000.
This is a Store member, which also gets data from other Loads. How do i apply this conversion post data load?
In Cloud(PBCS/EPBCS), MDX can only be written as a member formula, since this member is loaded from other Sources as well i cannot set it with Member formula.
In Data Management, have an option of stating Factor=1000 in Source Expression, but that will affect all the Datacolumn and not just that one KPI.
Tagged:
1