TM1 Forum

I have an active form in excel used to show a list of accounts, then enter manual adjustment input, row set is an account list by MDX, I want to add assumption method for each account which is a picklist from an assumption cube, each account has an assumption method, if the account list is a static list, I use DBR worksheet function I can pull the method, but if it is a dynamic list from MDX in an active form, the formula only pulls an empty cell with an arrow to select picklist, without selected string for each acct defined in the assumption cube, can you know how to resolve this? thank you so much.

If you want to use a picklist in an active form then you'll need to set up a picklist on the measure dimension or set up a picklist cube and reference that in the measure dimension. You can't pick some regular cube and use that as a picklist. It has to be a picklist cube. Read the documentation for more info about picklist cubes.