Skip to Content
Former Member
Oct 11, 2004 at 09:02 PM

Problem with Aggregate creation



I have a multiprovider which is built on two basic cubes. I would like to build aggregates on these basic cubes based on the query designed on the multi provider.

I have selected the ststistics settings for all these objects by going to (in RSA1) "tools -->BW Statistics for InfoProviders" and selected both the OLAP and WHM flags for these. And then I ran the query that is built on the Multiprovider.

And when I tried to create aggregates on one of the basic cube, I asked to "Generate Proposals" and selected run time greater than 0 sec. But, strangely the system did not create any proposals.

Am I missing something here. Please advise.