We use a function that splits the comma-delimited string sent by SSRS into a table, which is used in the stored proc. Search the forum for multi-value parameters and...

Drop a rectangle into the top left corner of the matrix. Then drop a text box onto the rectangle for each heading that you need.

-Marianne

That's great! I hate the word-wrapping that results from adding the interactive sort. I'll definitely be using this tip.

Thanks,

Marianne

In the Solution Explorer, right-click on the DSV folder and select Add, then Existing Item. Then just navigate to wherever the DSV is. Not really a "rapid" method,...

shashi kant (6/13/2008)

There is other alternative available for this header option

You can get this option by selecting these options

Query -> Query Options ->Results -> and then select the option of...

I believe the MDX query is actually using a formatted version of the date, rather than the datetime value passed via the calendar date-picker. I resolved this in my...

Report Builder (the ad hoc report writer with Reporting Services) has a decent interface with the cube. It's not stellar, tho, if you really want to "slice and dice"...

Well, if anyone runs into the same issue, here is how I resolved it:

- In the DSV, I created a named calculation [NetRev], and set the value = 0.

-...

Steve,

Thanks for the reply. Unfortunately, I can't hide the measures from *all* users, so I don't think altering the visibility would work. I thought about using perspectives, but...

Any thoughts???

Thanks,

Marianne

My pleasure! I've learned so much from these forums, so it's nice to be able to help out someone else.

-Marianne

I don't know the answer to the first question, but as for adding labels to the matrix corner: put a rectangle in the corner, and then add text boxes for...

If you want to avoid dynamic sql, you can create a function that parses out the comma-separated values and puts them in a table.

CREATE FUNCTION [dbo].[fn_ParseComma] (@STRING nvarchar(max))

RETURNS @tmp...

I just found the answer:  =Join(Parameters!OperatingUnitName.Value, ", ")

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2014867&SiteID=1

Peter - So far, it seems to work beautifully.  THANK YOU!!!!