You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Execution of MDX for ASO Cube

Accepted answer
20
Views
6
Comments
edited Jun 11, 2021 4:28PM in Planning 6 comments

Summary

Execution of MDX for ASO Cube

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!