Hi, i need to replace a part of the below formula with A1:
[400075]
Formula:
=CUBEMEMBER("192.168.1.10 SeniorBI Sales",{"[Articole].[Structura Gama].[Sortiment].&[814]","[Articole].[Cod].&[400075]"},"400074")
I know this part of the formula is a text:
"[Articole].[Cod].&[400075]"
I tried with A1&"["&B1&"]"
A1=[Articole].[Cod].&
B1=400075
I know this should work because a similar formula worked.
The only difference is that this above formula has curly brackets.
Is there any way to make it work even with curly brackets?
Can this be done?
Thanks!
[400075]
Formula:
=CUBEMEMBER("192.168.1.10 SeniorBI Sales",{"[Articole].[Structura Gama].[Sortiment].&[814]","[Articole].[Cod].&[400075]"},"400074")
I know this part of the formula is a text:
"[Articole].[Cod].&[400075]"
I tried with A1&"["&B1&"]"
A1=[Articole].[Cod].&
B1=400075
I know this should work because a similar formula worked.
The only difference is that this above formula has curly brackets.
Is there any way to make it work even with curly brackets?
Can this be done?
Thanks!