Displaying dynamic attributes in an Application Studio report

The topic "Implementing dynamic attributes" gives an example of implementing dynamic attributes in a custom application. Based on that example, this topic describes how to display dynamic attributes in an Application Studio report.

Steps 1 to 11 use Self-Service to populate the dynamic attributes, Product Manager and Market Entry, with values. If you do not have access to Self-Service, you can populate the dynamic attributes through the Application Studio report. To do this, ensure that the hyperblock cells that display the attributes are writable.

  1. Sign in to Self-Service and select Dashboards > Self-Service > Data Configuration.
  2. In the Cube Configuration widget, make the ATC_Product cube writable.
  3. Select Dashboards > Self-Serviceand select Explore Your Data. Select ATC_Product as the data source.
  4. Enable the filter dimensions at the top of the analysis.
  5. In the ad-hoc analysis, put the Product2 dimension on the rows axis and the ATD_Product dimension on the column axis.
  6. On the toolbar, click the Properties icon and select Enable Write-Back.
  7. On the toolbar, click the Suppression Options icon and clear the Zero Suppression on Rows and Columns check box.
    The analysis displays a product on the rows and an attribute on the columns.
  8. Click the menu icon on the Product2 dimension and select Select Elements. Select all three products and click OK.
  9. Click the menu icon on the ATD_Product dimension and select Select Elements. Select both attribute elements and click OK.
  10. Perform these steps to specify sample market entry values.
    1. From the Period filter dimension, select All Years.
      This is the element that you designated as the non-applicable element of the Period dimension.
    2. Select a region.
      Do not select the All Regions element.
    3. Specify sample values in the Market Entry column only.
      For example, specify Winter, Spring, Summer, and Fall.
      Note: If the cells are not writable, ensure that you enabled writeback at Step 6. If the values that you specify are not saved, open the dimension view of the ATD_Product table and ensure that the data types of the Product Manager and Market Entry elements are both S (String). If you change the data types, re-run the mapping for the ATD_Product table.
    4. Select a different region and specify different sample values in the Market Entry column.
  11. Perform these steps to specify sample product manager values.
    1. Select a period.
    2. Select a region.
    3. Specify sample values in the Product Manager column only.
    4. Select a different period and specify further sample values for the product manager.
    5. Select a different region and specify further sample values for the product manager.
  12. In Application Studio, sign in to the Samples application and create a report.
  13. Add a combo box to cell C5, for example, and drag the Region dimension of the ANALYSIS cube onto it. Name the combo box Region.
  14. Add a combo box to cell C8, for example, and drag the Period dimension of the ANALYSIS cube onto it. Name the combo box Period.
  15. Create a slice on the Product2 cube, with these values:
    Section Value
    Data Area Region and Period. For each, click Edit Slice in the Selection column and click the Variables tab in the Slice Designer. Expand ListViews and select Region and Period respectively.
    Rows Product2. Click the Edit Axis icon and open the Attributes pane. Select the Market Entry and Product Manager check boxes.
    Columns Version
  16. Drag the slice to C16, for example.
  17. Change the context of the report by selecting different regions and periods.
    The values of the product manager attribute change by region and time. The values of the market entry attribute are those specified against the All Years element and change only by region.