SAP-BI@Reporting@Restriction-Condition-Exception-

Restriction:-
---------
* When u want to restrict the output of the query for particular values of a Characteristic.
*Conditions:-
-----------
* When u want to restrict the all the coloumns of the query based on the values of a Key figure - Conditions.
* Active
* Can we build the Conditions for specific Characteristics - yes.
* We can build conditions only on the Structure Elements (Keyfigures used in Coloumns).
* We can even switch on/off the condition at the runtime of the query.
* We can have multiple conditions in a report.
* When we build a condition with multiple restrictions in it - it plays with OR and when we build multiple conditions with each of the restrictions in it - it plays with AND.
* we have used the conditions To design Top 10 Customers Report and Top 10 Products Report.
* Exceptions:-
-------------
* Exceptions are used to provider some alerts on the output of the report based on the values of a key figure.
* We can build Exceptions on only those keyfigures which are acting as Structure Elements (Keyfigures used in Coloumns).
* By using 'Cell restriction' tab we restrict the cells on which the exceptions should play.
* Using Exceptions would degrade the performance of the queries.
* When we were desiging the 'Profitability Analysis Report' we have used the Exceptions to play only on to result.