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

Maximum number of conditions and exceptions possible in a query

Hi Gurus,

I would like to know where it is possible to create more than a single exception or condition in a query. If it is possible, then are there any other implications that may result as far as data is concerned?

Also, is there a limit on the number of exceptions and conditions one can create in a single query?

Thanks

Deepthi

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2008 at 03:15 PM

    Hi deepthi,

    Exceptions are just the alerts showing abnormal values in Colored cells.

    So you can define one Exception for each key Figure.number depends on how many Key Figures that you have in a query.

    Reg.Conditions,you may define more than one condition,but there should not be overlapping between the conditions

    Ex: You have defined a condition to show TOP 10 Customers based on Quantity.Again If you define a condition like TOP 10 Customers based on Price,it will be difficult for query to execute it.

    Hope this helps

    Sriman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2008 at 08:57 PM

    Sriman,

    Thank you! your answer definitely makes it more clear.

    But I am still not convinced with multiple exceptions in a query. How will the user identify that Exception1 is for kf1 and exception2 is for kf2?

    I observed that the entire row of data gets the color coding based on the exception we set. So that row will include kf1 and kf2.

    Please correct me if I am wrong

    Thanks

    Deepthi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Deepthi,

      The Entire row may not get colored.Only the Key figure value display will be in Colour.

      Ex: 1.You defined Exception as for Quantity Between 10 -100 Show as RED..Quantity values will be shown in RED if they fall in that range

      2.In The same query ,you can define one more exception for your another Key Figure say PRICE.If you define like for values between 1000 -1500 to show as Green,Then the price values in that range will be shown as GREEN

      You may also need to select that Exception will apply only for particular structure element,not for Characteristics in Row

      Hope it helps

      Sriman

      Edited by: Sreeman on Apr 10, 2008 6:04 PM

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 12:08 PM

    Dear Deepthi,

    You can use exceptions to evaluate one or all key figures (structure elements) in your query definition. If you want to use exceptions selectively on specific key figures in your query definition, you have to define an exception for each key

    figure accordingly.

    On the Display tab of the exception definition you have control over which cells of an analysis receive the color for the determined alert level. If you select the checkbox for Exception Affects Data Cells, then the following choices can be made

    Key Figure Choice Result

    Evaluated Structure Element

    The structure element chosen on the Definition tab will

    be the one to receive the color assigned to the alert level.

    All Structure Elements

    Regardless of which structure element is being evaluated

    in the exception, all structure elements will receive the

    color assigned to the alert level.

    Following Structure Element

    With this setting, you can evaluate one structure element,

    but then apply the color of the alert level to a different

    structure element.

    If the checkbox for Exception Affects Characteristic Cells is selected, then you can select from the following options:

    Characteristic Cell Choice Result

    Rows

    The color of the alert level determined by the exception

    is applied to the characteristic values in the row where

    the exception occurs.

    Columns

    The color of the alert level determined by the exception

    is applied to the characteristic value in the column where

    the exception occurs.

    Rows and Columns

    The color of the alert level determined by the exception

    is applied to the characteristic value in both the column

    and row where the exception occurs.

    Hope this information helps u...

    Assign points if needful...

    Best Regards,

    VVenkat.

    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.