cancel
Showing results for 
Search instead for 
Did you mean: 

Maximum number of conditions and exceptions possible in a query

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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