I think I found a solution to use:

sum(parallelperiod([ServerTime].[Fiscal Year - Fiscal Month - Fiscal Day].[Fiscal Year],1,[ServerTime].[Fiscal Year - Fiscal Month - Fiscal Day].parent.parent ),[Measures].[QTYINV])

In my calculated measure. basically telling...

I had almost the exact same sitution and also found this method to not be reliable. It is better I think to do something like:

Column1 <> 0 OR Column2...

Thanks for all the input steve. I was unable to solve the issue w/ Openrowset but I was able to create a c# datamethod that calls SSAS directly and...

Steve,

I have switched to sp_executesql as you recommended. now the statement: sp_executesql @strsql

executes ok but in SSRS I get the error "The character string that starts w/ 'select ......'...

Out of curiosity how would you recommend executing dynamic mdx from withing SSRS? I was unable to get it to work using a string variable to hold the mdx...

yes, I'm forced to use TSQL because you can't have multi-valued parameteres based on MDX queries in SSRS. For instance I have an Item Dimension that I want to...

Finally figured it out. Had to rewrite the datamethod parseItemId() to work even if the parameter that was passed to it is blank or nothing. Even though the...

After further testing it looks like what is happening is that the iif() evaluates the formula in the False portion of the function even if that is not what the...

no difference.

It's a string but I have tried it both in and out of quotes as well as CStr(4). Same results.

thx

That is true. A separate data source is needed when you you want something differnt than all values to be checked as defaults.

Don

Add:

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME

to your MDX right before "From [Cube]"

I use that in exactly the same situation querying the cube in SSAS from SSRS. you might also want...

You need to create a separate datasource that returns a datatable filled with the default values you want selected. You can't make it select the "All" but you can...

I wouldn't mind posting the MDX at all except that I got it working now. Not sure why though. Yesterday i added and removed a table to the...

I narrowed this down to it being a problem with the first field in the result set. If I omit that field I can get all the rows. ...