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

Need to Create a Last 12 Months Variable for Custom Dimension

Hi everybody

Once again, I need your good help for an issue I'm facing. In one of our Cube, we have some Date Dimension sthat we've created ourselves (a ZCXXXXX dimension). For one Dimension, Ii need to create a variable that is giving me, automaticaly, the Last 12 Months excluding Current Month (same as the 0CML12LM provided by SAP) without any manual entry done by the user via the Variable Entry Screen.

I don't want to use offset because I don't want to allow any Manual intervention for my users because it is a report start via RRI.

Please let me know if you are aware on how to do this!

Thanks

Eric L.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2004 at 09:38 PM

    Hi Eric,

    As far i understand you need to display only the data for last 12 months and there should be no manual intervention.

    Create a custom structure and select the custom date characteristics and restrict it only for the last 12 months or only those you need?

    ASSIGN POINTS if this helps

    arun

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Arun

      My problem is that my report is counting Incident per supplier per Month. We have a Key Figure that is doing the Total of incident with a Vendor Variable. So, for a given supplier, if there is no incident for the Incident Month, it won't display in the Result Page. Also, My report is dynamic so I'can not fix a Structure. On the other hand, I never used Strucutre, so I'm not really aware on how using this and if it will answer my need.

      If you can give me more details, maybe I'll be able if a Structure is my solution.

      Regards

      Eric L.

  • author's profile photo Former Member
    Former Member
    Posted on Nov 23, 2004 at 10:17 PM

    Hi,

    I have provided the link which explains about how to create structures and its properties.

    http://help.sap.com/saphelp_bw31/helpdata/en/f1/0a5a2ee09411d2acb90000e829fbfe/frameset.htm

    Under Query Design : BEX query designer --> Structures.

    Hope this helps

    arun

    Add a comment
    10|10000 characters needed characters exceeded

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.