Skip to main content

Posts

Showing posts from October, 2018

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