Search found 31 matches

by tgaluskapatterson
Wed Aug 20, 2014 7:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Created a dynamic subset. It works in TM1, not in DBRW!
Replies: 4
Views: 3935

Re: Created a dynamic subset. It works in TM1, not in DBRW!

Also keep in mind when you are using a dynamic subset in excel/websheet that you will need to have the dynamic subset calculate before the DBRW does. I received a Key*Error when creating a websheet in perspectives and the solution was the dynamic subset dimension needed to be represented as a DBR. D...
by tgaluskapatterson
Mon Jun 30, 2014 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process View Creation Error
Replies: 1
Views: 1927

TI Process View Creation Error

TM1 10.2 I currently have a TI process that creates view zLoadDriverDetail in my Driver cube. Something strange is occuring to the view when it is created. If i comment out the last two lines which are assigning subsets to the rows of this view results come back with no error. If I remove the commen...
by tgaluskapatterson
Tue May 13, 2014 6:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Input Entry Long Wait Time
Replies: 5
Views: 3752

Re: Input Entry Long Wait Time

Thanks tomok! I will work on writing a conditional feeder to only populate the combinations enter in the input section. Again I appreciate it.
by tgaluskapatterson
Tue May 13, 2014 5:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Input Entry Long Wait Time
Replies: 5
Views: 3752

Re: Input Entry Long Wait Time

Perfect! This really helps me narrow down my issue. I have copied my feeders from the rules editor below. PAY NON COM and PAY COM are consolidate elements in my account dimension that have about 15-20 elements each in them. I am feeding the consecutive years in the salary input view so they can popu...
by tgaluskapatterson
Tue May 13, 2014 3:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Input Entry Long Wait Time
Replies: 5
Views: 3752

Input Entry Long Wait Time

Using TM1 10.2 with Excel 2010. I am building a new salary cube in TM1 10.2. I enter my information for Name, Class, Title, Status, Start Month, Review Month and GL Account. Everything works just great. Then when I enter PY Starting Salary and hit tab or enter my screen takes between 60-90 seconds t...
by tgaluskapatterson
Tue Mar 25, 2014 3:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Change Weight Of Top Level In Hierarchy
Replies: 5
Views: 5538

Re: TI Change Weight Of Top Level In Hierarchy

Hierarchy Total Assets Liabilities & Equity Net Profit I can adjust the weight of these consolidated levels by opening the dimension editor right click and go to element properties. The Dimension Element Properties screen allows me to adjsut the weight at the top or consolidated level. I am tryi...
by tgaluskapatterson
Tue Mar 25, 2014 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Change Weight Of Top Level In Hierarchy
Replies: 5
Views: 5538

TI Change Weight Of Top Level In Hierarchy

I am working in 10.2 Architect trying to create a TI process to update my account dimension. The current structure has Assets, Liabilities, and Net Profit rolling up to the top level of the hierarchy Total. My users have requested an alternative hierarchy that only includes balance sheet activity. S...
by tgaluskapatterson
Tue Mar 11, 2014 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing Element For AttrPutS
Replies: 8
Views: 5789

Re: Missing Element For AttrPutS

I could be going about this the wrong way. So my initial thought was that I could build one process the create the dimension. Here is the code I wanted to use. #Add Level Four Length=LONG(TRIM(RSLEVELCODE)); If(Length=2); DimensionElementInsert('CostCenter','',TRIM(RSCOSTCENTER)|'-'|TRIM(RSCOMPANY),...
by tgaluskapatterson
Tue Mar 11, 2014 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing Element For AttrPutS
Replies: 8
Views: 5789

Re: Missing Element For AttrPutS

Thanks Jim!

I moved the code to attribute code to the data tab. The unfortuanate part is it appears I would need one process for each level the the cost center dimension. Is their anyway around that? Its not a big deal was just looking to have less processes to run. Thank again!
by tgaluskapatterson
Tue Mar 11, 2014 12:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing Element For AttrPutS
Replies: 8
Views: 5789

Missing Element For AttrPutS

TM1 10.2.0 Excel 2010 I have written the code below to add the fourth level onto my cost center or hierarchy dimension. When I run all the code on the metadata tab I get the following error. Data Source Line (1) Error:Metadata procedure line (16):Element "CF-10" not found in dimension 'Cos...
by tgaluskapatterson
Thu Feb 20, 2014 5:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ownership at Consolidated Level Cannot Commit at 0-Level
Replies: 1
Views: 2497

