Aggregate Usage

[Former Member]

Hi Guys,

I had created an aggregate couple of days back.

The roll up is happening every day. I can find also find when it was last used in the aggregate maintainence screen.

However usage is displaying -ve. That means the aggregates is not effectively used. How can I use this effectively so that it will display the usage +ve.

The aggregate and report granularity is exactly same then why the usage is not +ve.

Please let me know.

Regards

[former_member194898]

Hi,

Can you be more precise ?

On what cube have you created your agregate ? Standard (business content) or custom one ?

How the agrregate is built. What characteristics it contain ?

Did you use expert mode while creating it ? If yes - it's possible that it works very fast despite low valuation. Some of my aggregates that are low valuated works very fast (I used expert mode while creating it).

Regards, Leszek