Hi,
i am upgrading from analysis server 2000 to SSAS 2005. So far I have created
the shared dimension in SSAS2005, I havent created the cube. Now if i want to
compare the data in 2000 and 2005, How will I do it. Each Dimension has got
around 1000 members. So cant do the spot check in two screens. Is there any
way to import only Shared dimension in to Excel.

Also if I check the 2000 Cube in excel2003 I can see only the dimension
members which has got value. The other dimension will not display....is there
any way to get a full list of dimension over there.

Thanks in advance for any help in this matter

Regards
Sajith