Sorry for the late reply. Holidays.

For anything but the most trivial examples, you'll find that the ASSL model is the only thing that works. Unfortunately, you'll find that CubeSlice depends...

Refresh means something different in the case of offline CUB files in Excel. Short answer, is don't use refresh, but simply change a slicer in your query, that'll cause Excel...

Rick, help us out a little. Need more information:

Is the attribute on board or off board? What field do you have selected as the key? Are there any nulls present...

I saw the recient post and thought I'd add a suggestion. It's probably way too late for the original poster, but hopefully will help someone else.

First, you'll want to start...

Sorry for the late post to this topic. Someone should really go through the open topics and try to get outstanding questions answered. I suspect you've moved on, but hopefully...

Seems you got to it shortly after your post.

The SuppressAutoUpdate flag was added to a service pack for 2005 I believe (it's definately in 2008). As of yet, I can't...

I see the confusion (I think). Yes, everything about your project in MSAS is in or accessable from the "Solution Explorer" tab. Specifically in your case, you needed to get...

Are you running x64? If so, make sure you have both the 64 and 32 bit drivers installed. Otherwise, let's step through this:

a) check to make sure you can browse...

If you'd like some help, I'll need the counts described in my previous post. That'll generally point directly to the disconnect.

You can implement your own "RunningValue" function via the report code (Report/Report Properties... Code tab.)

Some thing like:

Dim myRunningValue

Function aRunningValue( currentValue )

myRunningValue= myRunningValue+ currentValue

...

Ok first, you need to remember that you can't create a "set" of members from more than one attribute hiearchy. Logically attributes are "crossed" to create results.

However, you can combine...

There's two topics under discussion here, and they deserve to be pulled apart:

Surrogate keys vs business keys.

The case for surrogate keys occurs when you have large business keys and billions...

Check the Person field carefully for things like trailing spaces (i.e. "A" and "A "). I've seen that more than once.

Sounds like a problem with your Reporty Services install. Recommend you reinstall it.

Create a calculation as in:

[Code]

With

Member [Prev Quantity Sold] as ( [Quantity Sold], ([Client Tbl Dim Calendar].[Day Week Id].CurrentMember.PrevMember ), Format_String= "#,#"

SELECT

{ [Quantity Sold], [Prev Quantity Sold] } ON...