Search found 11 matches

by cbergen
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...
by cbergen
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
by 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...
by cbergen
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
by cbergen
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...
by cbergen
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...
by cbergen
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...
by cbergen
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...
by cbergen
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?
by cbergen
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...
by cbergen
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