Search found 43 matches

by ascheevel
Thu Dec 27, 2018 7:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule shows syntax error on Commented line !
Replies: 4
Views: 2756

Re: Rule shows syntax error on Commented line !

This was a long time ago, but a coworker was getting a similar error on commented lines in advanced rule editor where they had a tab or a few spaces before the "#" character for the commented line. Removing the space/tab seemed to fix the error. I just tried to replicate the issue as I remembered it...
by ascheevel
Fri Dec 21, 2018 12:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding new element to measure dimension
Replies: 4
Views: 316

Re: Adding new element to measure dimension

Yes of course, provided you aren't inserting the new element as a child of an already existing zero level element.
by ascheevel
Thu Nov 01, 2018 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Retaining lock on file
Replies: 3
Views: 462

Re: TI Retaining lock on file

We've had the same issue. I've had the server admin unlock the file with varying success, but a model restart always fixes the issue. One thing I tried last summer was to execute a command to delete a file in the prolog tab, wait 20 seconds, and then do a FileExists check. If the file was still ther...
by ascheevel
Fri Oct 12, 2018 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 web form date issue - PA 2.0
Replies: 2
Views: 383

Re: TM1 web form date issue - PA 2.0

We have the same issue in our headcount planning app. It's a tedious workaround, but when someone is creating multiple new positions with the same start date, we've instructed the user to select an alternate date, recalc, and then select the originally desired start date before submitting the next p...
by ascheevel
Thu Oct 04, 2018 2:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 PAX plugin disappears
Replies: 3
Views: 386

Re: Tm1 PAX plugin disappears

Second the comment making sure the com add-in is enabled. Sometimes after the add-in gets disabled and we've subsequently re-enabled it, it still doesn't load on excel startup forcing the user to re-enable it each time. When that happens we modify the load behavior of the add-in in the registry to g...
by ascheevel
Thu Jun 21, 2018 12:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders not being fed for consolidated elements
Replies: 1
Views: 378

Re: Feeders not being fed for consolidated elements

It looks like you've confirmed that leaf elements of A001 aren't fed, the way to fix this is to feed them. You'll need to review the rule that applies to those elements and then ensure there's an adequate feeder from an intersection that's referenced by the rule.
by ascheevel
Tue May 29, 2018 6:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI for placing a file on SFTP server
Replies: 4
Views: 766

Re: TI for placing a file on SFTP server

You could use a tool like WinSCP to do the transfer. You can write a script for that program that can be called from a TI process in the same way that you'd call a .bat file.
by ascheevel
Sat May 05, 2018 8:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing values in TI for sql query
Replies: 4
Views: 687

Re: Passing values in TI for sql query

If you found a way that works, why do you assume you're not doing it correctly? The where statement that failed: WHERE [MONTH] in ('PM1') likely should have been WHERE [MONTH] IN ('?PM1?'). You need the question marks regardless if you're passing string or number, it's the single quotes that you may...
by ascheevel
Fri May 04, 2018 7:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Passing values in TI for sql query
Replies: 4
Views: 687

Re: Passing values in TI for sql query

Below is a link i found through google that can probably explain how to do it better than i can. It shows an example of putting the variable right in the datasource window as well as defining the SQL in the prolog tab. We use the variable in the window method and I'm going to switch them to using pr...
by ascheevel
Mon Mar 05, 2018 6:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieve list of result
Replies: 1
Views: 385

Re: Retrieve list of result

If you're just using subset editor, you can filter by attributes. You can also create a dynamic subset with mdx that does the same thing. A dynamic subset can then be referenced in TI processes or saved cube views and you wouldn't need to worry about adding new elements to the list since it'd be dyn...
by ascheevel
Mon Feb 12, 2018 1:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help with Rule to write to Consolidated Level
Replies: 4
Views: 797

Re: Need help with Rule to write to Consolidated Level

Did i get your sample cube mocked up right in the attached picture where you want DB('Sample Cube', 'Actual', '201712', '155', 'TOTAL REGION', 'Gross Value') to equal DB('Sample Cube', 'Actual', '201712', '155', 'TOTAL REGION', 'Net')? If so, the right side of your consolidated rule is simply a DB r...
by ascheevel
Mon Feb 12, 2018 7:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help with Rule to write to Consolidated Level
Replies: 4
Views: 797

Re: Need help with Rule to write to Consolidated Level

Have you tried something already and it's not working? If so, can you post what you have so far? I'm not entirely clear if you're wanting a rule to display a certain value at a consolidated level or if the cell the rule will apply to is N level, but the value it will display will be from a consolida...
by ascheevel
Wed Feb 07, 2018 2:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementAttributes Rule and TI conflict
Replies: 10
Views: 1741

Re: }ElementAttributes Rule and TI conflict

kenship wrote:
Wed Feb 07, 2018 1:20 pm
I suspended the AttrDelete and AttrInsert commands the the process run without error. I wonder should it be permanently withdrawn.
This sounds like your answer right there, don't delete and reinsert the attribute during dimension update and you should be good.
by ascheevel
Wed Feb 07, 2018 6:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementAttributes Rule and TI conflict
Replies: 10
Views: 1741

Re: }ElementAttributes Rule and TI conflict

Can you post the contents of the Prolog tab of the TI process that updates your budget element dimension?
by ascheevel
Tue Feb 06, 2018 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feed when rule includes if statement
Replies: 3
Views: 595

Re: Feed when rule includes if statement

The feed from cell doesn't need to be a cell referenced in the rule, it can be a cell that will not be zero when you'd expect the rule calced cell to evaluate to something other than zero. A little doubt is good, it helps you make absolutely certain the alternative cell you want to feed from will wo...
by ascheevel
Tue Feb 06, 2018 9:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feed when rule includes if statement
Replies: 3
Views: 595

Re: Feed when rule includes if statement

I would use Annual_Salary as your feeder like you're planning. Annual_Salary is the dependent cell, so using it as a feeder source will ensure that only employees with an annual salary will have this measure fed. If you feed from your lookup cube, you'll have to feed all employees. I don't know your...
by ascheevel
Fri Feb 02, 2018 3:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is Hierarchy Sort?
Replies: 1
Views: 476

Re: What is Hierarchy Sort?

It arranges the elements in a hierarchy view with levels. If you want to visualize what it does, within the subset editor show all elements, sort A-Z or by Index, and then sort by Hierarchy.
by ascheevel
Mon Jan 29, 2018 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation value based on values of children
Replies: 4
Views: 863

Re: Consolidation value based on values of children

You're on 10.1.1 right? In 10.2.2 and later, a rule function ConsolidatedMin might easily accomplish what you're trying to do (link below). Without that, a TI might be the simplest to implement, especially if you're ok with the data not being realtime. The TI would have as a datasource the level 1 c...
by ascheevel
Tue Jan 23, 2018 2:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's new in "IM Cognos Planning Analytics Web (TM1 Web)"
Replies: 5
Views: 1293

Re: What's new in "IM Cognos Planning Analytics Web (TM1 Web)"

Silw, while it was a big change underneath, I don't recall the end user experience changing much.
by ascheevel
Mon Jan 22, 2018 2:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What's new in "IM Cognos Planning Analytics Web (TM1 Web)"
Replies: 5
Views: 1293

Re: What's new in "IM Cognos Planning Analytics Web (TM1 Web)"

It's not a whole lot different and functionality is mostly the same. The color scheme, icon set, and subset editor have been updated. We had minimal issues transitioning users after the upgrade.