How good is your data quality? Assuming it's very good (so either valid 8 digit integer representing yyyymmdd or NULL) then you could try (psuedo code)

if date is null...

SSAS doesn't currently support > 1 P-C hierarchy per dimension 🙁 If you don't want to create two separate dimensions, only alternative that i would see is to unroll...

As Mike pointed out, SSAS *only* supports Windows Auth, so yes, when using Excel, you'll be authenticated by your windows account (unless using http, in which case it's determined by...

Is it possible that one of the values you're running through the data flow doesn't have the same format? Personally I'd look to using the Datepart function to extract...

30 mins to open!?!?! whoa. No offence but 20MM rows isn't *that* large. It's actually spot on for the recommended partition size for SSAS (depending on your...

Add a second dataset to the report, use the exact same parameters do get a count of all customer records matching the query parms. Write this count on the...

If you're running SQL Agent, you could go there, add a new job. In the job, add a new Step, set the type to be SQL Server Analysis Services...

@sanjay - The problem is not so much the rating as the attribution of the rating to someone who didn't do the work.

can i take back my article rating somehow?

Ensure you've followed the steps outlined here....

and then you may still have to muck with the dcom as noted here...

Bosco, sorry to revive this thread but thought you may also be interested in the BIDS Helper (add in for VS 2005 and 08). I was pointing a...

A switch/case statement would be nice too 🙂

Basically you can make use of the TOPCOUNT function. Either google for it or use the links below.

The very dry, Books OnLine explanation of TOPCOUNT.

A little longer article by...

Bachi, not sure that'll work as written. Equality (or inequality) to NULL as a string is likely to fail when the value is actually NULL 🙂

Using the SSIS Expression...

So many Steve's, it's an epidemic 😛

Totally agree, why add the additional complexity to the package when a view/query/proc could perform the same function for you and keep the error...