reporting

[Former Member]

hi gurus,

How can we know whether the report is generated from cube or from its aggregate?

sunil

[Former Member]

Hi,

reports will use aggregates at the time of query run time, if a cube is having aggregates then you can check weather those aggrs are used by query or not with help of RSRT -> debug + execute -> select aggregates option. in otherway you can goto info cube -> maintain aggregates screen -> here you can see valuation option -> if it is positive those aggregates are used by the query if not those aggregates are not used and those are wrost aggregates.

Regards

Sankar

[Former Member]

Hi Sunil.

You can check this in TA RSRT -> Execute and debug -> Display aggregate found.

Hope it helps.

BR

Stefan

[Former Member]

Hi Sunil,

Depending on the characteristics in the query. If all characteristics are in the agregat the report is based on its agregat.

I think, it doesn't exist an other way to know that.

Hope this helps.

DP