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
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