Skip to main content

Hyperion Essbase - Connection

Essbase - Connection

In the post will see how to connect Hyperion Essbase from your system.
Here Essbase is already installed in the server. we just connecting to it and creating a application in it.
So hold on tight... 
Opening Hyperion Essbase -
1. Open this URL in  http://IP Address : Port number/easconsole/console.html in any browser.

 2. Click launch button in the web browser. An easconsole.jnlp file will be downloaded. (Keep it"It          won't harm the computer").And Open it.

3. Once you open “easconsole.jnlp” file. An EAS java application will be opened with an "Run and       Cancel Button". Click Run.

 4. Once you clicked "Run". EAS CONSOLE will be opened and will ask you to enter the          username and password.

5. Once you entered valid username and password. Hyperion Essbase Application is ready to     use.

Creating Application in Essbase Server -
1.       Go to the Essbase Servers -> Essbase Cluster -> Application option by clicking the + button. which is located in the left side of the Essbase panel. 

2. Right click on the Application. Go to Create Application -> Using Aggregate Storage/Using Block Storage.
3. Using Block Storage - After clicking the Using Block Storage. A Create Application Dialog box will be opened. Select the Essbase Server, Give the Application name. The Application name is restricted to 8 characters only. But if you use Unicode Mode, you can extend the application name characters. Unicode is used for foreign country names. Click OK to create a application. If it is created, it will be displayed in the Essbase applications panel.
    


Creating Database in your Application -

·         Right click on your Application in the Essbase panel. Go to Create Database. A Create Database dialog box will be displayed in your screen. Select your Essbase Server name. Select your Application name. Name your Database (8 chars only).You can give your application name also.(Normal/Currency). If your database has duplicate members, then you need to all Essbase to create them. Then you have to click the checkbox given below the Database Name Textbox. Click OK, Your Database will be created under your application name in the Essbase panel.

Done Volla! You created your Essbase application successfully. In the coming posts will discuss about creating database, dimension, rule file etc.. 

Comments

Post a Comment

Popular posts from this blog

Business Intelligence

Business Intelligence You must be wondering what is the above imageor title is about. Yeah, it is about the first project I get into. Where the client was using all the above process to generate a report, which will help them to manage their financial planning. So now you must be having an idea that what this blog is about i.e; using Business Intelligence, EPM, ETL and ERP how the financial decisions are taken. Here the client uses the different processes to achieve their goals. So let’s dive in and try to understand the process.  Note - In this blog, you will get an overview of each process and its high-level architecture. Enterprise Resource Planning -  Firstly let's start with  Enterprise resource planning (ERP),  most of the companies store data through ERP. It is a process whereby a company manages and integrates the important parts of its business. ERP system stores both operational and non – operational data. An ERP management information system int
8 comments
Read more

Smart View connection

Smart View connection Before connecting Oracle smart view with essbase. You need to download it from oracle website and install it. installation is easy process..next next next ...finish... Below is the link for downloading smart view. https://www.oracle.com/technetwork/middleware/epm/downloads/smart-view-1112x-2412371.html Smart-view Connection – Download Excel and Oracle Smart-view from the web. Open MS Excel – Go to File -> Options Go to Add-in                    Go to Mange and select COMM Add-ins and Click Go Select Oracle Smart View for office and Click OK After the above step you see a SMARTVIEW option in the last of Excel ribbon. Click it!    Now to connect the smart-view with the Essbase server. Click the Panel option. You see an Smart-view panel on the right side. Click the Shared Connections.    After clicking Shared Connections option on the Smart-View P
Post a Comment
Read more