Search found 22 matches

by slu
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: 1708

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 ...
by slu
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: 3436

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...
by slu
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: 3436

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...
by slu
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: 13589

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
by slu
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: 1908

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, ...
by slu
Fri Apr 08, 2016 6:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form Stacked Dimensions
Replies: 4
Views: 2888

Active Form Stacked Dimensions

delete the post
by slu
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: 3850

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...
by slu
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: 3850

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)...
by slu
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: 2923

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
by slu
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: 2923

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 ...
by slu
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: 4700

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...
by slu
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: 4700

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...
by slu
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: 4700

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?
by slu
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: 4700

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...
by slu
Fri Feb 10, 2012 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Year-Quarter-Month Hierarchy
Replies: 5
Views: 3719

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...
by slu
Thu Feb 09, 2012 11:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Year-Quarter-Month Hierarchy
Replies: 5
Views: 3719

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...
by slu
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: 7480

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.
by slu
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: 7480

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", ...
by slu
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: 4116

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...