TM1 Forum

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

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?

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

Hi All,

Thanks for your response and help.

its done.

i am just wrong type of DBS function

Regards,

Pemy