Query not drill down

[Former Member]

Hi

We have a queres primary sales,stock statement reports etc...... on 0ic_c03 cube ( we have some free chars in these queries ) when i dril down freechars like(family,brand,segment,plant,.....) its take some chars are not dril doened

Where i have done mistake wht are the performence issue

Urgent plz

points awarded

Regards,

Ogeti

[Former Member]

You might have larger cubes or it could be the problem with BIA. (if you have BI Accelerator)

Creating aggregates could solve this probelm. Suppose a cube has 100000 records you can create aggregagtes for your perticular drilldown selection so that query has to go through only 20000 records. This increase the performance of query significantly.

Hope this helps.

[Former Member]

Please make sure that you have included these characteristics in your query first....it should not be lying in the free charcteristics area. Secondly, you can drill down to master data object or a navigational attribute in your query.

Thanks..

Shambhu

[Former Member]

Hi

In my report we have the flollowing free chars

there is ni navigational attrs

Brand

Class

Customer

Family

Material

Plant

Segment

Size

Here plant is the hierarchy

All are drill downed after a long time (30mins)

when i drill down brand, sieze after along time it will disconnected

[former_member184494]

Ogeti,

Looks like either the material master is too large or your cube is too large . You can ideally compress the cube and see if performance improves or look at having aggregates for the same.

Another option would be to try for a smaller selection of data and see if the results come out fine - maybe a smaller selection for plant on the hierarchy.

Also check the query read mode in RSRT.

Arun