Hyperion Log Analysis Utility Blog

A BETTER WAY OF TROUBLE SHOOTING ESSBASE LOGS

The Goal of this blog is to give some useful information regarding Essbase logs produced through EPM system. Identifying the correct log file and looking into the error it’s really a critical task and time-consuming as well. Considering this Oracle has released the log analysis utility with 11.1.23 version.

This utility automates log file & you do not need to manually locate and scan EPM System log files to identify issues.

Log Analysis provides a couple of log parameters and you can find this utility under below path

E:\Oracle\Middleware\user_projects\epmsystem1\bin

Once running this utility, it will create a summary report in HTML format for all the log files under below folder

E:\Oracle\Middleware\user_projects\epmsystem1\diagnostic\reports

There are different logging levels and different parameters available with log files

• Trace-Most intensive logging
• Error-Should be investigated
• Warning-Might be an issue
• Notification-Routine Messages

loganalysis.bat -system

Message Type -m [ERROR | INCIDENT_ERROR |WARNING | NOTIFICATION | TRACE]]

Time range [-t [<TIME FROM > <TIME TO] -tday <days> - hour <hours>

·         You may also see error occurred in last 2 hours or 60 minutes

o   Time in minutes -tmin <minutes>

o   Example {-tim 45}

·         You may also investigate Errors that occurred today, so we need to pass -tday 1

·         A String (-s): If you also like to figure out errors on certain string, then you need to pass -s “out of memory”.

·         Example: loganalysis -s "Failed to connect to DB" -o DB Connection Errors" creates a report           with the title DB Connection Errors.html.

The command here I used:

D:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\essbase and run a report for any ERROR and INCIDENT_ERROR types generated within the last day.

Sample Report Output

The tables in this section provide information about ERROR & INCIDENT_ERROR log

Running a similar report against the Essbase server logs highlights issues with the database connection.

loganalysis.bat -system -tday 1 -d D:\Oracle\Middleware\user_projects\domains\EPMSystem\servers\EPMServer0\logs

The tables in this section provide information about ERROR log 

The report also includes all the logs files which have been processed.

The utility has functionality to allow searching for a string using the –s parameter which I gave a quick test to search for the following “Out of memory” error:

Unfortunately, the utility did not pick up the error as it does not seem to search the supplemental detail in the log entry.

loganalysis.bat -functional -s "Application [PLANS] started"

 -d D:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\essbase 

The tables in this section provide information about NOTIFICATION log

Load data into OACS by the rule files present in on-premises.

Introduction

This Blog will walk through the steps to load data into Oracle Analytics Cloud Service (OACS) using the rule files from on premise.

Load data into OACS:

There are different ways for loading data into the (OACS) cloud

       1.You can create rules files in the cloud service (OACS) rules editor.

       2.Data can be loaded into the cloud using the rules files of on-premise Essbase version of (11.1.24).

Note: Here we used the rule files which is present in on-premise (11.1.24) version of Essbase for loading data. Using Option 2 from above.

For more detailed instructions on how to get rules files from on premise follow the below steps:

1. To create an Essbase Rules Files, you have the following options  
2. Expand the Application >>
3. Expand the Database >>
4. Right Click on ‘Rules Files’ >>
5. Select ‘Create Rules Files’ or you can use the existing rules files it just depends on your data and what you are trying to load.

Loading data into XmlDb:

• Select the XmlDb and click on Inspect option at the top left corner of home page. As shown in the Fig1.1

Fig:1.1

• Select the Files tab and click on the Upload-Files Button as you need to upload the data files and rules files. As Shown in the fig:2.2
• File Name pattern for uploading these files must have less than 30 characters

Fig:2.2

• The rules file should have ‘*.rul’ appended & once the file upload is complete Click -> Close.Fig3.3

Fig:3.3

• The data load file should be ‘*.txt’ appended & once the file upload is complete Click-> Close  Fig:4.4

Fig4.4

• Return to the Home Page & Click ->Jobs.
• Select the New job and choose Load Data as the job type. For reference Fig 5.5

Fig:5.5

• Select the required fields i.e. Application, Database, Script & Data File fields
• Click ->OK.. Job will start Execute & Status of the job is displayed in next screen shot Fig:6.6

Fig:6.6

• The status of the job is “In-Progress” and Refresh the page. Look into the Fig 7.7

Fig:7.7

• Once the jobs status turned into success state, it means the records loaded successfully. Fig:8.8 

Fig:8.8

• Return to the Home page, Choose Analyze Data option in the bottom left corner of home page to have a quick look into data which loaded from the above step. Fig9.9

Fig9.9

• You can see the Adhoc analysis it same as the SmartView data in the fields. Fig 10

Fig:10

Basic Introduction to Anaplan

Anaplan

I have started looking at Anaplan. As I'm familiar with Hyperion Planning how the planning and budgeting works in Hyperion. Who ever wants to know how Anaplan works in place of Hyperion Planning in real time.

Below are the some of concepts of Anaplan I want to share with you all. It will be continued in further posts. 

• What is Anaplan,
• Features of Anaplan, Structure of Anaplan,
• How to create a Model in Anaplan?
• How to insert a new version? 
• How to create a list?
• How to create a module.What are Line items.

Anaplan is a name of a company that created this web-based enterprise platform. Large and fast-growing organizations use Anaplan’s cloud platform in business function to make better plans, decisions and drive faster to more effective planning processes. The name Anaplan is known for the “analysis” and “planning” it has In Memory Database and Calculation engine which are further called as the “Hyper Block”.

Fig 1:Anaplan Features

• Cloud Based: It allows users to access software applications which are shared In Memory.
• In Memory processing: To meet Business needs Anaplan maintains In Memory Database.
• App Hub: Common use cases are available in the hub to retrieve them whenever needed i.e. for future use.
• Data Integration: Import and Export of data is performed with different types of data sources.
• Multi-dimensional Planning: It can build any number of models irrespective of any level of granularity.

Anaplan Structure

Fig 2: Anaplan Structure

Workspace:All the models will be available respective to the company.

Model:Enables business users to build multi-dimensional models.

1. Models can be built to any level of granukarity with any number of dimensions
2. A model is a collection of lists,modules and dashboard that are all used for a area of business planning .

How to create a Model in Anaplan?

• Login into your Anaplan account.
• In the upper right corner of the main screen, click the drop-down right of your name and now select the manage models. Below is the following screenshot.

• Click on Manage Models

• Click New

• In the new model dialog box, give the model name for example (MTSales). Next in the template drop down list ensure that it is empty model is selected
• Click create model. Once model is created model name will be displayed Upper left corner

Note: After creating a model we need to set the Time for the model. Below is process how to set Time.

Time: 

In Anaplan, Time is one of the built-in Dimension Where you can structure the data for the organization.

To set Time dimension properties in a model below are steps

• Select the calendar type
• Fiscal year start month we gave here is Jan
• Current Fiscal Year: How many years we want to have the model can be given according to the requirement
• Number of past and future years can be given.
• Current period we gave is mar19
• Ensure that how you want to see the data and click on the radio buttons as required, quarter totals and year to date summary are tick marked.
• Click on Apply

Versions:

Once model get created then two default versions i.e Actual and forecast will be updated but according to the requirements. Also we can create new version members inserted or rename default members to required name.

• Switchover:It handles current period actuals, forecast & etc.
• We can write the formula as well for any Version.

How to insert a new version? 

• When we want to insert a new version, click on the insert and in the dialogue box give the version name for example version1.
• Click ok.

List: 

A List is a group of like items

• Lists are important in Anaplan as they define structure and content of a model

How to Create List?

• In the model settings tab ->general Lists

• Click on the organization, add the new items: example shown in the above screen shot (North, South, East, and West)
• Click on Ok.

• The above screen shot shows how the children looks in Organization after insterting them.

Modules: 

These are the individual components where user wants to enter the data.

How to Create a Module? 

•  In the model settings tab ->Click modules

• Dialogue box with empty module name

• For example, here we gave new module name Sales Analysis.
• Dimensions can be drag & drop in pages ,columns according to how you want to visualize the data.
• Click Ok

Line items: 

Line items belong to the module which are in rows.

• Example you can create line item1,line item2 by manually or you can copy and paste from the text file

• Values can be entered into the cells.

The information provided above is my understanding on the tool with less details. My Next post will explain other topics which are not covered here.

By:

Pranaya Panauganti

Mouri Tech Pvt Ltd.