I'm taking a look at TM1 pick lists for the first time. Has anyone played around with cube vs attribute pick-lists and seen any performance implications? Any other BKMs to share?
Thanks,
Matt
Pick List Performance
-
mattgoff
- MVP
- Posts: 518
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Pick List Performance
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
PlanningDev
- Community Contributor
- Posts: 349
- Joined: Tue Aug 17, 2010 6:31 am
- OLAP Product: Planning Analytics
- Version: 2.0.5
- Excel Version: 2016
Re: Pick List Performance
If you go with TM1 9.5.1 there is an issue with TM1 Web not displaying long picklists (At least in our case based on a subset of a dimension). I don't know if any of the hot fixes will fix this issue. TM1 Perspectives will also be very slow with picklists unless you install one of the Client Hot Fixes. Im doing testing on this with 9.5.2 and these issues appear to be fixed. Performance so far has been better on 9.5.2 than 9.5.1 with picklists for me.