cancel
Showing results for 
Search instead for 
Did you mean: 

Split a value into two based on VERSION type in ODS

Former Member
0 Kudos

Hello Gurus,

I have a field in the cube called AMOUNT. It is plan or actual value based on a field called VERSION in the ODS.

Can you please tell me how to display two columns in the report (Acutal and Plan columns) from one field called AMOUNT in the cube, based on the VERSION field value in ODS.

Your responses are highly appreciated,

Thanks,

Regards,

aarthi

aarthi.sap@gmail.com

Accepted Solutions (1)

Accepted Solutions (1)

dielom
Active Contributor
0 Kudos

Hi,

You need to create two restricted key figures. In each put version filtered with corresponding values (actual and plan) and also put the amount key figure.

Hope this helps.

Regards,

Diego

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Diego,

I don’t have version field in the Cube. It is available only in the ODS. So, how to filter based on VERSION.

Hi Oscar,

Is there any way I can access the VERSION value from ODS in the report.

Thanks

Regards,

aarthi

aarthi.sap@gmail.com

dielom
Active Contributor
0 Kudos

Hi Aarthi,

Maybe using a multiprovider (dont figure how, because if the rest of the characteristics are the same, the value would be aggregated in the cube). But maybe you'll need to create the query from the ODS. Or, as oscar said, add the version field to the Cube.

Regards,

Diego

Former Member
0 Kudos

You can do a multicube with the cube and ODS, then you will see version in query definition, but it is no relationed with the amount.

You are loading cube from ODS, right? I think amount in cube is result of summing actual and plan and because of that you want to split it, but in aggragation you have lost this split.

the best solution is to add a new dimension to cube with version char, then you will have splited the amount into actual and plan.

Former Member
0 Kudos

You should add version to your cube too, else how you identify which value is actual and which one plan? which is the relationship between amount in cube and version in ods?