Add data to the list

This task adds the required data items to the list.

Procedure

  1. Pause the pointer over the query explorer button Query button icon. and click Query1.
  2. Copy the Core products data item.
  3. Pause the pointer over the query explorer button and click Query3.
  4. Paste the Core products data item into Query3.
  5. Repeat steps 1 to 4 to copy the Countries and regions data item from Query2 to Query3.
  6. Pause the pointer over the page explorer button page explorer icon and click Page1.
  7. Click the Data Items tab Data items tab icon. and drag Core products and Countries and regions from Query3 to the list.
  8. Click the Source tab Source tab icon. and do the following:
    • Expand the Products dimension and then the Products hierarchy.
    • Drag Product type to the list, inserting it between Core products and Countries and regions.
    • Expand Sales fact.
    • Drag Revenue and Planned revenue to the list, after Countries and regions.
Parent topic: Example - Create an Active Report Showing Revenue Data for Core Products