Page 1 of 1

DBS function and pick lists

Posted: Thu May 02, 2013 6:45 pm
by hpansar
Hi Everyone

I have a DBS formula, DBS($A$1,"server:cube",e1,e2) and I am trying to send values to a cube however the values are listed in a pick list. Is that possible to send values to a pick list?

thanks

Hiten

Re: DBS function and pick lists

Posted: Fri May 03, 2013 8:45 am
by Edward Stuart
Providing the value you send is valid in the picklist then you can DBS that value to the cube.

You 'could' send values to a cube to update a separate picklist but I'm guessing you want to be able to add new items to the picklist in the same field/ formula as sending values to a cell.

Read the Manual details on Picklists for more information

http://pic.dhe.ibm.com/infocenter/ctm1/ ... 00123.html