Creating Rule File in Essbase

Creating Rule File

In this post will create rule files for our database to create members in our dimensions.We can create by right clicking the dimension and adding child.

So hold on tight...

Creating Rule file -

1. Right click on the Database. Go to Create -> Rules File

2. Go to File -> Open Data File -> Select File Location (File System/Essbase Server), select the data file.

3. Once Selected the Data file, Click OK. Data File will displayed in the screen.

4. To separate the data in the above field column. Select the Data source properties tab, which forth last in the property ribbon. A dialog box will appear and in that select the Delimiter, And Click OK

In the below picture it can be seen that in the field panel the data is separated by comma's and fields are divided into two parts.

5. Now Click on the Dimension Build Setting, A dialog box will appear in that click on Dimension Build Setting Tab. Now Select the Dimension, and Select the Build Method as required. And Click OK.

6. Now Select the Field Properties tab in the property ribbon. A Dialog box will be open. Now select the Dimension Build Properties then go to Dimension build -> Field Dimension - >Dimension . In the second line of the dialog Box you can find the field number (Field which is selected).Now Select the Dimension in which your currently working on.(Selected Dimension must be Highlighted beside Dimension option).Now Select Field Type in Field ->Type. And Click Next. (You must notice that Field number is changed to next number.). Now again select the dimension and field type. Note if dimension type is Generation or Level. In the last option of field type Number will be highlighting the Generation and Level number.

7. Now Click the Dimension Build Fields. Now you see the Field name has been changed to your respective field type. Then validate the rule file by clicking Validate option.

8. Then Save the rule file. After saving it you can notice that a new field is created under your database name as Rules Files. Under your rule files you find all your rules files.

Comments

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

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

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

Hyperion At Ease

Search This Blog