Search found 22 matches
- Fri Apr 03, 2020 6:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: picklist not showing selected string in active form
- Replies: 1
- Views: 1732
picklist not showing selected string in active form
I have an active form in excel used to show a list of accounts, then enter manual adjustment input, row set is an account list by MDX, I want to add assumption method for each account which is a picklist from an assumption cube, each account has an assumption method, if the account list is a static ...
- Tue Feb 06, 2018 7:28 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 ZeroOut View TI Process Code Help
- Replies: 4
- Views: 3590
Re: TM1 ZeroOut View TI Process Code Help
Hi Lotsaram and Mark, thanks for taking time to read and answer my post, I am aware that MDX is another way to create a temp subset for a temp view (removed the view in epilog in TI), the code was developed by a developer which I just admin the TM1 model. Mark's point is to create a zero-out view pr...
- Tue Feb 06, 2018 2:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 ZeroOut View TI Process Code Help
- Replies: 4
- Views: 3590
TM1 ZeroOut View TI Process Code Help
Hi there, I need to create a view to zero out. For some reason, the second condition did not work, could anybody help to pinpoint the problem in my TI process? I want h_accounts dim's subset to include all accounts with first digit as '1", but not include accounts last four digit as '1000' such...
- Fri Sep 29, 2017 8:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Xcelerator VBA API CAM Server Connect
- Replies: 10
- Views: 13908
Re: Xcelerator VBA API CAM Server Connect
Hi Matthew,
I saw your posting, I had a hard to time to get the N_CONNECT_CAM () working for me in planning analytics 2.0. I am interested in knowing how you stop the popup box and stop the confirmation after sending the key. Hope this post reaches you. Thank you
I saw your posting, I had a hard to time to get the N_CONNECT_CAM () working for me in planning analytics 2.0. I am interested in knowing how you stop the popup box and stop the confirmation after sending the key. Hope this post reaches you. Thank you
- Fri Sep 29, 2017 6:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Using VBA to automatically connect to TM1 server in Perspective (N_CONNECT_CAM)
- Replies: 0
- Views: 2238
Using VBA to automatically connect to TM1 server in Perspective (N_CONNECT_CAM)
I tested the N_CONNECT_CAM provided by IBM, no luck. I searched the forum, one post stated that he could connect in 32 bit excel successfully, I am uncertain what difference between us, I placed the bridge.dll in my client bin folder, input sAdminhost and sServerName in VBA code, then run the code, ...
- Fri Apr 08, 2016 6:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form Stacked Dimensions
- Replies: 4
- Views: 2936
Active Form Stacked Dimensions
delete the post
- Fri Feb 05, 2016 6:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use Cell Reference in Active Form Column Filter
- Replies: 4
- Views: 3905
Re: Use Cell Reference in Active Form Column Filter
I saw your posting about how to use cell parameters in the title dimension. Now I can dynamically change both the title and column inputs. Next step I will try to UNION two or three column filters and test whether the expression works. I personally like TM1 worksheet with drop down list vs. SUBNM, b...
- Fri Feb 05, 2016 5:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use Cell Reference in Active Form Column Filter
- Replies: 4
- Views: 3905
Re: Use Cell Reference in Active Form Column Filter
Works, thank you for your time.
- Thu Feb 04, 2016 6:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use Cell Reference in Active Form Column Filter
- Replies: 4
- Views: 3905
Use Cell Reference in Active Form Column Filter
All, I created a MDX expression using TM1 planning sample database, plan_BudgetPlan cube as an example. I basically wanted to pull all 0 level departments with FY2004 Budget, Wages expense (acct 61060) Jan-2004, local currency, budget source greater than 300000 (MDX dynamic subset filter by a value)...
- Tue Sep 15, 2015 3:52 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Scenario or Version Dim Design
- Replies: 2
- Views: 2990
Re: TM1 Scenario or Version Dim Design
Hi babytiger,
This is what we plan to implement right now. 2014 Budget, 2015 Budget..... As to forecast, we use Jan Forecast, Feb forecast, Jan forecast means 1+11, Feb forecast means 2+10... Thanks
This is what we plan to implement right now. 2014 Budget, 2015 Budget..... As to forecast, we use Jan Forecast, Feb forecast, Jan forecast means 1+11, Feb forecast means 2+10... Thanks
- Thu Sep 10, 2015 5:04 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Scenario or Version Dim Design
- Replies: 2
- Views: 2990
TM1 Scenario or Version Dim Design
It is probably a simple question to you. We have two general ledger cube, one is GL_ input cube for budgeting/forecasting purpose, another is GL cube for reporting purpose. the design of two cubes are similar, the GL reporting cube has more dimension from transactional GL data such as GL source, GL ...
- Tue Feb 28, 2012 12:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL Query Extract Taking 3 Hours To Load Using TI
- Replies: 7
- Views: 4782
Re: SQL Query Extract Taking 3 Hours To Load Using TI
I think my consultant fixed the problem by using numbertostring function for cust dimension, using ASCIItextout() for project ID, both processes worked suddenly. My TI experience is only sufficient to understand how written TIs do, I am not up to developing anything yet. Seems like an easy fix since...
- Tue Feb 21, 2012 6:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL Query Extract Taking 3 Hours To Load Using TI
- Replies: 7
- Views: 4782
Re: SQL Query Extract Taking 3 Hours To Load Using TI
I have not tested unchecking unicode. I think the issue is related to data type. The TI is used to update dimension (one is project, other is customer, both have problems), TI syntax does element adding to the dimension if element is not found. Our DBA team changed one dimension's data type (custome...
- Fri Feb 17, 2012 2:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL Query Extract Taking 3 Hours To Load Using TI
- Replies: 7
- Views: 4782
Re: SQL Query Extract Taking 3 Hours To Load Using TI
we use unicode (check), also we use rtrim(ltrim()) to repalce Oracle SQL trim(), wroks for other TIs, but not this one. The source data is a view, maybe that affects TM1?
- Fri Feb 17, 2012 12:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SQL Query Extract Taking 3 Hours To Load Using TI
- Replies: 7
- Views: 4782
SQL Query Extract Taking 3 Hours To Load Using TI
All, We upgrade from TM1 9.4 to 9.5.2. At the same time, we changed from Oracle SQL server to 2008 SQL server. Our source data is from JD Edward. The SQL statement we used to update a project dimension which is simple, there are only two variables to select, one is project ID (varchar), another is p...
- Fri Feb 10, 2012 2:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create Year-Quarter-Month Hierarchy
- Replies: 5
- Views: 3791
Re: Create Year-Quarter-Month Hierarchy
I understand both experts' comment, dimension update is nonrecurring. I tried to explain to a power user in the company (I am new to the company) that I can execute the TI to get most done (we have YTD and QTD in TI code too), then just add four quarters, then assign months to it. He insisted that i...
- Thu Feb 09, 2012 11:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Create Year-Quarter-Month Hierarchy
- Replies: 5
- Views: 3791
Create Year-Quarter-Month Hierarchy
I found a TI process in our system that creates our time dimension, but it rolls all months to year, rather than rolls Jan-mar to Q1 which is our existing structure. I tried to modify it based on my understanding of the code, I have difficulty to understand why Jan-Mar was rolled to both Q1-Q2 and Y...
- Mon Feb 06, 2012 5:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Change Element Order Using Element Editor Window
- Replies: 9
- Views: 7560
Re: Change Element Order Using Element Editor Window
Jim, what you said is that I should set the order as automatic first, then go to dimension editing window, I should get all changes stay. I think I did it one time, it works, then stop working. I am in TM1 9.4.1.
- Mon Feb 06, 2012 4:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Change Element Order Using Element Editor Window
- Replies: 9
- Views: 7560
Change Element Order Using Element Editor Window
All, I have a Jan-2012 YTD consolidated node in a wrong order under 2012 YTD in a time dimension, I want this node as the first sibling above Feb-2012 YTD, I cut Jan-2012 YTD plus two of its children, paste above Feb-2012 YTD, save it, " Set Dimension Order" was set as "Manual", ...
- Fri Feb 03, 2012 12:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Add New Periods To Time P Dimension-Things To Know-Help!
- Replies: 6
- Views: 4182
Re: Add New Periods To Time P Dimension-Things To Know-Help!
All, we have an elementattributes_bpmTime cube, Is "midly reassuring" meant we are ok? Most of our reports' column fields (time periods) use attributes from this cube, mainly two, 'YearToDate', 'Prior Year', I spent one hour to review rule codes in }elementattributes_bpmTime cube yesterday...