Getting Started with DSBI Cube Reporting in Excel Pivot Tables

From DataSelf Knowledge Base
Jump to navigation Jump to search

Are you seeing the latest version of the data?

The data you are seeing in this pivot table has gone through quite a bit of processing to get here. Behind the scenes on the server, it has been copied into a separate database and prepared for reporting, held inside OLAP Cubes, waiting to be pulled into a report. This data refresh process usually occurs every night.
Then this fresh data needs to be pulled into the report for you to see it.

Refreshing the report data

Right click anywhere on the PivotTable report and select Refresh, to refresh one report.
To refresh all reports in the workbook, from the Data ribbon, click Refresh All.

Checking the Last Cube Refresh Date

Check the Last Cube Refresh Date to check that the detail you are pulling into this report is current. This date is usually found in the upper left corner of the pivot table. Notify your system administrator if this date is more than 24 hours old.

Filters

Introduction to Filters

Every spot on your report that has a pulldown arrow box (show icon) is an opportunity for you to filter your report so that it just displays the data that you are interested in.
Use the Search box to quickly find specific members of long list.
Video: http://office.microsoft.com/en-us/excel-help/video-filter-items-in-a-pivottable-report-VA101812189.aspx?CTT=1
Article: http://office.microsoft.com/en-us/excel-help/filter-data-in-a-pivottable-or-pivotchart-report-HA010167795.aspx
See Also: Always selecting the same filter settings for rows or columns? See Named Sets
Pivot Tables do not display dimension members with no data. To override this default, right click anywhere on a pivot table, select PivotTable Options, Display tab, Show items with no data… .

Why so many filters on DSBI reports?

When the filters are set to the default “All …” level, they do not affect the report. But you can quickly narrow down the range of your report, effectively creating a new report, by using one or more of the filters.

Use the Pivot Table Field List to create report variations

Right click anywhere on the pivot table and select Show Field List to open the Field List, if needed.
Drag the report objects among the Report Filter, Column Labels, and Row Labels boxes to modify your report. For example, drag one of the items in the Report Filters box into Row Labels to create a more detailed report.