Why can’t I see all of the data returned by the cube in my report?
Business Objects seems to be hiding data. I get 9 rows in the cube, but only 3 rows show up on the report. What would cause this?
There are a couple of reasons why you may not be seeing all the data in your cube within your report.
One possibility is that the data is being filtered. You can check to see whether any filters are excluding rows.
- Click on the block so that it is highlighted.
- From the Business Objects Format Menu, select Filters.
- The Filters On dialog box displays the global and block-specific filters applied to the report.
- If you have no filters applied, nothing will appear in the Folders. The global folder will display any filters that have been applied to the all blocks. The block-specific folder is named based on the block name and will display any filters that have been applied to that block.
- The Values dialog box displays the values available for the variable. The highlighted values are those included in the filter. Any that are not highlighted will be filtered out.
- If you want to remove a filter, click on the filter and then click on Remove.
BusinessObjects, by default, shows only unique rows of data. If the values in your block would result in the same row being displayed more than once it will only show that row once. However, you can force the block to display duplicate rows.
- Click on the block so that it is highlighted.
- From the Business Objects Format Menu, select Format Table.
- The Table Format dialog box will be displayed. Click on the General tab.
- Under the Display box is the option “Avoid Duplicate Rows Aggregation”. If you check this box, all rows will be displayed without aggregating. (This option is not available for a crosstab).
Eileen King (BOB member since 2002-07-10)