TM1 Forum

Hi All:

About the chore i found that some of the process can't be selected which are in cross status.

I want to ask the process when single execute is success. But why the status is cross when selected by the chore?

Aruis.yu wrote: About the chore i found that some of the process can't be selected which are in cross status.

I want to ask the process when single execute is success. But why the status is cross when selected by the chore?

I'm probably on safe ground in assuming that English is not your first language. While people are prepared to make allowances for that I would recommend that you use screenshots when asking a question. They would help to clarify your meaning.

I'm not at all sure what you're asking. My best guess is that you are referring to processes which are in an uncompiled state but "cross status" doesn't really describe these. In 9.5.2 they appear in the process list with an easy to see red dot with a white bar. In 10.x they appear with a microscopic green square over the chore icon, and you will only see that square if you stare at each process in turn.

In neither case can they be "selected by the chore" because uncompiled processes don't appear in the process list to begin with.

If that's what you're referring to, then you start by opening the process and trying to save it. That will display a dialog telling you where the error is in the code.

But I'm afraid that I can't fathom what you're asking here:

I want to ask the process when single execute is success.

That could mean any number of things.

Alan Kirk wrote: I'm probably on safe ground in assuming that English is not your first language. While people are prepared to make allowances for that I would recommend that you use screenshots when asking a question. They would help to clarify your meaning.

I'm not at all sure what you're asking. My best guess is that you are referring to processes which are in an uncompiled state but "cross status" doesn't really describe these. In 9.5.2 they appear in the process list with an easy to see red dot with a white bar. In 10.x they appear with a microscopic green square over the chore icon, and you will only see that square if you stare at each process in turn.

In neither case can they be "selected by the chore" because uncompiled processes don't appear in the process list to begin with.

If that's what you're referring to, then you start by opening the process and trying to save it. That will display a dialog telling you where the error is in the code.

But I'm afraid that I can't fathom what you're asking here:

I want to ask the process when single execute is success.

That could mean any number of things.

Sorry for not describing the question in detail. Actually I just found that if my data source is the .xlsx format. The chores in PM can't select these process. But if the source file turn to .csv then the issue solved. But the .xlsx file can support the cross table. This is the contradiction point.

Aruis.yu wrote:Sorry for not describing the question in detail. Actually I just found that if my data source is the .xlsx format. The chores in PM can't select these process. But if the source file turn to .csv then the issue solved. But the .xlsx file can support the cross table. This is the contradiction point.

I assume the IBM Technote 1656562 answers your question:

http://www-01.ibm.com/support/docview.w ... wg21656562
TM1 TurboIntegrator Processes with specific data sources not supported in Chores

Technote (troubleshooting)

Problem(Abstract)
It is possible to create IBM Cognos TM1 TurboIntegrator processes in Performance Modeler that use the following data sources:
- IBM Cognos Report Data
- IBM Cognos Package Data
- Microsoft Excel files
However, processes that use these data sources cannot be scheduled in chores. Performance Modeler prevents a TurboIntegrator process using any of these data sources from being added to a chore.