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

Dynamic Column Headings

How do you get dynamic column headings in the following scenario. Note that the key figures are NOT restricted key figures. They are base key figures straight from the cube. This is a typical APO scneario.

Columns

=====

Sales - Current year xxx

Sales - 1 Year Ago xxx

Sales - 2 years Ago xxx

All 3 key figures have the same 0FISCYEAR value (2004). So when I run the query I need for the first column to say Sales - 2004, the 2nd row to say Sales - 2003 etc. based on a variable input of 2004.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2005 at 05:24 PM

    Replacement path would only work if the key figures were restricted by a fiscal year variable with offsets. As I mentioned, the fiscal year is the same

    I do not think you can do offsets with Text variables e.g &textvar&-1 will show up as 2004-1 not 2003 (the desired result)

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      You can create three text variables and fill them in the user exit. There you read the variable for 0FISCYEAR and subtract 1 or 2 depending on the variable.

      If you need help with the coding just ask.

      Best regards

      Dirk

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2005 at 03:34 PM

    mike

    create three new selection with variable for year (value interval).

    insert offset -1 and -2 for selection 2 and 3(right mouse on the variable)

    alessandro

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 10, 2005 at 04:04 PM

    You can do this using text variables. Create a text variable, processing type is replacement path and the characteristic is 0FISCYEAR. Use this text variable in teh description of your column: Key figure > right click > Edit > you see the description box and next to that is the button from where you can create / select a text variable. When you use the text variable in the description, you will see something like:

    Sales &FYTEXT&, where FYTEXT would be the name of your text variable.

    Hope this helps...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2005 at 04:11 PM

    mike,

    naturally in the definition of new selection you must insert Sales - 'textvariable'

    alessandro

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 02:16 AM

    I was thinking of that option as a last resort where in step 2 of the exit I derive the other text variables based on user input of one text variable. I was hoping there was a more elegant solution.

    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.