Post a Reply Start New Message

Weblog:    An Experience with SAP TechED’06 Session at Bangalore – BIM205
Subject: comments from my friend - Jaspreet Singh (on SDN Forum)
Date: 2006-12-13 22:40:20
From: Vikash Agrawal  Business Card


And I Quote -


"This is what I have to say about the 3 points that you have raised :


Ratios of times: There cant be a fixed ratio, as it will be subjective to the kind of requirement. For Eg. I have a cube which stores Inventory Data on a Plant/Matreial/Calday level. In this case it has to read a lot of data from the cube. So, if i try to Calculate a Ratio of Database Read Time : Olap Time : Front End Time , it will be more Skewed towards the Data base read time, as it is this activity which takes more time. Olap Time and Front End Time would be relatively less and would be proportional to the No of Records processed. In my experience to improve the time, if i target the Database Read time, it is more beneficial ( as can be seen in the case of Bex Accelerator). If i Target improving the Front End time, There isnt much that i can gain from it(and there is not much of flexibility that i have there ). Even for that sake , Olap Time cannot be improved beyond a certain limit."


Thanks Jaspreet for his comments.


Regards
Vikash


Previous Message Previous Message Next Message Next Message

SAP, mySAP, mySAP.com, xApps, xApp, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All other product, service names, trademarks and registered trademarks mentioned are the trademarks of their respective owners.