Selection option limitation problem

[TomaszB]

Hi Everyone,

I’m trying to build a simple selection matrix where the possible options should be limited after the first and each selection.
This means that if someone selects the action A1, then this option should not be available for further selection in any other dimension element.

The attached picture demonstrates it in more clear way.
In this example we have risks and we are selecting actions for the risks. If an action is selected for Priority1 it should not be available for any other Risk or Priority.

LoopProblem.png (20.75 KiB) Viewed 3121 times

I tried to do this limitation using few rules but I'm stopping always on the last step where a loop occurs.
I analyzed it and it is somehow understandable because I’m changing the input data, but I thought always that TM1 is not looping twice over a point in cube if it was already processed in the rule.

Do you have maybe an idea or hint how could I solve this problem?

Many thanks in advance

TMP.zip

Model

(32.58 KiB) Downloaded 290 times

[jim wood]

Try using a picklist and put rules on the picklist. I've used this to limit country selections based on regions in the past,

Jim.

Edit: Here is the code I used in the mentioned rstriction above. I hope that helps:

Code: Select all

['Decision Location'] = S: ('static:HQ:Local: :') ;

['Decision Country'] = S:
IF(DB('cube',!dim1,!dim2,!dim3,!dim4,!dim5,'Decision Location') @= 'Local'
    ,('subset:ibie_country:Level0')
    ,('static: :')
   );

[tomok]

I analyzed it and it is somehow understandable because I’m changing the input data, but I thought always that TM1 is not looping twice over a point in cube if it was already processed in the rule.

Your problem is that what you are trying to accomplish is like a circular reference in Excel. You want Prio1 to be open only when Prio2 and Prio3 are empty, Prio2 to be open only when Prio1 and Prio3 are empty and Prio3 to be open when Prio1 and Prio2 are empty. The combination of those conditions results in a circular reference and that is not valid in a TM1 rule. I don't have any ideas for you except to recommend you abandon the idea.

[TomaszB]

Try using a picklist and put rules on the picklist. I've used this to limit country selections based on regions in the past,

Jim.

Thanks you very much Jim!!! That is the perfect solution for my. It is working very good. I spend so much time on it and had not this very simple and good solution.

Your problem is that what you are trying to accomplish is like a circular reference in Excel. You want Prio1 to be open only when Prio2 and Prio3 are empty, Prio2 to be open only when Prio1 and Prio3 are empty and Prio3 to be open when Prio1 and Prio2 are empty. The combination of those conditions results in a circular reference and that is not valid in a TM1 rule. I don't have any ideas for you except to recommend you abandon the idea.

Yes tomok you are right. The graying out could look good but it is probably not possible to build it. I will use Jim's solution.


Thank you all for the prompt answers.