Search found 36 matches
- Wed Oct 06, 2021 2:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Erroring on Duplicative Dimension in DB Formula
- Replies: 16
- Views: 14154
Re: Rule Erroring on Duplicative Dimension in DB Formula
Thanks for noticing the misspelling, but the error occurs earlier. Syntax error on or before: ' !Midstream Metrics , invalid string expression etc. See attached. I am fairly certain remaking the cube with a different name would work, but the cube owner has business reasons not to want to do that at ...
- Mon Oct 04, 2021 8:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Erroring on Duplicative Dimension in DB Formula
- Replies: 16
- Views: 14154
Re: Rule Erroring on Duplicative Dimension in DB Formula
Thanks for looking at my issue, but removing the brackets did not help. The issue is that the cube "Midstream Metrics" and one of its dimensions have the same name.
- Fri Oct 01, 2021 5:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Erroring on Duplicative Dimension in DB Formula
- Replies: 16
- Views: 14154
Rule Erroring on Duplicative Dimension in DB Formula
Hi All and Happy Friday! I am experiencing an issue with a rule that is trying to plug the difference between two cubes by rule. Unfortunately, the name of the first cube and one of its dimensions repeats, which causes the rule to error out. Normally in a rule you can call out the dimension in front...
- Mon Aug 24, 2020 10:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX/PAW vs Other Planning Tools
- Replies: 0
- Views: 2723
PAX/PAW vs Other Planning Tools
We are an SAP (S4 HANA) shop that runs TM1 2.0.8 for our consolidations, reporting, and planning. We have been on TM1 in various versions for ten years and generally like the product. We may be upgrading to PAX and PAW next year to replace Perspectives and TM1 Web, but I wanted to know if anyone has...
- Wed Jul 31, 2019 8:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Local Installation Crashes
- Replies: 3
- Views: 2470
Local Installation Crashes
Hi All, My company has offices in a few cities across America. Myself and my team have no issue using our local installation wherever we are, but the people in our other office always experience a crash whenever slicing or snapshotting from a cube view on their local installations. They can, however...
- Wed Jul 03, 2019 4:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Service Access Issues - New Box
- Replies: 2
- Views: 1852
Re: Service Access Issues - New Box
Thanks. It turns out IT created an alias because they thought TM1 couldn't read hyphens for some reason. In fact, the service account couldn't read the server's alias, but could read its real name.
- Fri Jun 28, 2019 3:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Service Access Issues - New Box
- Replies: 2
- Views: 1852
Service Access Issues - New Box
Hi All, I recently had my Dev service moved to a new box and supposedly all permissions were copied over correctly. Trouble is, when I run processes that either use text files on the Server as a data source or try to do an output file, the TI rejects it and I get the usual (Error: Prolog procedure l...
- Thu Dec 13, 2018 5:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 SAP Connector on 10.2.2 and PAX
- Replies: 6
- Views: 4215
TM1 SAP Connector on 10.2.2 and PAX
Hi All, Our current TM1 installation is 10.2.2, which is fed by a nightly text file from SAP, version 7.5. We are in the process of upgrading TM1 to PAX as our SAP is revamped to S 4/HANA. Does anyone have experience using the TM1 SAP Connector in any iterations of these products? If so, have you ex...
- Tue Dec 04, 2018 10:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: One vs Two Time Dimensions
- Replies: 8
- Views: 6394
Re: One vs Two Time Dimensions
Thank you, everyone, for these very helpful replies. Given that we do a lot of budget work and year-over-year analysis and very little rolling 12 month trending, there may not be much of an advantage in 1D from our business perspective. On a similar note, does anyone have thoughts, one way or the ot...
- Tue Dec 04, 2018 3:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: One vs Two Time Dimensions
- Replies: 8
- Views: 6394
Re: One vs Two Time Dimensions
Thanks for this. Right now we are on 10.2.2, but are upgrading to PAx before our rebuild). We are actually restricted on RAM because it's allocated on a virtual server and IT is stingy with what they give.
- Fri Nov 30, 2018 8:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: One vs Two Time Dimensions
- Replies: 8
- Views: 6394
One vs Two Time Dimensions
Hi All, We are in the process of rebuilding our TM1 setup as we upgrade our ERP. The subject came up as to whether one or two dimensions to measure time should be preferred. We currently have two, one for Year (2017, 2018, 2019 etc) and one for Period, which is an organization of months ( Jan, Feb, ...
- Fri Jun 29, 2018 2:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Not Expanding Properly
- Replies: 3
- Views: 2558
Re: MDX Not Expanding Properly
It actually had to do with the attribute not being filled in for a single consolidation point where I was grabbing the elements below it, so it would show all the elements but break the hierarchy.
- Thu Jun 28, 2018 9:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Not Expanding Properly
- Replies: 3
- Views: 2558
Re: MDX Not Expanding Properly
Never mind, issue resolved!
- Thu Jun 28, 2018 4:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Not Expanding Properly
- Replies: 3
- Views: 2558
MDX Not Expanding Properly
Hi All, I have an MDX in an active form that is supposed to expand all elements within a dimension that have two particular attributes. With the exception of a few elements, they should generally belong to one sub-hierarchy (O&M - MB) under the main hierarchy (Consolidated EBITDA). Instead only ...
- Mon May 07, 2018 7:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Process Stuck on Zero Out
- Replies: 4
- Views: 3386
Re: Process Stuck on Zero Out
Thanks for your help, guys. It was actually a rule based value issue that was preventing the zero out. It works now.
- Fri May 04, 2018 4:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Process Stuck on Zero Out
- Replies: 4
- Views: 3386
Process Stuck on Zero Out
I have a TI process that deletes the contents of a cube and reloads the data based on a CSV. The process worked until yesterday, when it failed immediately and gave me a "stack overflow error." I deleted the Feeder files and restarted my server hoping to clear up any corrupt Feeders. Now w...
- Mon Mar 26, 2018 8:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Date held as number but formatted as date
- Replies: 5
- Views: 3927
Re: Date held as number but formatted as date
What are you doing to drive the formatting?
- Mon Mar 26, 2018 7:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension is not available in TM1Web
- Replies: 2
- Views: 2337
Re: Dimension is not available in TM1Web
Is your SUBNM referring to a view in the old dimension that no longer exists?
- Thu Dec 07, 2017 10:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Audit Log Configuration
- Replies: 4
- Views: 3404
Re: Audit Log Configuration
That makes sense. THanks for the help!
- Thu Dec 07, 2017 9:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Audit Log Configuration
- Replies: 4
- Views: 3404
Re: Audit Log Configuration
Tomok, I understand that. What I mean is that I think the log only goes back so far. I would like to expand how far back it retains transactions for future use.