Fiscal Year/Period Variable Offset!
We're in BI 7.0. Our Bex has SP 1.
I think variable offset is an issue in BI 7.0.
My first attempt was to try it with 'Calendar Day' (0CALMONTH) and it didn't work.
Then I tried it with 'Fiscal Year/Period'. I set two variable offset with -1, -2. I want to get 3 prev periods info including current period.
With Calendar Day, I didn't see any data in the analyzer which is not correct. There's data loaded for those months.
But with Fiscal Year/Period, I'm getting an error saying: "Unable to move variable_name; fiscal year variant is ambiguous'.
I read in the forum that we need fiscal year variant with fiscal year period. I'm not sure if I'm using it correctly.
Can some one please Please please help me with some clues/suggestions? Thanks a lot in advance!
Maybe it's not the time periods that causing the issue. What other characteristics have you set filters on in your query.
Is it worth removing any filtered values, run your query and start drilling in a characteristic at a time to see what the values are posted against?