Hello,

Im trying to select from 2 cubes. in one condition - select .. From CubeX, and in sec Condition Select .. From CubeY.

I tryed to put the name of the Cube as parameter:

SELECT ...

FROM @CurrentCube

in ssrs source and i got the message:

------------------------------
Failed to parse the query to detect if it is MDX or DMX. Error: 'Query (148, 6) Parser: The syntax for '@CurrentCube' is incorrect.' (MDXQueryGenerator)

------------------------------

also tryed to get the name of the Cube as Member (I have a property with the name of the cube),

and than using the member to the select :

WITH MEMBER [CurrentCube] AS

...[dim name].CURRENTMEMBER.PROPERTIES("Cube")

SELECT ...

FROM [CurrentCube]

It didnt work too..

Is it Possible at all make the Cube-name dynamic?!

thanks!

Please help its important and i cant find solution

Hi,

maybe this helps: https://social.msdn.microsoft.com/forums/sqlserver/en-US/4e66d766-7002-4507-b955-903e2c4d52b3/dynamically-change-cube-name-in-ssrs-report

Thank you, i saw that idea already, but I dont wan't to use the expression window for writing my DataSets.

I need solution with Query designer because I don't want to "Unexpression" the query and "Reexpression" it evrey time I use it.