Whether you build the attribute dimension and associate the attribute members with the members of the base dimension in one step or in separate steps, define the fields as described in this section.

Every record of the source data must include at least two columns: one for the member of the base dimension and one for the attribute value of the base dimension member. In the same source data record, you can include additional columns for other attributes that you want to associate with the member of the base dimension. You must position the base member fields before the corresponding attribute member fields.

Example

You can have Essbase build members of base dimensions and attribute dimensions, and make attribute associations, in the same dimension build job.

Assume you want to perform a dimension build that adds to Sample Basic new Product members 500-10 and 500-20, as children of 500.

In the same dimension build, you want to add a new numeric attribute member, 64, to the Ounces attribute dimension.

500	500-10	64	True
500	500-20	64	False

After you run the dimension build job, it builds members and associates attributes as shown in the outline below. Member 64 is a new member of the Ounces attribute dimension. Members 500, 500-10, and 500-20 are new members of the base dimension, Product, and are associated with member 64.

To recreate this example,

1. Import/build the Sample Basic cube, using the application workbook available from the gallery in the file catalog on the Essbase Server.

2. Create a tab-delimited data file like the following, name it attrprod.txt, and upload it to the Sample Basic cube directory.

   500	500-10	64	True
   500	500-20	64	False

3. On the Applications page, open the application and then open the database (cube).

4. Select the Scripts tab, and then click Rules.

   
   
   
   
   

5. Click Create and choose Dimension Build (Regular).

   
   
   
   
   

6. In the New Rule dialog,

   1. Enter a rule name; for example, attrprod.

   2. For Source Type select File, click Catalog and navigate to attrprod.txt.

      When you click Catalog, the file is expected to be located in the cube directory on the Essbase Server by default, so you must have already uploaded it using the Files section of the Essbase web interface. If the file is on your client machine, click File Browser to locate the file.

   3. Leave the Header Record Number and Dimension Build Record Number fields as 0. Header records are not useful for dimension builds.

   4. Change the Delimiter value from Comma to Tab.

   5. Click Proceed.

   6. The dimension build rule opens with undefined fields, and preview data (from the text file) populating the grid below the fields.
      
      

7. As this is a new rule, there are no dimensions associated yet.

   1. Click Dimensions.
      
      
      
      
   2. Type in or search for a dimension name; for example, Products, and click Add.
      
      
      
      

8. Now you need to define the build method and check other dimension build operational instructions. Click Product to edit the properties.
   
   

9. Ensure Build Method is Generation. Leave the Member Name field below it blank.
   
   

10. Click Advanced, and select Create Attributes.
    
    
    
    
11. Click OK.
12. In the attrprod rule:
    1. In Field 1, select Product for the Dimension, and Generation for the Type. Increment the Generation field to 2.
    2. In Field 2, select Product for the Dimension, and Generation for the Type. Increment the Generation field to 3.
    3. In Field 3, select Product for the dimension, and Attribute Dimension for the Type. Below it, select Ounces.

       Field 3 contains members of the Ounces attribute dimension associated with the Product dimension. Because this field immediately follows the data field defined as the generation 3 member of the base dimension Product, Essbase associates the attribute member 64 with the 500-10 and 500-20 members.

    4. In Field 4, select Product for the dimension, and Attribute Dimension for the Type. Below it, select Caffeinated.

       Field 4 shows how to associate an attribute from an additional single-level attribute dimension. Because the base dimension is already specified, you need only to define an additional field for each attribute that you want to associate with the member of the base dimension.

       
       
       
       
       

    Note:

    When you are working with numeric ranges, you may need to build attribute dimensions and perform associations in separate steps. See Numeric Range Attributes.

13. Verify the rule, then save and close. If there are any errors, see Requirements for Valid Dimension Build Rule Files.

14. Run the dimension build job.

15. Open the outline. Before checking results of your dimension build, adjust the displayed columns to show attribute associations. On the outline toolbar, select the Display selected columns in the table icon.
    
    
    
    
16. Scroll down. For property name Attributes, click Show in name. Click Apply and Close.
17. Expand the Product dimension, and then expand the member, 500.

    After you run the dimension build job, it builds members and associates attributes as shown in the outline below. Member 64 is a new member of the Ounces attribute dimension. Members 500, 500-10, and 500-20 are new members of the base dimension, Product, and are associated with member 64.

    
    
    
    
    

Remove Attribute Associations

To remove attribute associations, edit the dimension build rule as follows:

• In the General tab of the Field Properties dialog box, select Remove if null for the attribute field. (This option is ignored if Allow association changes is not selected.)

• Leave the field empty or NULL in the source data.