Search found 11 matches
- Thu Apr 03, 2014 4:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: System was implemented using 9.1 and not much has changed
- Replies: 2
- Views: 2061
System was implemented using 9.1 and not much has changed
I have a general question for everyone. At the company I work at I am trying to update some of the reports and processes to utilize some of the better features since 9.1, which was the version we were using when we started using TM1. (We now use 9.5.2 and are planning to upgrade up to 10.2) All repo...
- Wed Apr 02, 2014 8:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Forms and Vertical Comparison in Excel
- Replies: 4
- Views: 2793
Re: Active Forms and Vertical Comparison in Excel
Thanks, I like the offset idea but I ended up using an DBRW formula as it made a easier way to anchor to the sales figures I needed for the % of sales formulas.
Thanks
Cbergen
Thanks
Cbergen
- Wed Apr 02, 2014 5:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Forms and Vertical Comparison in Excel
- Replies: 4
- Views: 2793
Active Forms and Vertical Comparison in Excel
Quick background I'm writing some Active Form Reports to replace some old Slice reports we have used for years to take advantage of the zero suppress capabilities. On the current report I have a percent to sales column that calculates as a formula in the excel sheet against the sales line in the rep...
- Tue Apr 01, 2014 7:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Picklist dependent of previous choice
- Replies: 2
- Views: 2902
Re: Picklist dependent of previous choice
Thanks for your help that worked great!!!! For what I'm doing two components is enough.
Thanks
Thanks
- Thu Mar 27, 2014 6:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Picklist dependent of previous choice
- Replies: 2
- Views: 2902
Picklist dependent of previous choice
I'm trying to develop a pick list that is dependent on the choices made on the previous level of the hierarchy and I'm having difficulties. N Level Element Rules ['No01','Product']=S:('static:Red:Green'); ['No02','Product']=S:('static:Violet:Purple'); 1st Consolidation Level ['Lv1','Product']=S:(['s...
- Tue May 10, 2011 7:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turbointegrator Importing Consolidated Elements
- Replies: 2
- Views: 2843
Turbointegrator Importing Consolidated Elements
Hello, I am using TM1 9.5.1 I am attempting to import consolidated elements from one TM1 Cube as n level elements into another cube. Thus far I am not having much success, I can successfully import the elements if I adjust the cube view from the source cube to the N elements but the once I consolida...
- Tue Sep 22, 2009 6:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Print Error on TM1Web
- Replies: 4
- Views: 5974
Print Error on TM1Web
Hello everyone, Problem I am using TM1Web to allow users to Plan their budgets, as part of this process the users need to print their budgets. Issue: Some users are getting the following error message when they try to print from TM1Web using the following method : Snapshop to Excel, Open Download Fi...
- Fri Sep 11, 2009 1:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Optimization and Rules
- Replies: 2
- Views: 2718
Cube Optimization and Rules
I have a question regarding Cube Optimization for TM1 9.1Sp2 Yesterday I optimized a cube used in our planning process that has several rules that do simple calculations for users. The cube had seven dimensions with the last dimension containing string elements. In the optimization process I reorder...
- Thu Sep 03, 2009 6:01 pm
- Forum: General
- Topic: IBM Cognos Express and TM1
- Replies: 3
- Views: 14737
IBM Cognos Express and TM1
Does anyone know anything about IBM Cognos Express and how similar it is to TM1. I heard that its TM1 repackaged can anyone confirm that?
- Wed Sep 02, 2009 6:00 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Substituing a Variable in Excel with SUBNM
- Replies: 2
- Views: 2331
Substituing a Variable in Excel with SUBNM
I am trying to change an excel template that is used in our planning process. What I want to happen is for the user to be able to double click on the Account cell and a list of accounts related to their cost center will appear. They can then click on the account they want to plan for and enter in in...
- Mon Aug 24, 2009 12:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives for MS Excel Crashing
- Replies: 22
- Views: 31269
Re: Perspectives for MS Excel Crashing
I just developed this issue too and the resizing fix seems to be working. I can not believe the fix was so simple after nashing my teeth with this issue for over a week. Kudos