Reducing the default OLAP Cube for faster querying

I

I-Ali

Extending the cube is covered in great details in this discussion group. I
have the opposite situation. I want to create an OLAP cube that should have
just one virtual cube (MSP_PORTFOLIO_ANALYZER) instead of three and have the
following measures (TOTALs) only: Actual Work, Actual Cost and Work instead
of 10-12 that come out of box.

One can do that by editing the cube in Analysis Manager. However when the
cube is updated again PWA -> Admin -> Enterprise Features -> UPdate Now. It
overwrites the cube and add back the 10 or 12 measures (Totals).

The reason I am asking this is because when you export to excel or copy the
OLAP data to excel from a portfolio analyzer view, it takes forever. It is
much easier to have the Portfolio Analyzer view query a smaller cube instead
of the huge default out of box cube.

Please let me know if you have faced a similar situation and your solution.

Thanks,
IA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top