Creating a Financial Report Using a Cube Data Source

How to:

You can create a financial report using a cube data source. To do this, you must add the Member Unique Name field of the hierarchy into Report Painter, and change the field type to FOR. The Member Unique Name field is typically the first field listed in the hierarchy when the Show Advanced Fields option is enabled. When you switch to the Matrix view tab, the values in that field will display hierarchically. If you do not use the Member Unique Name field, the values will not be listed hierarchically.


Top of page

x
Procedure: How to Create a Financial Report Using a Cube Data Source
  1. Create a new report using a cube data source.
  2. In Report Painter, use the Object Inspector shortcut menu and click Show Advanced Fields.

    All fields within the Dimensions folder are now displayed.

  3. Using the Object Inspector, add the Member Unique Name field of the hierarchy to your report.
  4. Select the field and click For.

    The field is changed to a FOR field.

  5. Click the Matrix view tab.

    You can now create your financial report using data in the cube data source, as shown in the following image.


WebFOCUS