- His performance
- His direct reportees performance
- His Indirect reportees performance.
So when we developed the reports we selected the entire tree structure of Organization (dimension) hierarchy in pages. However client was not happy with each user navigating through the entire hierarchy, instead they wanted to show the current user’s report only when logs in.
- Only his emp id in the page drop down for his performance report
- Only his direct reportees id in the page drop down for his direct reportees performance report
- Only his in-direct reportees id in the page drop down for his in-direct reportees performance report
So now the challenge was to incorporate the idea in WebAnalysis. If you have worked on WebAnalysis, there is an option to create Personal Variables and it differs for each user.
So my task was to create PVs for 2500 users 🙂 and while creating the report select the PVs as member selection.
<?xml version=”1.0″ encoding=”UTF-8″?>
<AnalyzerAdmin>
<ModifyUsers>
<User LoginID=”1012″>
<AddPersonalVariable Name=”Me” Database=”/CERA/Databases/CERA.PLAN” Dimension=”Organisation”>
<Member Name=”EMP_1012″ SelectionMode=”MEMBER”/>
</AddPersonalVariable>
<AddPersonalVariable Name=”InDirectReportees” Database=”/CERA/Databases/CERA.PLAN” Dimension=”Organisation”>
<Member Name=”EMP_1012″ SelectionMode=”DESCENDANT”/>
</AddPersonalVariable>
<AddPersonalVariable Name=”DirectReportees” Database=”/CERA/Databases/CERA.PLAN” Dimension=”Organisation”>
<Member Name=”EMP_1012″ SelectionMode=”CHILDREN”/>
</AddPersonalVariable>
</User>
</ModifyUsers>
</AnalyzerAdmin>
You will need two files to run this xml file
- ARUUtil.bat
- ARUImport.properties
and they are located under
- %HYPERION_HOME%productsbiplusbin
- %HYPERION_HOME%productsbipluscommonconfig