Search found 13 matches

by Thurston Howell III
Wed Sep 13, 2017 2:14 pm
Forum: Cognos TM1
Topic: TI Process Doubling Elements?
Replies: 4
Views: 178

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: 178

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: 557

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: 557

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: 252

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: 197

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: 197

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: 984

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: 984

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: 984

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: 984

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: 984

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: 984

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