Setting up a workbook

This section explains how to create a new workbook and configure it according to best practices before developing.

To set up a workbook

Open HPE Consumption Analytics Portal Desktop and choose File > New.

Set up your data source. In most cases the data source shipped with HPE Consumption Analytics Portal will meet your needs. If so, perform the following steps to connect it to this workbook. If you need less common data, you can create a custom data source instead.​

In the Data pane on the left, click Connect to Data, then under On a server click Tableau Server.

Click the charges data source. The blank worksheet reappears, now with the dimensions and measures from the charges data source available to use.

If you are using the data source shipped with HPE Consumption Analytics Portal or another data source that includes an Authorized? field as recommended in Creating a custom analytics data source, filter data to only authorized users.

Drag the Authorized? field to the Filters shelf.

In the list of values in the Filter dialog box, select True. If there are no values in the list, this means that HPE Consumption Analytics Portal Desktop cannot evaluate the Authorized? calculated field because it currently cannot access data for either the [Username] field (because your data source has no records) or the USERNAME() function (because you're not logged in to HPE Consumption Analytics Portal Server). To work around this:

At the top of the General tab, select Custom value list.

Click the Enter Text to Add line.

Type the number 1, then click the '+' at the right end of that line. The custom value True is added to the list.

Select True.

Click OK.

You must create this filter in each worksheet that uses such a data source. This is required not only to enforce permissions to customer data but also to prevent duplicate rows from the ReportAccountSecurity join from causing inaccuracies in your reports.

Publishing a workbook

This section explains how to publish your workbook to HPE Consumption Analytics Portal Server when you finish developing it, so that others can use it from the HPE Consumption Analytics Portal Portal.

To publish a workbook

From the Server menu, choose Publish Workbook.

In the Views to Share list, deselect any views that you want to hide in the My Insights window. If you have created any dashboards, consider hiding the worksheets they display. This gives your users a cleaner list of reports to choose from. Users still see these sheets as part of a dashboard, but can't view them as separate reports.

Click Publish. If prompted to embed credentials, click Yes. If prompted to log on to the data source, enter your SQL Server username and password, then click OK.