8 Replies Latest reply: Feb 28, 2012 3:56 AM by p m RSS

filter

p m
Currently Being Moderated

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.

  • Re: filter
    Prakash Sahu
    Currently Being Moderated

    Hi,

     

    Go to SM12 and delete lock entries for this BEx report. Close the BEx designer and login again. Now try to give the restriction on fiscal variant.

     

    Hope it helps.

     

    Regards,

    Prakash

  • Re: filter
    p m
    Currently Being Moderated

    I have done that for 3 times, not help.

    Any clue??

  • Re: filter
    Arun Bala
    Currently Being Moderated

    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.

  • Re: filter
    Prashanth Konduru
    Currently Being Moderated

    Fiscal year is compounded with Fiscal year variant... once you drag the fiscal year the IO fiscal year variant automatically gets added.

     

    your issue has nothing to do with the SM12 locks...

    • Re: filter
      p m
      Currently Being Moderated

      "...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.

       

      Any clue?

  • Re: filter
    chaitanya prasad
    Currently Being Moderated

    Hi,

    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.

     

    Thanks,

    Chaitanya.

  • Re: filter
    p m
    Currently Being Moderated

    because you have constant the Fiscal Year Variant in the MulitProvider!!! Dont do this!!!

Actions