Search found 20 matches

by Thurston Howell III
Mon Mar 26, 2018 8:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Date held as number but formatted as date
Replies: 5
Views: 671

Re: Date held as number but formatted as date

What are you doing to drive the formatting?
by Thurston Howell III
Mon Mar 26, 2018 7:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dimension is not available in TM1Web
Replies: 2
Views: 433

Re: Dimension is not available in TM1Web

Is your SUBNM referring to a view in the old dimension that no longer exists?
by Thurston Howell III
Thu Dec 07, 2017 10:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Audit Log Configuration
Replies: 4
Views: 375

Re: Audit Log Configuration

That makes sense. THanks for the help!
by Thurston Howell III
Thu Dec 07, 2017 9:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Audit Log Configuration
Replies: 4
Views: 375

Re: Audit Log Configuration

Tomok, I understand that. What I mean is that I think the log only goes back so far. I would like to expand how far back it retains transactions for future use.
by Thurston Howell III
Thu Dec 07, 2017 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is TM1 dimension index important?
Replies: 4
Views: 572

Re: Is TM1 dimension index important?

It is absolutely important, just not for what you're looking to do. The benefit of the index numbers is that every element, regardless of how of how often it appears in a dimension, will have one identifying index number, which is very helpful if you're writing TI processes that edit your dimension ...
by Thurston Howell III
Thu Dec 07, 2017 4:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Audit Log Configuration
Replies: 4
Views: 375

Audit Log Configuration

Hi All,

I am trying to change how far back my Audit Log files go and thus far I've only seen reference to the Interval period in the tm1s.cfg file, which has nothing to do with what I want. I am looking to change the number of days of information that it stores. Where would this be configured?
by Thurston Howell III
Wed Nov 01, 2017 3:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unusual Problems with Text Files in TI Processes
Replies: 3
Views: 286

Unusual Problems with Text Files in TI Processes

Hi All, I have a TI process that loads data from a nightly text file out of our ERP. Right now a large block of the data no longer loads. I cannot see anything unusual in any of the lines in the block or in the lines before and after it (no special characters, leading or trailing spaces etc). This p...
by Thurston Howell III
Wed Sep 13, 2017 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Doubling Elements?
Replies: 4
Views: 485

Re: TI Process Doubling Elements?

Thanks for the feedback, everyone. Every element in the dimension exists in the rollup called CDM.

I can't believe it was just the order in DIMIX. :roll:

Lovey is NOT happy with her Thurston.
by Thurston Howell III
Tue Sep 12, 2017 10:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Doubling Elements?
Replies: 4
Views: 485

TI Process Doubling Elements?

My TI process tests as to whether or not an element exists and adds it to a rollup if it does not. This part it does fine, but it is also determining some extant elements do not exist and adding them again, giving me duplicates. From my code I cannot see anything wrong. I tried a ProcessQuit to dete...
by Thurston Howell III
Fri Jul 21, 2017 9:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Source File Hung Up After TI Process??
Replies: 4
Views: 808

Re: Data Source File Hung Up After TI Process??

The file is pushed out every night from a separate accounting system, not something generated by a TM1 process.
by Thurston Howell III
Tue Jul 18, 2017 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Source File Hung Up After TI Process??
Replies: 4
Views: 808

Data Source File Hung Up After TI Process??

I have a TI process that runs on a nightly schedule. The data source is a text file that is replaced daily by an updated version. Occasionally the source file gets hung up after the process runs and cannot be replaced because it thinks it is currently open and in use. The message log indicates that ...
by Thurston Howell III
Wed May 31, 2017 7:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Runs Without Errors, But Does Nothing?
Replies: 3
Views: 515

TI Process Runs Without Errors, But Does Nothing?

I have a TI process that runs without errors, but does nothing to the targeted cube. On the Data tab, when I replace the element vSubAccount with a specific element, it performs the task as expected, and when I leave it as vSubAccount but replace the final ELSE with "ELSE; ProcessQuit; " I get the e...
by Thurston Howell III
Tue May 30, 2017 10:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: WHILE Statement Wants Another End?
Replies: 2
Views: 411

Re: WHILE Statement Wants Another End?

Alan,

Thank you for spotting that! That fixed my error. Thank you.
by Thurston Howell III
Tue May 30, 2017 9:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: WHILE Statement Wants Another End?
Replies: 2
Views: 411

WHILE Statement Wants Another End?

I am working on a TI process that will re-organize some elements within a dimension into two consolidations, both meeting the same rollup point. I set up a loop using a While/End statement, but when I save it I get an error pointing to the line with the END; and asking "END OF ENDIF statement missin...
by Thurston Howell III
Fri Mar 17, 2017 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1459

Re: Updating Element Attributes in TI Process

I used SUBSETELEMENTINSERT after my MDX expression to turn it static and now it works perfectly. Thanks for alerting me to the issue being the dynamic subset!
by Thurston Howell III
Fri Mar 17, 2017 3:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1459

Re: Updating Element Attributes in TI Process

It is still a dynamic subset.

I had my code to delete the subset in the epilog.

IF ( SUBSETEXISTS ( SourceDim , SubsetName ) = 1 ) ;
SUBSETDESTROY ( SourceDim , SubsetName );
ENDIF;
by Thurston Howell III
Fri Mar 17, 2017 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1459

Re: Updating Element Attributes in TI Process

Alright the function SubsetMDXSet works, but I am still getting the "Element not found" error with reference to the line Elem = SUBSETGETELEMENTNAME( SourceDim , SubsetName , n )
by Thurston Howell III
Thu Mar 16, 2017 9:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1459

Re: Updating Element Attributes in TI Process

That function sounds like it would be very useful, then. Would I be best off inserting it after the SUBSETCREATEBYMDX statement?
by Thurston Howell III
Thu Mar 16, 2017 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1459

Re: Updating Element Attributes in TI Process

Tom: It updated some of the elements, but only gave the error once and aborted the process. Matt: Thanks for the suggestion. I am not familiar with that function and do not see it in the Reference Guide. Is it available in 10.2.2? I tried to process again and the specific error is "Element not found".
by Thurston Howell III
Thu Mar 16, 2017 4:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1459

Updating Element Attributes in TI Process

Hi All, I am creating a TI process to update an element attribute with the name of the element if that field is not already populated. I ran the process and it worked for most of the elements, but produced an unspecified error with reference to line 42 (which begins "Elem = SUBSETGETELEMENTNAME...."...