Skip to Content
author's profile photo Former Member
Former Member

Problem with restricted key figure

Hi guys,

when I'm defining a restricted key figure for example turn over for the past six months the restricted key figure is shown like defined.

When the restricted key figure is used in the columns the restriction for the months doesn´t appear!

The restriction is done by selection of the key figure turn over and then the characteristic time for the last six months (-6).

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 05, 2010 at 07:06 AM

    Hi,

    Check whther calmonth availble or not . if it is available try to create a variable on calmonth.

    Regards

    sivaraju

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 05, 2010 at 01:52 PM

    HI,

    When you define the Restricted KF on the Multiprovider globally and use it in the Query Columns / Rows you will not be able to see its induvidual restrictions.

    But when you try to edit it in from teh lect hand side under the folder restricted KF, yuo can see the restrictions.

    But it works the same.

    Regards.

    Shafi.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      After expanding the 'Restricted Key Figures', once you drag and drop your restricted keyfigure into column, it will not show any restrictions in it. But when you execute the query after saving, the query results would work perfectly fine as per your restrictions.

  • author's profile photo Former Member
    Former Member
    Posted on Jul 06, 2010 at 11:27 AM

    Hi,

    Correct me if wrong, but what I believe is have you have placed a KF (turnover) & a restriction (M-6) in the same selection?

    You can create dynamic offsets, ie. M-6 for a 0CALYRMONTH variable. But you must not restrict it with key figure, else due to drill down, formula collision happens during slice/dice.

    To avoid such irrelavancies, try optmizing the query, by giving the CALMONTH filter at global level i.e. either at 'Default Values' (where you may change at runtime) or using the 'Charactheristic Restriction'

    Anything would be working fine.

    Thanks,

    Arun Bala

    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.