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
DBS function and pick lists
-
Edward Stuart
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: DBS function and pick lists
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
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