Performance Query vs Cube Volume

[Former Member]

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,

[Former Member · Accepted solution]

Hi dear,

clearly it's better to have some additional KFs instead of adding a lot of records in your cube !

Anyway, what you ask (from a general point of view) is related to KF model vs. account model.

Hope it helps!

Bye,

Roberto

[Former Member · Accepted solution]

Dear Roberto,

From an user point of view, it's better to have selection the unit rather than selection group of specific keys figures.

If we always select one unit of measure the query will always select in the database the same number of record, we just add a additional selection criteria.

Is your answer based on your experience or on BW documentation ?!

Thanks,

[Former Member · Accepted solution]

Both.

Anyway, here you can have some more details:

http://help.sap.com/saphelp_glossary/en/62/d543cdb913d51188020090273d34cb/content.htm

http://help.sap.com/saphelp_glossary/en/31/014a919d13d51188020090273d34cb/content.htm

and here to have more info and a link to a useful doc:

Hope it helps!

Bye,

Roberto

[Former Member]

Thanks a lot !!!!

[Former Member]

Hi,

You can find it in the transaction RSRT.

Just go to the give your query name there and go to execute+ Debug and there you have option of "display stastical data".

Here you can see the number of records transfered QBTRANS and the time taken to execute the changes "QTIMELOLAPI" in the filds there

Hope it help

Thanks

[Former Member]

Dear Ajeet,

I am doing this kind of test and analysing result.

Thanks