I need to create a windows application in which I can programmaticall y 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
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