Piclists in Perspectives

[Willi]

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.

[Wim Gielis]

Is the DBRW exactly the same cell ?

[Willi]

Hello,

yes, it's exactly the same cell. Here is the cell with the Dropdown:

Zelle_mit.JPG (64.53 KiB) Viewed 6437 times

and here is the cell without:

Zelle_ohne.JPG (59.24 KiB) Viewed 6437 times

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.

[Wim Gielis]

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 ?

[Willi]

Thanks.
You tested this with an Admin user in both sheets ?

Yes.

Is there some sort of protection in worksheet or workbook?

No

Can 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.

[Wim Gielis]

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.

[Willi]

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

[Wim Gielis]

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

[Willi]

Okay, thx for the try!

[PlanningDev]

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

[Willi]

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

[Willi]

Hard coding had no effect

[Mark RMBC]

Hi,

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

[Willi]

Yes, it is.

Picklist.JPG (29.28 KiB) Viewed 5862 times