Reference Parameter to MDX Query from a Excel Cell

[Abinaya]

Hi
When I reference using the Format " & F16 & " it's not working? What is the correct format?

[EvgenyT]

"&I10&" is correct format, yeah.

Please post your mdx ...

ET

[Abinaya]

{FILTER( {TM1SUBSETALL( [Customer] )},[Customer] .Group=" &F16&")}


When I hard code the the Group it works.

[EvgenyT]

{FILTER( {TM1SUBSETALL( [Customer] )},[Customer] .Group=" &F16&")}


When I hard code the the Group it works.

Ah ok. you gota use ' " & F16 &" ' ... Single, double, ampersand...

Because, I bet you when you look at your MDX string:

{FILTER( {TM1SUBSETALL( [Customer] )},[Customer] .Group=" &F16&")} doesnt have ' ' around the value and MDX engine requires value to be in ' ' when you are filtering by attribute for example hence need for ' " & & " ' syntax

ET

[Abinaya]

Sorry Still not working. Very strangely when I tried Text(F16,"") in the cell it worked.

[EvgenyT]

Sorry Still not working. Very strangely when I tried Text(F16,"") in the cell it worked.

So you tried {FILTER( {TM1SUBSETALL( [Customer] )},[Customer].[Group]= '"&F16&"')} ?

see simple example below

[Abinaya]

Worked. Sorry for the confusion.

[Abinaya]

Thanks

[EvgenyT]

All good.

' " & Cell Reference &" ' is a trick to use


ET