Wednesday, August 22, 2012

SAP-BI@Reporting

Reporting:-
----------
* BEx ( Business Explorer )
Components:-
-------------
* Analyzer - To Design, Change, Execute, Delete BEx queries by Using a Component - Query Designer.
* Browser - To Organise the Reports.
* WAD (Web Application Designer ) - To Design Web Reports.
Note:-
-----
1) Info Provider
2) Data Target
3) Data Provider
(All Data targets are Info Providers but all Info Providers are not Data Targets)
Analyzer (MS Excel with ADD-ON Components):-
-----------
* How to Design a Simple BEx Report?
------------------------------------
* Understanding the BEx Report Output.
----------------------------------------
1) Title of the Report
2) Navigation Block
3) Result Set of the Query.
* Query Execution Process:-
---------------------------
When we execute the BEx query it triggers the OLAP Processor and this identifies the Info Cube on which the BEx report should be executed on and triggers the query on to the Info Cube and selects the records and aggregate the records based on the Characteristic Values in the OLAP Processor and transfers the records to the Front end (BEx).
* Complex reporting with all the Aspects:-
------------------------------------
* Characteristic Properties:-
------------------------------
1) Heading of the Coloumn
2) Display as
3) Suppress Result Row
contd....
* Key Figure Properties:-
--------------------------
* Query Properties:-
--------------------










Labels: , , , , , , ,

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home