There are some excel add-ins that you need to install in order to connect to SSAS 2005 and later from excel 2003. If you are unable to find them on...

Duncan,

Are you able to process the SSAS db now or are you still having issues? If you are still unable to process the cubes then you will most likely...

Duncan,

Is it the service account that has been edited? If not, I would set up the sevice account in the cube with process permissions.

Thanks,

Frank

Nick,

What sort of data is in these two tables? I would suspect that the issue that you are seeing with the data not aggregating up as you are expecting it...

That's exactly what I was looking for!

Thank You.

Yep, turning the box back over to our IT provider... we had them reinstall SQL server last week because they loaded the Standard edition rather than EE and they turned...

We ended up keeping the same configuration as the 2000 environment.(Post was from Jan 08) One db server, one AS server, one RS server and a dev box running all....

Unfortunately I haven't tried to use a server time dimension before so I couln't say for sure. I'm not sure what the differences between a server time dimension and...

Instead of adding an additional column every 15 days why not add a date column? This way you will still be able to track the progress(stage) of each owner/account...

Date, owneridname,...

I don't see any issues with that setup.

Sounds like your typical role playing dimension... here's the link to BOL.

Granted I'm not a big fan of BOL but you should be able to get it set up by...

I see that error when I have a dimension member that is present in two hierarchies. Try to fully qualify the member by putting in the [Dimension].[Hierarchy].[Member] ;

Should look something like this:

sum([Dimension].[Hierarchy].[0825]:[Dimension].[Hierarchy].[0840],[Measures].[Qty])

Perhaps something like this then?

WITH

MEMBER [Measures].[ParameterCaption] AS ''space([Dimension].[Hierarchy].CURRENTMEMBER.LEVEL.ORDINAL) + [Dimension].[Hierarchy].CURRENTMEMBER.MEMBER_CAPTION''

MEMBER [Measures].[ParameterValue] AS ''[Dimension].[Hierarchy].CURRENTMEMBER.UNIQUENAME''

MEMBER [Measures].[ParameterLevel] AS ''[Dimension].[Hierarchy].CURRENTMEMBER.LEVEL.ORDINAL''

SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,

descendants({[Dimension].[Hierarchy]},0,self_and_after) ON...

We don't have the adventureworks database loaded at work but I ran this against one of our parent-child hierarchies and it returned values similar to what you're looking for.

WITH

MEMBER...