gotcha - in that case, give this one a shot... scope to the leaf level below the [Income Statement] member and let the engine handle the aggregation back up through...

Why have you included [Dim Date].[Current YTD] in your scope statement?

Also, a good method for...

+1 for local user groups...great way to find work and network with peers and prospective clients. Each month, there are a number of openings mentioned at the beginning of...

Great post Koen!

In the comments, it seems there is a bit of confusion between deployment and execution...basically, packages don't have to be "deployed" in order to be "executed". I've...

I think you're stuck...perhaps a VM for each type of client?

sounds like you need the latest version of PowerPivot.

http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpivotforexcel/thread/64db8360-6b6c-4b36-986b-e12ca1d782e8

Yes. Read this...

http://www.sqlbi.com/articles/many2many/

as a consultant for a small private company, the sales ppl are VERY valuable. if they do well, the company grows...and with growth comes promotions and job stability for...

well another option would be to remove users from the list of server-wide admins and just give them admin privileges via a cube role...

on the general tab of the role...

Donalith (1/10/2012)

---

Only the Admins have access to the cubes but they should have access to different cubes at different levels.

How does you set individual access with Roles on cubes? I've...

Assuming you are using a matrix to layout the data in your SSRS report, you can add an entry in the row group sorting tab with the following expression:

=CDate(Fields!Date.Value)

...if you...

Donalith (1/4/2012)

---

Here is the situation I'm facing. I've got a cube with confidential information in it. It's on the same Analysis engine with a bunch of other cubes. I'm trying...

Thanks Jamie, I'll give those a shot. Cheers!

are you processing from the visual studio project, management studio, or something else?

if management studio, you need to process the "analysis services database" (not just the cube)

if visual studio, you...