Search found 14 matches

by Thurston Howell III
Wed Nov 01, 2017 3:28 pm
Forum: Cognos TM1
Topic: Unusual Problems with Text Files in TI Processes
Replies: 3
Views: 141

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: Cognos TM1
Topic: TI Process Doubling Elements?
Replies: 4
Views: 275

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: Cognos TM1
Topic: TI Process Doubling Elements?
Replies: 4
Views: 275

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: Cognos TM1
Topic: Data Source File Hung Up After TI Process??
Replies: 4
Views: 607

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: Cognos TM1
Topic: Data Source File Hung Up After TI Process??
Replies: 4
Views: 607

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: Cognos TM1
Topic: TI Process Runs Without Errors, But Does Nothing?
Replies: 3
Views: 324

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: Cognos TM1
Topic: WHILE Statement Wants Another End?
Replies: 2
Views: 267

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: Cognos TM1
Topic: WHILE Statement Wants Another End?
Replies: 2
Views: 267

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: Cognos TM1
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1157

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: Cognos TM1
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1157

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: Cognos TM1
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1157

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: Cognos TM1
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1157

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: Cognos TM1
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1157

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: Cognos TM1
Topic: Updating Element Attributes in TI Process
Replies: 13
Views: 1157

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