Splitting a formula

[ApolloID]

Hi, i need this formula from A1:

=CUBEMEMBER("192.168.1.10 SeniorBI Sales",{"[Articole].[Structura Gama].[Sortiment].&[814]","[Articole].[Cod].&[400075]"},"400074")

To be modified to:

=CUBEMEMBER("192.168.1.10 SeniorBI Sales",{"[Articole].[Structura Gama].[Sortiment].&[814]","[Articole].[Cod].&B1"},"400074")

in B1 to have 400074

Can this be done?
Thanks!

 

[ApolloID]

Is there any way to avoid curly brackets?

Thanks!

 

[ukmikeb]

Hi

Having looked at the help file it seems to suggest that round brackets are the order of the day for the second parameter.

Try Jonmos suggestion replacing the curly brackets with round brackets.

hth

 

[ApolloID]

Hi,
it's not working. I tried with all brackets, but nothing.