Search found 17 matches

by ascheevel
Fri Dec 15, 2017 12:42 pm
Forum: Cognos TM1
Topic: TI Process Read Lock on CSV Source File
Replies: 2
Views: 118

Re: TI Process Read Lock on CSV Source File

Thanks for the reply BariAbdul, the log file only has a sf_File: DeleteFileError when trying to run the export TI process. I know that the import TI process is the one that has the read lock on the file. Thank you for linking that other thread, I'd tried most there except command line to manage sepa...
by ascheevel
Thu Dec 14, 2017 9:34 pm
Forum: Cognos TM1
Topic: TI Process Read Lock on CSV Source File
Replies: 2
Views: 118

TI Process Read Lock on CSV Source File

Has anyone run into a TI process not releasing its read lock on a csv or txt file after completion? The offending file is one that is used for export from one TM1 server and import to another. I use RunTi to call the export and import and run the processes sequentially so I know it's not a case of t...
by ascheevel
Thu Dec 14, 2017 1:30 pm
Forum: Cognos TM1
Topic: Use only one connection slot for multiple, parallel requests
Replies: 1
Views: 84

Re: Use only one connection slot for multiple, parallel requests

What is the reason for limiting the connections? I believe the structure of parallel processing requires separate connections for each request in order to truly be parallel. For example, when I kick off parallel processes with RunTi, there will be one connection for each process running and that con...
by ascheevel
Thu Dec 14, 2017 8:48 am
Forum: Cognos TM1
Topic: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
Replies: 6
Views: 183

Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working

Glad the COM add-in fixed your issue. We've run into issues with CAFE and PAX where the add-in load behavior will switch from automatic to manual and we need to go into the registry editor and manually change the load behavior of the add-in; otherwise the users need to go into their add-ins options ...
by ascheevel
Wed Dec 13, 2017 3:04 pm
Forum: Cognos TM1
Topic: PA for Excel 2.0.3 - not appearing in the Ribbon- not working
Replies: 6
Views: 183

Re: PA for Excel 2.0.3 - not appearing in the Ribbon- not working

Did you also check it was enabled in your COM addins?

Am I reading correctly that you're running TM1 10.2.2 and not Planning Analytics? If that's the case, I believe the excel add-in is a different product: CAFE.
by ascheevel
Wed Dec 06, 2017 7:05 pm
Forum: Cognos TM1
Topic: TI process is not getting executed from a Worksheet Application. Please help kind folks!
Replies: 10
Views: 638

Re: TI process is not getting executed from a Worksheet Application. Please help kind folks!

Did you open the websheet from the applications menu within perspectives server explorer or did you open it from saved file location? Did you make sure you're connected to the TM1 server the TI processes are to be run from?
by ascheevel
Wed Dec 06, 2017 9:41 am
Forum: Cognos TM1
Topic: carry forward a dimension elements to another dimension
Replies: 5
Views: 275

Re: carry forward a dimension elements to another dimension

Dimension A is an exact copy of Dimension B, why not use only one dimension? If you must use two dims, you can use a WHILE loop in the prolog or epilog tab of a TI process to spin through all elements in Dimension B and add to Dimension A. Below is sample code for looping through all elements of Dim...
by ascheevel
Wed Nov 29, 2017 7:17 am
Forum: Cognos TM1
Topic: Is TM1 dimension index important?
Replies: 4
Views: 390

Re: Is TM1 dimension index important?

You would write the rule in TM1 similar to how you did it in HFM, you don't need to account for the element index. In TM1, you can use ELISANC or ELPAR to determine if element is descendant/child of "TOTAL ASSETS". I really only use an element's index when looping through elements of a dimension in ...
by ascheevel
Fri Nov 10, 2017 7:31 am
Forum: Cognos TM1
Topic: Cannot insert new element in element attribute dimension
Replies: 7
Views: 205

Re: Cannot insert new element in element attribute dimension

Below is sample code for adding "Description" as an attribute to TradeID assuming the TradeID is variable V1 and description is variable V2 off your datasource.

Prolog tab:

Code: Select all

AttrInsert('TradeID, '', 'Description', 'S');

Data tab:

Code: Select all

AttrPutS(V2, 'TradeID', V1, 'Description');
by ascheevel
Fri Nov 10, 2017 6:59 am
Forum: Cognos TM1
Topic: Cannot insert new element in element attribute dimension
Replies: 7
Views: 205

Re: Cannot insert new element in element attribute dimension

Are you right-clicking on the attribute dimension or the dimension whose elements you're trying to add attributes for? For example, if I want to add a new attribute to a Product dimension, I right-click the "Product" dimension and select "Edit Element Attributes...", not the "}ElementAttributes_Prod...
by ascheevel
Fri Nov 10, 2017 6:50 am
Forum: Cognos TM1
Topic: Export Data from Cube View to File
Replies: 4
Views: 181

Re: Export Data from Cube View to File

A TI process that uses a time subset based on your criteria for the source view should work. Or if you wanted to be lazy, you could evaluate all time periods and then filter in the data tab what gets written to file.
by ascheevel
Fri Nov 10, 2017 6:47 am
Forum: Cognos TM1
Topic: Cannot insert new element in element attribute dimension
Replies: 7
Views: 205

Re: Cannot insert new element in element attribute dimension

You can right-click the dimension in server explorer, select Edit Element Attributes, and then Edit->Create New Attribute or you can use DimensionAttrInsert in a TI process.
by ascheevel
Wed Oct 18, 2017 3:49 pm
Forum: Cognos TM1
Topic: MDX expession
Replies: 3
Views: 251

Re: MDX expession

UNION should work
by ascheevel
Thu Oct 12, 2017 12:45 pm
Forum: Cognos TM1
Topic: replace a subset value in db function
Replies: 4
Views: 244

Re: replace a subset value in db function

Consolidation called 'Prior Month' would work too.
by ascheevel
Tue Oct 10, 2017 12:12 pm
Forum: Cognos TM1
Topic: How to re-use the data from source twice?
Replies: 3
Views: 199

Re: How to re-use the data from source twice?

I agree with qml that there might be a better solution that doesn't involve spinning through the datasource twice, but if you're set on it, you could always run the process twice and use a parameter and if statement to segregate operations between first and second run. You can call the second run fr...
by ascheevel
Tue Oct 10, 2017 5:50 am
Forum: Cognos TM1
Topic: Need help to create TI process to copy data
Replies: 5
Views: 340

Re: Need help to create TI process to copy data

To expand on what Drg said, you can use a WHILE loop to apply one value to multiple target elements, periods in this case. If I'm understanding your question right, you're trying to take a value from one month in the current year, say October, and write that value to all the months in the next year,...
by ascheevel
Fri Mar 08, 2013 3:27 pm
Forum: Cognos TM1
Topic: TM1 trend forecasting
Replies: 6
Views: 1289

Re: TM1 trend forecasting

I'm curious to see what other people have to say, but I've been leery about doing anything more complicated than a rolling average when it comes to trending in TM1. For forecasted sales volume, we do interface with Logility Demand Planning, using TM1 to gather some of the inputs and manual forecast ...