Wednesday, November 2, 2011

New Hyperion Planning book

Guys,
good afternoon.
I recently came across book on Hyperion Planning version 11 which is of great quality.
I know author of this book ,Sandeep Reddy , via oracle forums and had good e mail discussions with him in th past. All his posts in oracle forums were very valuable and technical in nature.

I read his recent book and found it very informative and must have if you are working on Hyperion or if you want to plung into Hyperion Planning world.

you can find his book in the following link

http://www.packtpub.com/getting-started-with-oracle-hyperion-planning-11/book

Happy reading :-)

please find my review below:







I feel privileged to review verynice work by Sandeep Reddy. I knew Sandeep since past 4 years when he wasraising star in our field. He always extended his helping hand for starters inthe Hyperion technologies via blogs and as frequent responder for querieson various online forums. His latest effort Getting Started with OracleHyperion Planning 11 is indeed a great work. When I was reading hisbook I felt that he was holding my hand in Hyperion jungle and magicallyde-mystifying all secrets in software along with simple and easy to understandreal time examples. I had seen previous works by others on this software.Sandeep stands apart from them including discussions on architecture part ofHyperion planning including installation and that to in a new version (11).This is very comprehensive work including all concepts from installation tocommon mistakes done by users and how to avoid them. This book is one stop shopfor all who want to start their careers in Hyperion planning or who are inplanning field and want to learn more. "

Wednesday, October 19, 2011

Common Essbase Admin Tasks

Good evenning Folks.
Today we discuss about common admin tasks we encounter during typical work day of an essbase administrator.
  • Every morning I check status of my Nightly cycle. Nighty cycle is an automation process which builds my hierarchy, clears data, loads data and runs all aggregation and different business logic calc scripts and completes backup.
  • Nigthly cycle is my full load. However I also do incremental data load and check the status of the incremental load and check to see if there are any errors or rejects.
  • Database Health: Check to see the fragmentation ratio and if it is more than 50 % framented and calc scripts were taking awfull lot of time, then I will initiate dense restructure (which removes fragmentation) that night. Generally dense restructures were not done during week days. Only exceptional cases are entertained.
  • As part of nightly cycle my main cube also feeds data to reporting cube. I use dataexport command to export and outline extractor combined with HAL (Hyperion Application Link) to export and format metadata.
  • We schedule all the jobs using windows scheduler and automation was done using windows batch files.
  • If the calcs are running slow, we check how much database was fragmented, size data cache, outline order etc.
  • If Data cache is full, we need to increase the size of data cache. After increasing the size, database needs to be started for it to take effect.
  • Stopping and starting database in the nightly cycle is also good practice. It removes cache build up.
  • If the database is corrupt or atleast we have a suspicion that database is corrupt we use VALIDATE command in ESSCMD.
  • If the database is corrupt we can restore database from backup (discussed in backup post).
  • Sometimes essbase service won't start eventhough we start it manually. This is because of any idle process running before essbase went down. Those orphanned (Idle) process won't allow essbase service to start. I use windows process explorer (tool from Microsoft, just like task manager) to kill those idle processes and restart essbase.

Friday, August 12, 2011

Exporting Security out of Hyperion Planning application

we can extract security information out planning application using the following script on Planning SQL tables

SELECT A.OBJECT_ID AS GROUP_ID,
A.OBJECT_NAME AS GROUP_NAME,
D.USER_ID,
E.OBJECT_NAME AS USER_NAME,
D.ROLE,
D.SYNC_PSWD,
FROM
HSP_OBJECT A,
HSP_OBJECT_TYPE B,
HSP_USERSINGROUP C,
HSP_USERS D,
HSP_OBJECT E

Where

A.OBJECT_TYPE=B.OBJECT_TYPE
AND A.OBJECT_ID=C.GROUP_ID
AND C.USER_ID=D.USER_ID
AND D.USER_ID=E.OBJECT_id
AND B.OBJECT_TYPE ='6'
ORDER BY A.OBJECT_ID