Piclists in Perspectives
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Piclists in Perspectives
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.
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.
-
- MVP
- Posts: 3126
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Piclists in Perspectives
Is the DBRW exactly the same cell ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Piclists in Perspectives
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.
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.
-
- MVP
- Posts: 3126
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Piclists in Perspectives
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 ?
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 ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Piclists in Perspectives
Yes.Wim Gielis wrote: ↑Sun Jul 21, 2019 10:13 am Thanks.
You tested this with an Admin user in both sheets ?
NoWim Gielis wrote: ↑Sun Jul 21, 2019 10:13 amIs there some sort of protection in worksheet or workbook?
With a new slice the behaviour is the same in both Excel-files. One is with Dropdown, the other without.Wim Gielis wrote: ↑Sun Jul 21, 2019 10:13 amCan you reproduce it in a different workbook / new cube slice brought to Excel ?
-
- MVP
- Posts: 3126
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Piclists in Perspectives
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.
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.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Piclists in Perspectives
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
The copy of the working file works and the copy of the not working file doesn't
-
- MVP
- Posts: 3126
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Piclists in Perspectives
Bizarre. I would check with IBM because this behaviour is not what can be expected.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Piclists in Perspectives
Okay, thx for the try!
-
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Piclists in Perspectives
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
Worth a shot
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Piclists in Perspectives
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?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
And I just tested it in TM1Web with my original not working sheet and there it is working.
I'm confused
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Piclists in Perspectives
Hard coding had no effect
-
- Community Contributor
- Posts: 292
- Joined: Tue Sep 06, 2016 7:55 am
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: Excel 2010
Re: Piclists in Perspectives
Hi,
is there an hidden sheet called picklist in the one that isn't working?
is there an hidden sheet called picklist in the one that isn't working?
-
- Regular Participant
- Posts: 151
- Joined: Mon Oct 07, 2013 11:51 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2010
Re: Piclists in Perspectives
Yes, it is.