You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 51 Next »

You need to be in edit mode in order to create new table. Click on "Edit" in top report menu to activate edit mode.

To add a new Table, hover over free place and click on Table view type. The Add a table dialog box will appear.

  1. Enter name of the new table.
  2. Check Date interval if you need to restrict time period of displayed data - continue by Setting Date Interval.

Confirm new Table view by clicking on a green Add button. BellaDati will guide you through additional setup.

You can create also table without any indicators. This is useful for "static" items lists reports (especially in conjuction with more drill-downs and hiding drill-down "+" signs).

Table management

You can perform additional operations in the upper right corner of the inserted Table view:

  • Table settings
  • Indicators
  • Table appearance
  • Filter setting - continue by Setting Filter
  • Export view - continue by Exporting View
  • Add to dashboard
  • Move table
  • Duplicate table
  • Delete table

Hover over Indicators in a toolbox list to quickly add or remove indicators.

Table settings

Click on toolbox icon or select Table settings from the toolbox list to enter Table settings dialog.

Table settings dialog shows Time, Indicators and Drill down paths currently positioned at X and Y axes. BellaDati allows you to:

  • Swap X and Y axes
  • Switch between horizontal and vertical position.
  • Change order within axis.
  • Remove drill down path.
  • Enter indicators or drill down path dialogs.

Drill Down Path

You can add Drill down path from Table settings dialog after selecting Add drill down path.

From Drill down path dialog you can perform following operations:

  • Add new Drill down path to the view.
  • Mask members with custom URLs
  • Setup Limit for members in the drill down path. Displayed memebers depend on current sorting setup.
  • Display Total value. New consolidated element will be added to the drill down path.
  • Format total value's font color, style and background.

Custom member

Custom member allows you adding your own nodes into drill down paths. You can add Custom member from Table settings dialog after selecting Add custom member.

Custom member dialog allows you to:

  • Select Level for a custom member.
  • Specify Name of the custom member.

Every new node requires additional definition. Custom member definition dialog allows you to determine attribute values from particular levels which will be aggregated into custom member.

You can delete created nodes in Custom member dialog.

Table Appearance

You can access Table Appearance from the Table Settings dialog or the from toolbox drop down list.

Table Appearance dialog allows:

  • Applying predefined Content color themes.
  • Setting Title Color.
  • Checking Even and odd rows differentiation.
  • Hide drilldown cell controlls: Drill-down "+" signs will be disabled for all drill-downs in the table (useful for "static" item lists etc.).
  • Selecting Drill down depth shading.
  • Force column width.
  • Force left header width.

Hover over Table Appearance in toolbox list to quickly apply Title Color.

Displaying Raw Cell Data

You can display all data which composes current cell in Raw Cell Data dialog. Click on the desired cell and select Raw cell data to open the dialog.

Static Lists

BellaDati allows you to list attribute members without any indicators in form of a static lists. In order to create static lists:

  1. Create new Table
  2. Select arbitrary Indicator.
  3. Choose desired Attributes.
  4. Remove Indicator from the table.
  5. Optionally hide drill-down controlls in Table Appearance.
  6. Optionally prevent BellaDati from merging same members in Table Appearance.

Next Steps

  • No labels