Skip to Content
author's profile photo Former Member
Former Member

Split a value into two based on VERSION type in ODS

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Oct 02, 2006 at 04:44 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2006 at 04:44 PM

    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?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 02, 2006 at 04:49 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.