It looks like you're referencing just the Atttribute as opposed to the member. I'd expect a reference something like:

[Tbl Analysis Test].[Name].&[some key value]

This statement is to drop out individual members,...

I'd be interested in clarification on exactly what the difficulty was. This type of a report is handled simply and directly by the matrix control. All you need is a...

Sorry to leave this thread hanging so long.

Go to Report / Report Properties.

Click on the Code tab.

Add some VBA code like:

Public myString

Public myKey

Function StringGrouping( aKey,aString )

If MyKey <>...

Good ideas all. I would suggest "gallan" jump back in with some more details.

Some thoughts:

Thowing half a million rows at a matrix or summary probably isn't a great way to...

Robert's suggestion is of course the right one. You can't omit all of the dates from the SQL statement, and then test it in MSRS.

His suggestion brings up an important...

Create / build the results separately, then append them together in the right order at the end.

With SSIS, you need to avoid trying to do everything "in one step". It's...

Actually, it's more straight forward than that:

On your MDX query that is being used to pull the original data, for the rows, pages, etc, make sure you specify DIMENSION PROPERTIES...

Is the Analysis Server part of the same domain as your workstation? Can you connect to the MSAS server (from your workstation) using SSMS?

The most obvious question would be how would the dates optionally appear in the select clause?

I'll assume for a moment, that you're using a parameter to specify which dates to...

A few suggestions:

- First, consider in investing in a license for Dundas Controls. These folks sold the stripped down version used in reporting services to Microsoft, so they know the...

Some general comments around these concepts:

- While you're in the design and testing stages, get in the habit of doing full process only. It'll make things simpler. The process update...

While this approach will work, it looks like you're creating a highly sparse cube structure. (This is often a a marker, for using BI technologies for othger purposes.)

From what I...

My two cents worth:

Using the table name directly works well, in particular if you've added the database information to allow AS to auto discover the various relationships. However, it...

I don't think RS does type checking until you actually try to access a method. Therefore, it's trying to get a Datarow out of a string and can't.

Of course, I...

Try accessing anything else in your datatable and see if that throws an error (I suspect it will).