Wednesday, August 22, 2012

SAP-BI@Reporting@Structures-CellDefinitions-RestrictedKeyfigure-NewSelection-CalculatedKeyfigure-NewSelection-NewFormula

* Structures:-
-------------
* Structures act as the reusable components.
* Structures can be used to provide hierarchical effect or Level Up - level Down effect in the report by using Level-up level down.
* we can only have maximum of 2 structures in a report.
* Structures can be of 2 types
 a) Local
 b) Global
* By using the option 'Remove Reference' changes what we do for a global structure will not be reflected to other queries where it has been used.
* Cell Definitions:-
--------------------
* We can define Cell definitions only when we are using 2 structures in report.
* By using Cell Definitions we can do calculation or restriction specfic to a particular CELL.

* Restricted Keyfigure:-
-----------------------
* when we want restrict the value of a Key fugure based on the value of a characteristic.
* We can do restriction on Multiple characteristics.
* Restricted Key figure restricts only to a particular coloumn.
* Restricted key figure is global because once it is created it can be used on all the queries built on the same info provider.


*New Selection:-
----------------
* Same as Restricted Key figure but New selection is Local.
* New Formula:-
---------------
* Same as Calculated Key figure.
*Calculated Key figure / New Formula
------------------------------------
* Calculated Key figure is Global, New formula is Local.
* When compared to Calculated Key figure, New Formula will have 6 functions more.
* All Key figures can be used in Building Calculated Key figures but we can only use the key figures which are used as the structure elements in New formula.

* Restricted Keyfigure:-
-----------------------
* when we want restrict the value of a Key fugure based on the value of a characteristic.
* We can do restriction on Multiple characteristics.
* Restricted Key figure restricts only to a particular coloumn.
* Restricted key figure is global because once it is created it can be used on all the queries built on the same info provider.
*New Selection:-
----------------
* Same as Restricted Key figure but New selection is Local.
* New Formula:-
---------------
* Same as Calculated Key figure.
*Calculated Key figure / New Formula
------------------------------------
* Calculated Key figure is Global, New formula is Local.
* When compared to Calculated Key figure, New Formula will have 6 functions more.
* All Key figures can be used in Building Calculated Key figures but we can only use the key figures which are used as the structure elements in New formula.

Labels: , , , , , , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home