473,326 Members | 2,102 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Remove unused members when creating 2005 local cubes

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
Mar 19 '08 #1
0 1315

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else...
7
by: Will | last post by:
On the subject of Data Warehouses, Data Cubes & OLAP…. I would like to speak frankly about Data Warehouses, Data Cubes and OLAP (on-line analytical processing). Has it dawned on anyone else...
0
by: Achim K?nstler | last post by:
Hi, hat jemand Erfahrungen gemacht in Sachen "virtuelle Cubes" ??? Wir überlgen ein Projekt aufzusetzen, dass ca. 6.000 virtuelle Cubes enthalten soll? Wie steht es um die User-Verwaltung ?...
0
by: AOstarello | last post by:
Hi all, I'm trying to link to some OLAP cubes that were created using the MS SQL Server Analysis Tools. The cubes reside on an Analysis Server. I'm trying to find a simple way for users to...
7
by: sanjana | last post by:
hi i wanna detect if a anything is connected to the usb port I am using system.management class for tht purpose this is my code class usbdetect { public static void Main() {
0
by: aggc | last post by:
Hi, I'm learning how to create cubes in SQL 2005 (Analysis Services). So, i supose that my questions will be silly questions, but i didn't understood why my cube had that beahvior. Two small...
3
by: Tom McL. | last post by:
Is there a way I identify and remove unused variable within vb2005 standard edition
12
by: zacks | last post by:
Suddenly, in a VB2005 project I am working on, several variables show up in the list of warnings are being unused local variables. But they all are. Several of them are the ex variable used in a...
1
by: karlid | last post by:
hi, For some reason one of my sites is throwing an ugly error message when I deploy it to a remote server. The error looks like this: "Failed to generate a user instance of SQL Server due to...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.