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

Header description and value problem

Hi,

Appreciate your assistance as i am very new to this tools and have encountered the following problem:

1) The column and row are using key figure.

2) The value in the column are directly using basic key figure values, ie 'A'.

3) User is expected to enter the fiscal year.

4) 3 header description shown, if user enter '2005', the following is expected:

col1 col2 col3

Header : 2005 2006 2007

Value: A AA AA+A

The header formulae will be f'iscalYear 1' and 'fiscalYear2' for the col2 and col3 respectively.

Now my problem is:

1) The value of col2 and col3 will not be appeared, if i include the fiscalyear selection formulae and refer to the same key figure 'A'.

OR

2) The Header description will not be reflected accordingly, but value can be displayed accordingly, if i use variable and 'exclude the fiscalyear selection' from the column key figure selection.

Couldn't reach the perfect solution. Can anyone here pls assist and really appreciate your advise. Thank you in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 09:25 AM

    Hello Claudia,

    I'm not sure if I completely understand the problem. I think you want to display the column headings based on the user selection. If that's the case then you just need to select a text variable for fiscal year in the column description. To do this just go to the column properties in query designer. You will see a variables icon next to the field where you enter the column description. Select the variable 0T_FPERT there for all the columns. Now the system will display the user selected value dynamically. Hope this helps.

    Sumit

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello, Thanks for the reply.

      However, i couldn't the variable name called &OT_OFPET& in my description variable list.

      Let me rephrase my problem:

      1) The column description is depending on the user entered-value, ie '2005'

      2) However, the 3 column value are expected to extract the same basic key figures with the formulae given:

      Basic key figure value: '100' for the reporting year 2005.

      Thus, the Yr 2006 - expected value: 100+100

      Yr 2007 - expected value: 100100100.

      pls assist. Thanks!

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.