Skip to Content
0
Former Member
Jan 31, 2007 at 10:12 AM

Performance Query vs Cube Volume

18 Views

Hi All,

Question :

I am implementing a conversion unit logic during data upload into infocube.

2 possiblities :

- Have one specific key figures quantity per unit of measure : QTCS, QTBT, QTPAL ...

- Have one key figures, and convert and duplicate record during upload :

QT = 10, UNIT = CS

QT = 5, UNIT = BT

QT = 0.2, UNIT = PAL

The second possibility give more flexibility at query level for end user, but the impact is that the data volumetry is multiply by 3.

Is there any rules which give you the possibility to estimate the impact of the volumetry on the query runtime ?!

Like If datavolume * 2 => query runtime * .2 ?!

Thanks,