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!

 

[Sektor]

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

 

[Jonmo1]

You just need to complete the concatenation...

"text" & variable & "moretext"

Try

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

 

[ApolloID]

Hi, it's not working. I have excel 2007.
after i put the code inside a cell and press enter, i receive this error:

"The formula you typed contains an error"
An it's pointing to the space in fromt of &[814]

What am i doing wrong?

Thanks!

 

[ApolloID]

The same thing with the second code. Same problem.

Thanks!

 

[ApolloID]

Hi, there is no other way?

Or am i doing somethin wrong?

Thanks!

 

[ukmikeb]

Hi

This perhaps -

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

hth

 

[ApolloID]

Hi, it's not working. this part:
"[Articole].[Cod].&[B1]" is still as text. And this bigger part is inside brackets and the formula doesn't see "B1" because of the brackets..


Any suggestion?

Thanks!

 

[Sektor]

"[Articole].[Cod]." &B1

 

[ApolloID]

Hi, i tried that, but is not working. It return an error message and is selecting the space before &B1. And i suppose this happent because of the curly brackets.