Hi

I am trying to connect MS Excel to the SQL SERVER's Cube using the Pivot Table and Pivot Chart Wizard

There are five cubes in my SQL SERVER Analysis server's database but when I am connecting it to Pivot Table then it is showing me only 1 cube out of these 5 cubes

Out of these 5 cubes there are 2 virtual cubes and all the cubes are stored as MOLAP

Can somebody help me to find out why Pivot Table Wizard is not showing me remaining 4 cubes

Thanks in Advance

Amit Pal Singh

Amit Pal Singh wrote:
Hey Amit

You might want to try installing Pivot Table Services (PTS) on the
workstation. You can find it when extracting SP3 for Analysis Services. The
file is called ptsfull.exe.

--
Michael Barrett

If you do not process them first you will not see them.
Make sure you reprocess the cubes after making your
changes.

-mike

it is showing me only 1 cube out of these 5 cubes.