Shyam Patil’s DECK

It’s all I see happening around me!!!!!!!!!

SAP OLAP Cache – Reporting Agent

OLAP Cache is very important to increase query performance.  It can be done on Queries that is created using BEx Query Designer or Web Templates that is created using BEx WAD or the Queries that are published on Portal (iViews).
For executing an particular Query if the Query data is in OLAP-Cache then the performance is much better then to get the Query requested data from the database.

To access Reporting Agent or in BI 7.0 type REPORTING_AGENT
GoTo T-Code RSA1OLD | Click Reporting Agent | Click Print – This will show all the query and reports|
Drill down to a particular Report | HighLight this report | Create New Reporting Agent Setting | Give name & Description | Check Fill OLAP Cache if possible | Save and Activaate
Go Back | You will see one Reporting Agent create | Select the newly created Reporting Agent | on the Right Hand side Column | Create New Scheduling Package by clicking on Create Button | Give name and Description | SAve

Now Drag the Reporting Agent to the right Hand side the Scheduling Package Windows.Save.
Schedule Immediately.

August 14, 2008 - Posted by Shyam Patil | Uncategorized | | No Comments Yet

No comments yet.

Leave a comment