Hello people
When I filter a dimesion the cube is too slow to refresh the data.
How to makes a cube really fast when I filter that or any dimension.
Thanks

Whether I set roles or non at all to my cubes ANY user can
connect and read data from them via excel.
Is this a known issue? Anyone else having this problem or
am I doing something wrong?

I am writting a online exhibitor management system.
My client can allow to modify their exhibitor's information, however, they
will like to create ne record instead of overwrite the current exhibitor's
information (exhibitor version control)

What have been experiences out there with indexed views? How are they
working for you? What method do you use to maintain them? What is
recommended for scenarios where there is a large # of updates to the
base table ... are there any issues with rollback tables filling up?

Hi to all...
I have three tables
                 Cards                                Card_Edition                                 Edition
                    CardID                               CardID                                         EditionID

Has anyone successfully implement partitioning on multiple columns? My
attempts produce the following error:
Server: Msg 4436, Level 16, State 12, Line 1UNION ALL view 'Test_pvw' is not
updatable because a partitioning column was not found.

I have two tables..
                                        Employees                       Department
                                 |  EmployeeID                        |  DeptI
                                 |  Name                                |  Name                    ...

Does anyone know if you can run reporting services using MSDE?  I am just trying to test out the new reporting services.

What's the best way to restore or create a copy of production db (15 GB) on
development server and also another copy on same sql server with different
name.
The copies need to be refreshed on a monthly basis.

I'm just embarking on a data warehousing project for the first time. I have
a good understanding of the general principles - dimensional modelling, fact
tables, ETL, data staging, cubes, etc.
I am interested to get feedback from people who have used BI Accelerator for

I need a whitepaper or link that help me on how to create
Datawarehousing using Share point portal 2003 and LOAP
thank you on advance

I'm news in Datawarehouse.
How to know the update and the insert in database for distribute them to
datawarehouse ?  SQL Server 2000 have an utilities for it ?
I use DTS for the first time to create the datawarehouse (and distribute all

Hi, I have a tech interview coming up for a team lead position for the data
warehouse/OLAP team.  I was wondering if some of you wouldn't mind posting
technical questions (anything related to SQL Server/Data Warehouse/OLAP) for
me to use as practice.

My Reporting Services installation failed reporting error
code 25619.
I can't find any suggested solutions to the error -
although it appears others have encountered it.

We have problem connecting from an ASP page to Analysis services. Here is
the scenario:
Architecture:
-          The environment consists of an IIS6 Web Server box and a SQL