Rules Issues when moving a 9.5.2 model to 10.2.2

Post Reply
holger_b
Posts: 131
Joined: Tue May 17, 2011 10:04 am
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: 2016
Location: Freiburg, Germany

Rules Issues when moving a 9.5.2 model to 10.2.2

Post by holger_b »

When starting a 9.5.2 model in 10.2.2, we are experiencing problems with rules based security assignments (elements security) - they simply do not have any effect. Can anyone help? What do we miss? And, yes, we did a security refresh.

Regards
Holger
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Rules Issues when moving a 9.5.2 model to 10.2.2

Post by mvaspal »

Hi
I have not seen such issues yet.
Do you have Contributor cubes? I also reckon lower/upper case counts in case of element security rules, i.e. it has to be READ and not read.
But otherwise I have never had problems with upgrading to 10.2.2 and element security
User avatar
mattgoff
MVP
Posts: 518
Joined: Fri May 16, 2008 1:37 pm
OLAP Product: TM1
Version: 10.2.2.6
Excel Version: O365
Location: Florida, USA

Re: Rules Issues when moving a 9.5.2 model to 10.2.2

Post by mattgoff »

When I first started up our 9.5.1 model in 10.2.2 FP1 I had the same problem. Turns out they tightened up some of the rule syntax and previously valid rules were now invalid. There were no warnings until I opened up the affected rule file. I'd start there-- even if you're not getting an explicit error, treat your investigation like any other rule debug.

Matt
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
holger_b
Posts: 131
Joined: Tue May 17, 2011 10:04 am
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: 2016
Location: Freiburg, Germany

Re: Rules Issues when moving a 9.5.2 model to 10.2.2

Post by holger_b »

Thank you, but none of your suggestions helped in our case. We will create a ticket and post here what the outcome is.

Regards
Holger
holger_b
Posts: 131
Joined: Tue May 17, 2011 10:04 am
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: 2016
Location: Freiburg, Germany

Re: Rules Issues when moving a 9.5.2 model to 10.2.2

Post by holger_b »

Solution: The problem only occured with PrivilegeGenerationOptimization=T. When we set it to F (which is the default), the problem disappeared.
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: Rules Issues when moving a 9.5.2 model to 10.2.2

Post by mvaspal »

Hi
Did you use feeders as described here, and you still experienced the issue?
http://www-01.ibm.com/support/knowledge ... timization
holger_b
Posts: 131
Joined: Tue May 17, 2011 10:04 am
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: 2016
Location: Freiburg, Germany

Re: Rules Issues when moving a 9.5.2 model to 10.2.2

Post by holger_b »

We also found this article. But, since element security is entirely rules based in this case, there were no cells to feed from, so we decided to switch the parameter off.
Post Reply