Fiscal year variant must be uniquely defined

[former_member554540]

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

[Former Member]

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

[Former Member]

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

[former_member554540]

Hi,

Thanks for reply

I have to show values of current year and last year sales which are on FYV AA and I should also show the value of forecast which are on FYV BB.
So i have to create a structure in rows with Current year sale, last year sales, Forecast value and forecast qty.
And in rows i created twelve rows for 12 periods.
So for Current year and last year my restriction would be "Billing value" FYV "AA" year = current and for previous year "Billing value" FYV "AA" year = previous from cube actual cube.
For forecast value and forecast qty my restrictin would be "ZFORCVAL" FYV "BB" and ZFORQTY" FYV "BB".
I am not defining two variants in one cell. Different variant in different cells. Hope i am clear.
Actuall i dont need to put fiscal year variant on the Filter but query is giving msg tat it should be unique.

Thanks
Srikanth

[Former Member]

Hi Srikanth,

I tried in a test bex query and I can use 2 different Fiscal variants , but I also kept those 2 variants in Filter tab.

So, you can try and add the fiscal variants in Filter tab also, hope it may work for u .