Skip to Content

Fiscal year variant must be uniquely defined

Hi Gurus,

I created a report that has data from actual cubes and planning cubes. Fiscal year variants are different in both the cubes.
I created a structures and using cell references I created formulas. In filter section, I put fiscal year variant and restricted two variants.
When trying to save the query, I am getting the error message "Fiscal year variant must be uniquely defined". I need this two variants in the report.
Any kind of help is really appreciated.

Thanks
Srikanth

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 09:24 AM

    Hi Srikanth,

    I am not sure for what purpose u want to create this formula for a cell.

    System cant calculate for single cell for 2 different Fiscal Variants.

    so u have to define it uniquely.

    If I m not correct, explain a bit more about your usage of FV in a cell.

    Thanks,

    Balaram

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2014 at 10:21 AM

    Hi Srikanth,

    I would recommend you to try the following steps:

    1. Create a planning area with a specific storage bucket profile that has the fiscal variant attached

    2. Activate the planning area

    3. Now got to SE16 and open table /SAPAPO/SDPTSTR. Go into edit mode for the storage bucket profile from step 1. try changing the fiscal year variant.

    4. Reinitialize the planning area with the same time bucket horizon.

    5. From step 1 to 4 ensure there is not one logged on to your planning area.

    You may try this with the actual planning area.

    Regards,

    Baskaran

    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.