on 04-19-2011 11:31 AM
Hi Experts,
I am facing performance issue with Infocube Loading and Query execution. cube contains crs records. loading is taking much time and user runs the report in production it is running for hour and later timeout error they are getting. But I am in development. I dont have access to production. only Delete index and create index is maintained in process chain. no aggregates exists.
Thanks in Advance,
Sivaram
Edited by: sivaramB on Apr 19, 2011 12:36 PM
Without further information it's impossible to suggest something. As a generic answer I can just say that you should check the database parameters (against the note for your version, you didn't specify anything).
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Markus,
It is SAP 3.5. When I check the dimension table size with the standard program "SAP_INFOCUBE_DESIGNS" , there is 2 dimensions with ratio % is more than 20% of the fact table. the Dimensions results are below
ZGFTSSS12 Document Line (Records in Dimension Table : 43,406,746) (From SE11)
ZGFTSSS19 Tax Line Item ( Records in Dimension Table :177580,382) (From SE11)
ZGFTSSS1 /BIC/DZGFTSSS12 rows: 39,424,210 ratio: 25 %
ZGFTSSS1 /BIC/DZGFTSSS19 rows: 161444,280 ratio: 102 %
Please suggest me how to proceed.
Thanks in Advance,
Shivaram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.