Showing posts with label Hyperion Planning. Show all posts
Showing posts with label Hyperion Planning. Show all posts

Tuesday, 31 March 2015

How to push data between applications from Planning

Map Reporting Application will let you to push data from source application to consolidation application.

Here I have considered BSO as base application and ASO as Consolidation or Reporting application.

Login to Planning as an administrator and navigate to Map Reporting Application




Click on Add button to create new mapping.



Choose source application and target / consolidation application 


 Click on Finish to save object.
Click push data button highlighted below to let data to go target application


you can clear target application data and push fresh data or you can simply push data.


Data at source and target applications before pushing data.

Data at source and target applications after pushing data.


Thursday, 12 March 2015

Differences between Essbase calculation scripts and Business Rules

Calculation scripts

Script is either specific to database or application in Essbase.
Use substitution variables.
Scripts can be executed from Excel Add In / Smart View.

Business Rules

Easier way of implementing business logic either using script or graphical method.
Use Substitution variables.
Use run time prompts to narrow down calculation scope.
Cannot access from Excel Add In / Smart View.
Rule can be defined as global so every application can make use of it.

Happy Learning :)

Tuesday, 24 February 2015

ODI can remove the planning members as well?

ODI could replicate the hierarchy of DRM in Planning but can’t remove the members which are not there in DRM but present in planning.
One day I had to delete thousands of shared members in Planning, the options available for me to address this problem are:
Use “Formdef utility” to take exports of webforms:
Export all webforms of that application and delete the complete hierarchy and rebuilt once again and again import the webforms (Import works only when you have all members in webforms present in hierarchy)
Use ODI to remove the shared members:
This process is really eye cache and very interesting, it turned my views on ODI diagonally; I would like to share how I did using this blog.
Step 1: Create one text file with the below syntax:
Make sure that storage property should mention otherwise it will delete the store occurrence of that member.

                            

Step 2: Create an interface in ODI and map as below

 
Source
Target
Parent
Parent
Child
Dimension name
Storage
Data Storage
Operation
Operation

                              

Step 3: Execute the interface, and check the Execution status in Operator. 

Happy Learning :)

Error while starting Essbase server

I have one well structured and ordered batch script to start all services related to Hyperion one after another in sequence, it is functioning absolutely fine but all of sudden when I was trying to start the batch it is prompting the below message and I left with no clue how to address this except restoring the image once again.

                         

I realized probably this is one of the mischievous activities of the temporary files, but honestly don't know where they reside, I have to say thanks to my friend(Bhargav) he directed me to find them and I deleted, the below images shows the files to be deleted and these are available in the below path.




C:\Hyperion\products\Foundation\openLDAP\var\openldap-data

now it is starting successfully as usual after restarting the services

                             

I think this very blunt way and there would be polished solution for it, yes of course we have that in products\Foundation\server\scripts path.



Happy learning :)