DBS function not working

[pemy_s]

Hi All,

I am a newbie in TM1, I need your help.

I created a active form (in excel 2007) that i used DBS function to get value for other cell, for example :
colum A1 for Jan, price = 100, i want to get value of jan, price user DBS($A$1,"server:cube",e1,e2) for feb, price and i used DBS function. the result in a cube is a value feb, price is always zero(0).

Thanks for your help.

Rgds,

Pemy

[Wim Gielis]

Hello

Can you click on the cell that houses the DBS formula? Then, in the formula bar, click the Fx symbol and review the particular elements/arguments. Are they what you'd expect?

[Gregor Koch]

Hi
Are you using a DBRW in column A?
It could be that the order in which the formulas are evaluated causes the problem.
As you are using a DBS anyways you could try using a DBR in column A.
Maybe it's just a typo but have you tried using DBS($A1,"server:cube",e1,e2)?

Cheers

[pemy_s]

Hi All,

Thanks for your response and help.

its done.

i am just wrong type of DBS function

Regards,

Pemy