I have fiscal year, fiscal year/period, fiscal year variant in the Time dimension in the MultiProvider.
Create a new query ontop of this MultiProvider. In query designer, I donu2019t get to see the Fiscal Year Variant in the Time dimension. When I drag-and-drop the Fiscal Year into Filter section, the Fiscal Year Variant is appear. However, I canu2019t restrict the Fiscal Year Variant in the Filter section.
Have this problem before but canu2019t recall how to resolve, please help.
This is a classic case of compounding infoobject, if I get the picture correct. If you notice in RSD1 for 0FISCALYEAR, you have the compounding as 0FISCVARNT. So, that's the reason for this issue. Case A : In the display properties of on fiscal year in BEx, try to check an option to display with or without compound key. Try changing Show Key only. Case B : Keep Fiscal variant in default layout with display setting as 'No Display'. Hope that solves your issue.
"...Fiscal year is compounded with Fiscal year variant... once you drag the fiscal year the IO fiscal year variant automatically gets added..".
Yes, that's correct. But I can't restrict the Fiscal Year variant... that's my problem. When I right click and select restrict, nothing happen.
As Fiscal year variant is compounded with fiscal year, if u drag d same you will get fiscal year variant too.
Do restrictions for fiscal year as per your requirement and now for fiscal year variant also make restriction with the any one regular variant value, like v3. It will solve your issue.