TM1 Forum

Hello,

we're running TM1 10.2.2 with FP7. I created some Picklists via a Picklist-Control-Cube and set the values for the Picklist with a rule. This works okay.

Than I have an Excel-Sheet with Perspectives where the Cell is displayed in an active Form with a DBRW and the Picklist is offered via a Dropdown. Like expected.

Than I have another Excel-Sheet with the same column in an active Form. So exactly the same Cells are displayed in this column. The Column has the same format like in the other sheet. The content of the Cells are shown. But the DropDown for the picklist isn't.

I've no idea why not.

Is the DBRW exactly the same cell ?

Hello,

yes, it's exactly the same cell. Here is the cell with the Dropdown:
and here is the cell without:
Luckily the cube has only 4 Dimensions so it is all shown in the window for function-arguments. Also the Sheets looks very similiar but in fact they are different Sheets.

Thanks.
You tested this with an Admin user in both sheets ?
Is there some sort of protection in worksheet or workbook?
Can you reproduce it in a different workbook / new cube slice brought to Excel ?

Wim Gielis wrote: ↑Sun Jul 21, 2019 10:13 am Thanks.
You tested this with an Admin user in both sheets ?

Yes.

Wim Gielis wrote: ↑Sun Jul 21, 2019 10:13 amIs there some sort of protection in worksheet or workbook?

No

Wim Gielis wrote: ↑Sun Jul 21, 2019 10:13 amCan you reproduce it in a different workbook / new cube slice brought to Excel ?

With a new slice the behaviour is the same in both Excel-files. One is with Dropdown, the other without.

What kind of picklist is it ?
If you copy/paste the first working file as a new 3rd file, will the 3rd work or not ?
I tried to reproduce it (PAL 2.0.7, Office 365), but I cannot.

It's a static Subset and a Picklist-Control-Cube

The copy of the working file works and the copy of the not working file doesn't

Bizarre. I would check with IBM because this behaviour is not what can be expected.

Okay, thx for the try!

On the sheet where the dropdown is not working, can you try hard coding the Server:CubeName portion of the DBRW? Depending on what's in R12 I have seen issues where the original view for the Active Form is not inclusive of the whats in the DBRW that you may have added manually. Im not sure if thats what you have done in the second sheet, but in some cases a cell that is out of context for the Active Form needs to reference a cube name directly.

Worth a shot

PlanningDev wrote: ↑Tue Jul 23, 2019 10:07 pm On the sheet where the dropdown is not working, can you try hard coding the Server:CubeName portion of the DBRW? Depending on what's in R12 I have seen issues where the original view for the Active Form is not inclusive of the whats in the DBRW that you may have added manually. Im not sure if thats what you have done in the second sheet, but in some cases a cell that is out of context for the Active Form needs to reference a cube name directly.

Worth a shot

I'm willing to test everything but I think I don't understand completly what you mean. You mean I should replace the reference of the cube with the hardcoded part?

And I just tested it in TM1Web with my original not working sheet and there it is working.

I'm confused

Hard coding had no effect

Hi,

is there an hidden sheet called picklist in the one that isn't working?

Yes, it is.