Excel OLAP question referencing other cells

[aivoryuk]

I have this simple query

=CUBEMEMBER("localhost RiskCube3 Risk Cube",{"[Client].[PK Accountid].&[2]","[Date].[PK Date].&[2011-11-23T00:00:00]"})

But what I would like to do is rather than hardcode the values I would like them to reference another cell in excel

I can do this by

=CUBEMEMBER("localhost RiskCube3 Risk Cube","[Date].[PK Date].&["&D3&"]")

and for the date

=CUBEMEMBER("localhost RiskCube3 Risk Cube","[Client].[PK Accountid].&["&C2&"]")

but I can't get these to work together

=CUBEMEMBER("localhost RiskCube3 Risk Cube",{"[Client].[PK Accountid].&["&C2&2]","[Date].[PK Date].&["&D3&"]"})

I keep getting the formula error message.

Also for the date part the reference cell may not be in the standard SSAS format by in dd/MM/yyyy format (and without time) so what would be the best way to format this?
I can use a helper cell =CONCATENATE(TEXT(D2,"yyyy-mm-dd")) but then i need to add the T00:00:00

Regards

 

[VoG]

Duplicated thread http://www.mrexcel.com/forum/showthread.php?t=618484

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).

If you have posted in the wrong forum please use the Report button to request a moderator to move the thread.