Exploring your data

You can explore your data using an Ad-hoc analysis. You need to specify which dimensions, hierarchies, and elements will form the view of the data. While the data source selection shows only which dimension or hierarchy will be used as filter and which will be on the axes, the Ad-hoc analysis shows actual values and thus allows slicing, dicing, and exploring the data.

The Ad-hoc analysis offers basic statistical functions, such as sum, minimum, maximum, average, absolute, and relative dispersion of range on rows and columns.

To explore your data using the Ad-hoc analysis:

  1. Select Dashboards > Home.
  2. Click on the Explore Your Data widget.
  3. Specify the data source:
    Database
    Specifies the database alias.
    Model
    Specifies the data model.
  4. Define filters and axes.
    1. For each hierarchy, you can filter or select elements.
    2. To define access, drag and drop a selected hierarchy on the row or column axes.
      You can also select if to suppress zero or empty values using the options icon. You can switch the axes, remove the hierarchies and select the attributes that you want to display.
  5. Browse your data
    You can adjust the rows and column, switch the axes, add tuple values, and select the filters and attributes that you want to display.
  6. In the Widget Options you can specify the title and description of your widget.
    Note: The default title and description is generated and updated automatically, but if you specify the title or description they will not be updated automatically.

  7. Click Next.
    The selected diagram is displayed.
Parent topic: Creating content with Infor BI Self-Service templates