Skip to Content

extremely long execution while cube data view

Hi experts!

My issue:

I have infocube zEsncub. It contains only 100.000 records and 10 requests in admin panel.

while I am execute infocube data view in RSA1, my query to cube hangs in DB and doesn't give any reaction.

Selection Creterias:

zYear = 2015

zMonth = 09

zBus_area = 0001

BUT! If I delete char "zMonth" from Selection Criterias and execute, then query works fine.

All these chars are in one dimension of cube.

I can't undestand such behaviour. Please help me solve this problem.

Indexes and statistics in cube are green.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 16, 2015 at 11:23 AM

    Hi Sergey,

    Can you enable the 'Use DB aggregation"' and  then view the data ?

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2015 at 11:50 AM

    Hi Sergey,

    You can go with indexing the cube, you can delete the index and recreate it.

    Regards

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2015 at 12:01 PM

    Hi,

    Instead of having all the characteristics in one dimension, you can split the characteristics and define the dimensions, "Multi dimensional modelling".

    Regards,

    Priya

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Priya,

      I agree with you, Multi dimensional modelling is right way of Cube design

      But it's Prod system and this cube is very old. There were no such issues earlier

      These chars have small SID table and cube is small (100.000 recs)

      Looks like DB issue...

  • Oct 16, 2015 at 12:22 PM

    are your InfoCube statistics up to date?

    (RSA1 > InfoCube > Manage > Performance > Check Statistics ==> this should ALWAYS be green)

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 12:23 PM

    Hello ,

    Can u try to create secondary index based on zyear zmonth zbus_area ?

    Go to RSA1> Infocube > Performance > Create Index

    let us know performance after that.

    Regards,

    Hitesh Gavande

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 16, 2015 at 12:52 PM

    Hi,

    can you create the aggregates on the cube for the zMonth.

    or

    create the indexes at cube performance tab.

    Add comment
    10|10000 characters needed characters exceeded