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

Fiscal Year in the columns outside KF structure

Dear Experts,

I have a manual Entry variable for Fiscal Year range.

In the query designer columns , I have a KF structure containing quarter level columns.

The FY is outside this structure. So, for each FY user entered in the FY range variable, the report will show the set of KFs at quarter level.

How can i refer to this FY values at runtime such that current date can be used to compare with the FY and Quarter in the columns?

The requirement is, if the current QuarterFY is less than the current QuarterFY, the TEXT variable for the columns should show 'Actual' else show 'Plan' .

I am not sure how to reference the FY range entered by user considering that the FY is placed outside the KF columns to automatically display all the FY entered by the user without the use of the FY range variable restricted in the KFs.

Please advise.

Thanks.

Bass

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, 2011 at 08:22 AM

    Can you elaborate it? What does "if the current QuarterFY is less than the current QuarterFY" mean?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Bass,

      Your KFGs(actual and budget) will be put in the formulas and hide your KFGs.Then you will show your formula for budget in the right time(i.e in the future i.e when current date Year-Quarter).To achieve this in the formula, you must create if-then statement of course.So you need Boolean operators and you need to compare current date and Quarter-Year combination.

      However, unfortunately this model does not work without 0calquarter.Because you can not compare the current date and Q1.You can only compare current date and Q1/2011 for example.So you need quarter and year not seperately but together.

      Here is a similar problem with dynamic field selection: dynamic-field-selection-by-variable-input-in-bex-r .You will see something about Boolean Operators(for if-then part) and formula variables with replacement path(to use a variable in the formula) in this thread.

      Regards,

      Sunny

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.