Hey Phil,

I think the problem is probably in where the *100 is.  Have you tried {([Dim1].[All].[Yes], ([Measures.[Number] * 100))} ?  This should multiply the measure value by 100 rather than...

Are you using VS2005 or the SQL Server Business Intelligence Developmetn Studio (yeah, I know, basically the same thing/shell)?  I'm using the released version and the option is definitely there...

Are you using data driven subscriptions?  If so, you could modify your query that returns the subscriber list, effectively filtering the list based on a count of exceptions.  It does...

I agree, maybe they think that the statement 'the report is using user-defined parameter values' covers this.  In a way, it is a user-defined variable, they just don't know that...

Ok, gotcha, sorry for the mis-direction.

When in design, single left click the rop left hand corner of the report designer, this: i) selects the report as a whole and ii)...

We use a 'Time' table for all dates in our DW, which makes for writing easy queries to solve this type of question.  Assuming you have one, just add two...

Depends on what you're trying to work around...

You can't use the UserID as it's the 'Unatteneded User' who will always be executing this report. 

If you're trying to use the UserId...

Firstly, a plug for moving to AS2005, it handles this better with it's Role Playing dimensions.

One of the fastest ways to solve your dilema is to create a view per...

Maybe not fitting with your architecture, but why not use the webservice and then you can pass a specific set of windows credentials to the WS when you connect/create the...

I'm pretty sure that you need to process the aggregations at the same time as the cube.

Do you archive your fact data anywhere?  If not, you're running with a big...

Assuming you've got an 'all' member for the status dimension, a slight variation on the baddogs MDX will give you all three values as required.

Select ([status].[terminated], [status].[active], [status].[all]) on Columns,

[Measures].[employee...

Hi Asif,

You can definitely design aggregations for that single partition, but as mentioned previously these may take quite a while to build (dependent on incoming row count, and especially your...

Must be a fair amount of data being loaded in if it's just from Jan and is 1.6Gb. 

Are you using partitions?  If not, you may want to investigate this...

One of the authers of fast track (Mosha) works on the design of AS and MDX especially within AS.  I think Rob Zarre is a co-author who works for MS...