cancel
Showing results for 
Search instead for 
Did you mean: 

Loading and query performance issue with seventeen crores records

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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