Building Dimension with Attribute dimension using Rule File

So here we going to build dimension with attribute dimension using rule file. You can create in the outline editor also directly.

Following are the steps -

1. Open the data source file in excel/notepad and review it.

2. In the above the data source file we are creating new dimension “Product” and Attribute dimension “Package Type”. Ignore the first row, since in the Essbase we are creating Product as dimension not family.

3.First we need to create the rule file. So open Essbase and navigate to your DB and right->create new rule file. The open the date file from File Tab.

4. Now navigate to data source property and select the delimiter and go to Header definition and Skip the first row.

5. Now click “OK” in Data Source properties. Now navigate to Dimension Build Properties. And Click Dimension Definition Tab. And since we have not created Product dimension and Package Type manually. We need to include them into rule file. So in the Dimension Definition Click the Rule file radio button and in the Dimension option beside click “Click here to edit” and add Product dimension.

6. Now right click the created Product dimension in the rule file Tab and Navigate to Edit member properties. And click the Attribute Dimension tab.

7.Now click “Click here to add” and write the name of your attribute “Package Type” for now. And in Type select the attribute type here we are selecting TEXT type. Click “OK”

8. Now Navigate to the Dimension Build Setting in Dimension build properties. And Select the Dimension here its “Product” and select the Build Method here its “Uses generation references”. And click “Ok”

9. Now Navigate to Field Properties->Dimension Build Properties. Now select the dimension and Field type as per the data file. But when it comes to attribute dimension “Package Type”. Select the Dimension Product and in Field type Navigate to Attribute Dimension Click the + button and then your attribute name will be displayed as a child of Attribute Dimension. Select the Attribute here its “Package Type”. Click “OK”. Now click the “Dimension Build Fields” button in the outline editor. Below will be your rule file generated after the process.

10. Save the rule file and Load Data.

11. Below is the result outline after the process.

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

Data Analytics – Introduction to Hyperion

A popular saying among industry professionals “ data is the new oil ” Implies that data, when harnessed (or, like oil, “refined”) properly, can provide high value. Contents - 1 . Data Analysis. 2. Data Analytics. 3. Business Intelligence. 4. Enterprise Performance Management (EPM). 5. Oracle Hyperion Introduction - History. 6. Oracle Hyperion - Essbase and Planning. - Planning , Budgeting , Forecasting. 7. Oracle Essbase Architecture. Data Analysis Data Analysis is separating out a whole into parts, study the parts individually and their relationships with one another. For example - if we have a whole data set and we are doing analysis on it means we pull sample data set from the whole data and then learn more about it and how it is related to the other samples. Data Analytics Data Analytics is the principle or logic that drives the analysis. For example - As mentioned in before exampl

Hyperion At Ease

Search This Blog