Remove unused members when creating 2005 local cubes

Question posted by: =?Utf-8?B?RENvdW50MTc=?= (Guest) on March 19th, 2008 04:55 PM

I need to create a windows application in which I can programmatically create
local cubes from SQL Server 2005 databases using C#. I was able to do this in
SQL Server 2000, but I cannot get the same results after upgrading to 2005
because the CREATE GLOBAL CUBE command does not slice the data as it did in
2000. In other words, I get all accounts that exists in the company as
opposed to only accounts that belong to the user. This extra data kills
browsing performance.

Can this be done using XMLA or AMO? If so, any examples would be appreciated.
--
DCount

--
DCount

Not the answer you were looking for? Post your question . . .
184,038 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).