Search found 9 matches
- Fri Aug 28, 2020 3:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Zero Suppression - very small #'s
- Replies: 3
- Views: 2129
Re: Zero Suppression - very small #'s
Ughhh - I was afraid that was what the answer was going to be. This didn't seem to be an issue until we went from 10.2.2 to 2.07 - any thoughts as to why that might be the case (just out of curiosity)?
- Fri Aug 28, 2020 2:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Zero Suppression - very small #'s
- Replies: 3
- Views: 2129
Zero Suppression - very small #'s
Hi, We're having an issue with TM1 converting 2 decimal values to very small numbers (15-20 decimal places). These are values that are written to the cells via a TI process, not rule driven or data spreads. I've tried ROUND and ROUNDP w/ 1-6 decimals in the TI, and also tried doing the rounding in t...
- Fri Dec 13, 2019 4:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View not loading in TI Process
- Replies: 8
- Views: 7064
Re: View not loading in TI Process
Solved? - I tested out the DisableMTQViewConstruct() in my QA environment and that seems to have corrected the problem. Thanks for the tip Andy - I'm not sure I would have ever gotten to that one on my own, and thank you to everyone else who provided suggestions.
- Thu Dec 12, 2019 6:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View not loading in TI Process
- Replies: 8
- Views: 7064
Re: View not loading in TI Process
Thanks Tom, I forgot to mention, I did play around with the VMM and VMT settings for the cube, but was pretty subtle with my changes, mainly b/c, as far as I can tell, those settings just control the circumstance under which TM1 will create Stargate views so I was not really understanding why this w...
- Thu Dec 12, 2019 6:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View not loading in TI Process
- Replies: 8
- Views: 7064
Re: View not loading in TI Process
re. increasing max view size in TM1s - I was under the impression that was only for end users opening views and that would not impact TI processes - am I mis-informed? Could be, as I often see conflicting info on TM1 topics, sometimes even in IBM's own documentation:-).
- Thu Dec 12, 2019 4:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View not loading in TI Process
- Replies: 8
- Views: 7064
View not loading in TI Process
Hi, I've done quite a bit of searching on this and haven't found a solution yet, so thought I'd try posting here. I've got a TI process that does an ASCIIOUTPUT from a view used as the data source. That process has been consistently failing for the last few weeks with an error popup of "Unexpec...
- Tue Sep 20, 2016 4:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX for 0 level elements with no level 1 parent
- Replies: 7
- Views: 7676
Re: MDX for 0 level elements with no level 1 parent
Yes, sorry the part about ragged hierarchies wasn't clear in my initial post - I did not realize that was relevant. So the solution is to add a "dummy" parent to the elements that don't have a natural parent - that's what I was originally thinking I'd like to do, but that makes it a much b...
- Tue Sep 20, 2016 2:46 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX for 0 level elements with no level 1 parent
- Replies: 7
- Views: 7676
Re: MDX for 0 level elements with no level 1 parent
OK, I think I see how/why that's working, but it only returns level 0 elements that have no parent at all, correct? What about level 0's that have no level 1 parent but do have a parent at level 2,3,4, etc.? Am I missing something? It seems like there would be a way to identify the level of the elem...
- Mon Sep 19, 2016 10:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX for 0 level elements with no level 1 parent
- Replies: 7
- Views: 7676
MDX for 0 level elements with no level 1 parent
Hi all, I'm new to TM1 and MDX, so please bear with me if I'm not phrasing this correctly, but I'm trying to create a subset using MDX that will return all 0 level elements that don't have their parent at level 1 - anyone know how to do this? I've spent the better part of the day online looking for ...