Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Analysis Services (2000)  Filter Virtual Dimension Level Members

Author  Topic  gvk013 Starting Member 2 Posts Posted - 2004-09-15 : 07:27:29 Hi I have a problem with creation of a Virtual Dimension. I have a Shared Dimension with three levels (Organization, Department and Employees). Under an Organization I have as many as 5 departments with its respective employees. I want to create a Virtual Dimension with all the three levels but the Department Level should display only one member instead of all 5. I tried using the "All Member Formula" in the Virtual Dimension Editor, but was not successful..Maybe I was using the incorrect formula syntax (I am relatively new to MDX and any help would be deeply appreciated) Any Solutions... regards Gautham