I have a cube with a fact table containing sales data and multiple
dimensions.  I have Sales Geography dimension, Sales District dimension and
Sales Group dimension (and some others, which is irrelevant for this
question).

I need to start processing a as-database from my c3 code. Is there any way
to reach to the messages while processing. I want to be able to show, what is
being processed at each time.

I have several cubes in SQL 2000 that are all virtual with several
roles applied.  Is there a way to tell what users are hitting these
cubes and what they are pulling down?  When I right click the cube, I
don't even see the option for Usage Analysis.  Of course this is

I have a parent child hierarchy in a cube.
My relational data looks like this:
Client Code     Parent Code    Client Name   Billed
00001             00001              client A          100

I have built a cube that contains restaurant sales. The dimensions are
Branch, Date and SaleItem. The measures (Sales Quantity, Sales Amount etc)
all break down to the most granular level, except one: Covers. Covers is the
number of people that ate on a certain day, at a certain ...

I have developed an SSAS database using Visual Studio 2005. During
development I have been deploying the database to an SSAS server on our
network. Now I want to deploy the database to the live server that is not on
our network and I get this error:

The following query gives 'Items Sold' by Region & by State nicely. I want
to include 'Totals' & 'Grand Total'. Can the experts help with the MDX query
please?
SELECT

Installed SQL 2000 Analysis Services and AS SP4 into existing SQL 2000 server
in prep for Project Server 2007 install. SP4 readme says add Olap
Administrators Group to RepositoryUser role. How? I can see the
RepositoryUser role under msdb. In Properties, Standard is selected as ...

is there way how to improve this MDX query
member [Avg] as [Measures].[Count]/count([Atr1]*[Atr2]),
non_empty_behavior=[Measures].[Count]
select [Atr1].children  * [Avg] on 0, [Atr3].children on 1  from  MYCUBE

I have same name account but different domains having problems when one of the accounts is disabled or denied access to the SQL Server instance, especially in SQL Server 2000.
Please confirm me if this is true with Sql server 2000. If this is true then what would be best way to ...

Hi, I have a dimension for Accounts. These accounts have a start date
for when they are first active and an end date for when they become
classed as "Former Accounts". As "Former Accounts" they are still to
be included in some reports so they are not inactive.

Good day
I have a cube in which small amounts of fact data (sales) are imported
daily. We have one partitian which we process incrementally. The case could
exist, however, that the sales for a specific day for a specific branch might

I have a VB.NET application and we use to connect to Analysis Server
2000. My question is: do we need to Install Analysis services 2000 to
be able to connect the Server when we intall a VB.net Application.
because actualy if i install Analysis services 2000 the application

I have an SSAS project that has deployed and processed correctly from within
BIDS.
I have then used the deployment wizard to deploy the same database to the
same server with a different database name but using the same data source.

I am using excel pivot table to look at the cube but there are too
many dimension so there is lot of scrolling to find the dimension. Is
there any way I can group the dimension so it is categorized?
Below is the example: