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.