Ownership at Consolidated Level Cannot Commit at 0-Level

Win 7 64 bit Excel 2010 I have attached a document that outlines step by step the issue I am having. The short of it is that I appear to be having issues with the commit button when preforming that same task two different ways. I might need to log a bug with IBM just wanted to check the forum to see...
by tgaluskapatterson
Wed Jan 15, 2014 6:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Java Heap Space Error
Replies: 1
Views: 2633

Java Heap Space Error

Win 7 64 bit Excel 2010 Insight 10.2.1 Today i was testing the 'Get Data' option in Insight. I connected to a relational database and used the query builder in attempts to open a table. When i clicked the refresh button to view the data in the table to see the general format i received the attached ...
by tgaluskapatterson
Thu Dec 12, 2013 7:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Initiatives Cube with Spread Method Calculation
Replies: 2
Views: 2437

Re: Initiatives Cube with Spread Method Calculation

I agree this is a complicated way. As far as the percentage split is concerned. How would that work for a 4-4-5 split if the user can ideantify Start and End Month. The denominator is a moving target. For Example: If Nov has 4 weeks, Dec had 4 weeks, Jan has 5 weeks and Feb has 4 weeks and so on. If...
by tgaluskapatterson
Thu Dec 12, 2013 3:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Initiatives Cube with Spread Method Calculation
Replies: 2
Views: 2437

Initiatives Cube with Spread Method Calculation

Currently on Win XP, TM1 10.1, and Excel 2007 I am constructing an Initiatives Cube for a forecast model that is in development. As you can see from the print screen the manual spread method works just fine. It takes the Amount Change for Period Input divided by the (End Month minus the Start Month)...
by tgaluskapatterson
Thu Nov 21, 2013 6:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Approval Hierarchy Move From 10.1.1 to 10.2
Replies: 3
Views: 4916

Approval Hierarchy Move From 10.1.1 to 10.2

Using Win 7 on the new TM1 10.2 I started playing with the new 10.2 today and tried to import my old approval hierarchy via performance modeler from 10.1.1 in 10.2. I received the following error "The approval hierarchy has members missing below the top level member." when attempting to va...
by tgaluskapatterson
Tue Aug 13, 2013 5:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process - Value Field Have Numbers and Strings
Replies: 3
Views: 4117

TI Process - Value Field Have Numbers and Strings

TM1 10.1 Window XP Excel 2007 Architect TI Process I currently have a TI process in place to copy budget information from an active version that rules run on to a static version. I am using the ViewCreate function to generate the view to copy my data from. The issue I am running into is the variable...
by tgaluskapatterson
Tue Jul 02, 2013 1:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Combined Dimensions
Replies: 5
Views: 4024

Re: Combined Dimensions

Good point. We tested a customer change in our dev environment and it appeared to work just fine. If a customer changed territories the data loaded in the new month created a new "TerritoryCustomer" field which is what I would expect. Thanks for the input.
by tgaluskapatterson
Mon Jul 01, 2013 4:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Combined Dimensions
Replies: 5
Views: 4024

Re: Combined Dimensions

We recently completed a cube re-design on this cube. We combined the Territory and Customer dimensions which had 33,714 elements and 377,634 elements into one TerritoryCustomer dimension with 570,642 elements. This significantly reduced the load time of the cube from about 30 seconds to about 17-18 ...
by tgaluskapatterson
Tue Jun 25, 2013 6:47 pm
Forum: Commercial and Events
Topic: Twin Cities Cognos User Group
Replies: 0
Views: 4872

Twin Cities Cognos User Group

Twin Cities Minnesota Cognos User Group has been started. I missed the first one however I hear they are planning on every 6 months or so. Word is the next will be in November 2013. I have attached a flyer from the last meeting.
by tgaluskapatterson
Tue Jun 25, 2013 5:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos BI or Microstrategy over TM1
Replies: 8
Views: 7084

Re: Cognos BI or Microstrategy over TM1

I have used Cognos BI in the past and really like the product. Queries and report are easy to design and advances reports take some time to get used to the coding format but its easy once you get a feel for it. Currently my company uses TM1 and Microstrategies. We have been on Microstrategies 7 for ...