How to add validation error message for users?

Post Reply
amit_hhh
Posts: 6
Joined: Wed Jan 18, 2017 3:27 pm
OLAP Product: Cognos TM1
Version: 10.2.2
Excel Version: Excel2010

How to add validation error message for users?

Post by amit_hhh » 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.

lotsaram
MVP
Posts: 3041
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TM1, CX
Version: TM1 10.2.2 PA 2.0x
Excel Version: 2010 2013 365
Location: Switzerland

Re: How to add validation error message for users?

Post by lotsaram » Sun Mar 18, 2018 7:27 am

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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

declanr
MVP
Posts: 1561
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: How to add validation error message for users?

Post by declanr » Sun Mar 18, 2018 4:12 pm

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.

Wim Gielis
MVP
Posts: 1645
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: How to add validation error message for users?

Post by Wim Gielis » Tue Mar 20, 2018 5:20 pm

Wrong subforum, this is not an Enhancement.
Can a moderator move this thread please ?
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Post Reply