Cloud Cruiser became HPE Consumption Analytics on Nov. 1st. You'll still see the old name in places while we update this site.

 

 

Consumption Analytics Documentation

Home > Cloud Cruiser 4 > Administering > Managing reports > Creating custom reports > Report tables and columns

Report tables and columns

The following HPE Consumption Analytics Portal database tables are used in the persistence of loaded reports. Descriptions of notable columns are included.

abstract_report_item

Associates reports and report groups with users

Column Description

user_id

User ID for which the record applies

output_order

Sort order of the record

hidden_flag

“1” if hidden for the user, “0” if visible

report

The report record for each loaded report contains most of the information about the loaded report, including the name, title, the report template itself and other properties.

Column Description

report_name

Unique name of the report.

report_file

Name of the report file from which the report was originally loaded.

report_title

Report title displayed in the report tree, and which might also be displayed at the top of reports themselves.

output_format Designed report type, which can be HTML, PDF, or XLS

report_creator_userid

User ID of the user who initially loaded the report

standard_report

“1” if the report was loaded from the standard report location, “0” if not

hidden

“1” if the report should be hidden from the report tree, “0” if not

active "1" if the report is active, "0" if not

design_xml

The report template XML

compiled_report

Compiled report template

report_audit

Provides information about report runs.

Column Description
ID ID of the report
report_name Name of the report
run_count Number of times the report was run
run_by_user_id ID of the user that last ran the report

report_group_item

Defines report groups for the report tree.

Column Description

abstract_report_item_id

Foreign key to the abstract_report_item table

name

Report group name

description

Report group description

report_item

Reports are associated with report groups with records in this table.

Column Description

abstract_report_item_id

Foreign key to abstract_report_item table

report_id

Report ID

report_group_id

Report group ID

report_to_resource_bundle

The report_to_resource_bundle record maps reports to resource bundles

Column Description
report_id The report ID
resource_bundle_id ID of the associated resource bundle

report_to_role

The report_to_role record maps reports to roles, defining which system roles are allowed to view which reports. The administrator role ID is present for reports which have been loaded as restricted. All other reports are mapped to the default report user role.

Column Description

report_id

The report ID

role_id

The role ID

resource_bundle

The resource_bundle record contains a name and the .properties file itself for a particular report.

Column Description

name

The resource bundle name

data

The contents of the report .properties file

Last modified

Tags

This page has no custom tags.

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP