Hi, i have this formulas from a cube (after i converted the cube to formulas):
and
I need first formula to take the "article cod" from cell :A1", so, instead of : [ACC MOD 10] i need to have "A1".
And the content of A1 to be ACC MOD 10
For the second formula i need to replace inside formula the date...[2010-05-01T00:00:00] with the content of "A2".
And the content of A2 to be 2010-05-01
Can this be done?
Thanks!
Code:
=CUBEMEMBER("192.168.1.10 SeniorBI Sales",{"[Articole].[Structura Gama].[Sortiment].&[653]","[Articole].[Articole].&[5489]","[Articole].[Cod].&[ACC MOD 10]"})
Code:
=CUBEMEMBER("192.168.1.10 SeniorBI Sales","[Calendar].[Month].&[2010-05-01T00:00:00]")
I need first formula to take the "article cod" from cell :A1", so, instead of : [ACC MOD 10] i need to have "A1".
And the content of A1 to be ACC MOD 10
For the second formula i need to replace inside formula the date...[2010-05-01T00:00:00] with the content of "A2".
And the content of A2 to be 2010-05-01
Can this be done?
Thanks!