I am trying to sort a dimension based upon account age.  Due to activity
occuring before an account is considered active, I have negative values.  I
need to display these negative values in this dimension, however, negatives
are not sorted correctly.  Sorts occur from left to ...

I can use windows domain user to update cube (dimensions, mesures, calculated
memebers) but it did not work when I tried to process aggregations to improve
the performance.
It seems this action requires different permisssion. Sometimes, it says you

I'm an Business Intelligence student and trying to do a cube assignment
using September CTP of SQL 2005.  When I try to browse my deployed cube by
dragging any field from the cube attribute list into the data pane I get the
following error:

My dataware house is changing daily.
How can I schedule automatically processing cube to reflect this change
if it is doable?
Thanks,

I am new to OLAP and I was wondering if it is possible to create a dimension
in Analysis Services 2005 based on a range of values for a given field in a
Fact table.
Example:  

How can I get data and structure of a table on SQL Server 2000 on a machine
to re-build that table on a separated machine? I am building tests and I
don't want to mess up with the original one.
Thank you,

Dave Wickert, if you're out there...
I posted this question before, but would like to know if there is a way to
keep domain admins from viewing cube data from Excel. I tried creating roles
and preventing access by restricting dimensions in MDX expressions, but they

I got problem when trying to add two exactly same time hierachies to a
dimension.
There are two fields StartTimeID, and EndTimeID, which point to Time
dimension table by TimeID. I would like to use these two time hierachies to

I am getting an error that says, "Unable to edit the virtual cude 'XXXXX'
User XXX\XXXX on computer XXXXXXX has locked 'XXXXX'.
Description: Virtual cude editor has locked cude 'XXXXX' for writing.
Anyone know how to fix this?

Is there any suggestion to migrate beta 2 AS db to beta 3 AS db?
I tried to use backup and restore, and it did not work.
I have lots of MDX. I do not want to recreate AS in beta 3. U know, it is
lots of work from scratch.

My fact table has a field QtyReleased. I would like to know the number of
records with QtyReleased > 1000.
Can we do this in SQL 2005 by MDX?
Guangming

what is most important to focus on when we choose a drive setup to support a
small datawarehouse?
(10GB and less)
IO/Sec

I have a role-based cube, but Domain Admins can see cube data. Is there any
way to prevent them from viewing the data?

I installed the SAS ODBC-driver 9.1 and can choose the SAS tables (datasets)
but then I get this message:
"Ad hoc access to OLE DB provider 'MSDASQL' has been denied. You must access
this provider through a linked server."

  What is the diff within Char and Varchar ? If define Char(10) in TableA
and this field is store the State code and the length is a non standard. User
can key in the length from 1 to 10.
  Understand that I should define this field as VarChar(10) because is it a