Evaluation OrderBy RahulS on Aug 21, 2011 Let’s start with something really simple... Few questions I have came across at least hundreds of times that why my Smart list is not populating in my data form even though the data type of the member is Smart List , why I am unable enter %, Date or Text in a data form. A simple solution, all of us know, move dimension to the Evaluation Order. But WHY??? Why it doesn’t work earlier but started working after we move Dimension in the evaluation order. Here is a bit of explanation on that, we all know that data is stored at an intersection of members from each dimension. For Example

This 1000 is not just stored for Sales and January, this is actually stored at the below combination(In this ex. there is no POV):
Sales->Jan->E11->P0001->FY09->Current->Version_1 = 1000; If you are going to change even a single member from the above combination then this will be pointing to a different value all together (There is a lot of talk about this, trust me !,  but someday later). But why I am talking about this? Am I out of my mind, not really ;) this is going to give a base to what I am going to say next, so as we noticed that data is actually stored at member combination and not for few members and we also know that every member has a data type associated with it. In our example lets assume that it is Currency for Sales, for ease of understanding Unspecified for rest of members  like Jan, E11, P0001, FY09, Current, Version_1. Now our data form is confused which data type should be granted to the combination, here comes the Data Type Evaluation Order in picture ladies and gentleman. In Evaluation Order we try to tell our planning which Dimension's data type to be considered first. Lets take more ex: Sales%->Jan->E11->P0001->FY09->Current->Version_1= 10%; (Of-course type %) AccountType- >Jan->E11->P0001->FY09->Current->Version_1= ClassA; (From Smart List) Now the data type of Sales% is percentage and of Jan is say Currency and rest all are unspecified. Now the intersection of Sales% and Jan (i.e Percentage and Currency data type respectively) must be resolved, this is  based on how you define the order set and the data type Evaluation Order  is the defined order. The dimension which is first in the order takes the  precedence over the next. In nut shell "We set the Evaluation Order for each Plan Type when we have multiple data types for a combination".  If you will try to save below without moving Accounts to Evaluation Order,   
The moment you try to hit save(Lost focus from the current cell) you will get below error:    
Lets assume  If you have a Smart List attached to AccountType but its not visible now:     
Now if you look at the Evaluation Order: 
  
Lets set the Evaluation Order now: 
 
Here you go:    I guess that is it..!! Cheers...!!!
Rahul S.
https://www.facebook.com/HyperionPlanning 

Comments

Post a Comment

Popular posts from this blog

Multiple Navigation Flows are Active

Image
We have witnessed an issue where application migration or sometimes service restart in PBCS/EPBCS activates multiple navigation flows.  If multiple navigation flows are active you wont be able make changes in any of them, because in order to make change in navigation flow you have to make it inactive. Typically you may end up in following situation:  Solution is pretty simple: 1. Create a copy of any of the existing navigation flow:  2. Give it any desired name:  3. Now, you will see one additional navigation flow, with inactive status: 4.  Make it active: 5.  At this point of time you will have one active navigation flow and two inactive  6. Select the additional navigation flow you have created and delete it  7. Now you are back in business: Rahul S.
Read more

The Member Does Not Exists For The Specified Cube

Image
The member "" does not exist for the specified cube or you do not have access to it. Issue:  If you are running into a issue, where for a RTP member selection is throwing an error for a missing member, this regardless of the member you have selected in RTP or regardless of rule. You may be able to execute the rule from Calc Manager and not from Planning. Reason: You may run into this issue if: 1. You have added members in Planning and have not refreshed the cube 2. For the default value of a RTP in calc member you have a member which is not valid any more for planning application 3. For the default value of a RTP in calc member you have a member which is not valid any more for a plan type Solution: 1. Refresh cube 2. Update Default value of RTP which is causing issue to member which exists 3. Deploy the rule Rahul S.
Read more

"Smart View handled an unknown exception thrown by Microsoft Office" Error on Vista, Windows 7, Windows 2008

My MS-Office Components are Crashing After Installing Smart View on Vista, Windows 7, Windows 2008! This is one more one pretty common issue,   "Smart View handled an unknown exception thrown by Microsoft Office."   This is actually a known issue in version 11.1.2.1. If you look at the read me of Smart View you will find bug# 11696583 "On Vista, Windows 2008, and Windows 7 operating systems, Excel may terminate abruptly upon launching after you install Smart View. Workaround: Turn off “User Access Control” in User Accounts, available from the Control Panel." Here is the link to read me: http://download.oracle.com/docs/cd/E17236_01/epm.1112/readme/sv_1112100_readme.html When the User Access Controls are on Smart View faces problem in registering, when you set it off Smart View register itself like a charm. To have more information on UAC: http://technet.microsoft.com/en-us/library/cc709691(WS.10).aspx Now, when y...
Read more