Page 1 of 1

How to add validation error message for users?

Posted: Sun Mar 18, 2018 2:57 am
by amit_hhh
Hello,
I have 2 dimensions which are used in different cubes to build model, let's name them A & B. The elements of these dimensions are selected through TM1 web when users are doing planning. I have to implement a logic in such a way that while selecting the elements, one element of dimension B can be selected only for one element of dimension A. It can not correspond to multiple elements of dimension A, however one element of dimension A can correspond to multiple elements of dimension B. It's like one to many relationship. How can I implement this logic. Currently there is no look up cube in the system where such mapping exists, and I do not want to add any more cube in the system. Please suggest.

Re: How to add validation error message for users?

Posted: Sun Mar 18, 2018 7:27 am
by lotsaram
amit_hhh wrote: Sun Mar 18, 2018 2:57 am Hello,
I have 2 dimensions which are used in different cubes to build model, let's name them A & B. The elements of these dimensions are selected through TM1 web when users are doing planning. I have to implement a logic in such a way that while selecting the elements, one element of dimension B can be selected only for one element of dimension A. It can not correspond to multiple elements of dimension A, however one element of dimension A can correspond to multiple elements of dimension B. It's like one to many relationship. How can I implement this logic. Currently there is no look up cube in the system where such mapping exists, and I do not want to add any more cube in the system. Please suggest.
Then you are deliberately making life difficult for yourself for no good reason. The best way to handle this requirement is to have a mapping cube holding the valid intersections of A & B.

Re: How to add validation error message for users?

Posted: Sun Mar 18, 2018 4:12 pm
by declanr
If the mapping will never change you can put an attribute on dimension B saying which element it maps to from A (this is really a mapping dive anyway) and/or you can have consolidations of element A in dim b but without really understanding the relationship of what these dims are it’s hard to say whether that is a good idea.
If the mapping will change between versions and/or periods then you will need a mapping cube.

Re: How to add validation error message for users?

Posted: Tue Mar 20, 2018 5:20 pm
by Wim Gielis
Wrong subforum, this is not an Enhancement.
Can a moderator move this thread please ?