Search found 9 matches

by ramjam
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)?
by ramjam
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...
by ramjam
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.
by ramjam
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...
by ramjam
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:-).
by ramjam
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...
by ramjam
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...
by ramjam
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...
by ramjam
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 ...