Contributor; Take ownership on C-level node

[sander]

Hello All,

I have a problem with a TM1 contributor application, I want to take ownership of a node on c-level and i ghet the next message;

SH_ 2011-08-3001.jpg (11.24 KiB) Viewed 4638 times

I have set submit rights to the node for the user in Contributor, I also did this for the n-level leaf nodes of this element. What I do see is that when I submitted all leaf nodes I can submit the c-level node. But I still do not have ownership, I can't for example make a sand-box. Is this normal behaviour? I can't find anything about it in the manul's or on the web.
I also get the next error message when i reject a submission (as admin) from another user, but when I go back i can see that the rejection did take place.

SH_ 2011-08-3002.jpg (11.02 KiB) Viewed 4638 times

I also don't find any errors in the }tp_process_errors cibes

Al this problems are with the admin user
I imported this application from TM1 Contributor 9.5

Does anyone have an idea

Regards,
Sander

[rozef]

I remember when I tried to use Contributor with 9.1, I couldn't create ownership one consolidated elements too. Worst, contribtor has created a "control user" for all leaf elements on primary dimension.

My advice: don't use it, make your own workflow with cubes and rules, it will be more flexible and you won't have this kind of troubles.

[sander]

Someone with a better idea?

[Martin Ryan]

The error message suggests that a TI process failed, so take a look in the error logs and it should say why, or at least tell you which line of TI code is failing.

With Express I've found quite a few errors in Contributor are caused by not having qualified names e.g. having mryan instead of Cognos\Martin Ryan.

Martin

[sander]

Finally found some time to get into this problem.
Indeed it is a problem in a TI-proces, it's an mdx statement which is generated in one of the TI proces generated by contributor (the }tp_... processes). I found an error in the processes;


}tp_workflow_enter_node, Is used while entering nodes
In the prolog line 196, here is a statement

Code: Select all

SubsetCreateByMdx(vSubset, vMDX);

where vMDX is;

Code: Select all

vMDX = '{INTERSECT(TM1FILTERBYLEVEL({DESCENDANTS([' | gApprovalDim | '].[' | pNode | ']) }, 0), [' | gApprovalDim | '].[' | gApprovalSubset | ']), ['| gApprovalDim | '].[' | pNode | ']}';

Filed this issue also with IBM, this is a known issue, you can't use a subset with the same name as the dimension in contributor (COGCQ00633058). This indeed solves the problem with entering nodes om c-level.
But when you now wan't to 'take ownership' of a c-level node you get another error message, which also in the end relates to MDX, in the proces
}tp_workflow_take_owner_group_on_consolidation

I returned this issue also to IBM, still waiting for reply.

Anyone else who ran into the same problems?