Report Studio - Scorecard Suggestions

[UcfMike]

The client has asked for a report that is essentially 8 different list reports on one page. They call this there scorecard. Here is where I'm looking for suggestions.

The report is a multi-page report with page one being the report data rolled up to a company wide level, the next page showing data at a product group level, and then the final pages showing the product level.

So I essentially end up with this:

1

-A
--z
--y
--x

-B
--z
--y
--x

To solve this problem, I'm thinking pagesets. What I'm wondering is this, is there a way to rollup the data without creating many query subjects. Right now I see this happening.

Query Subject = ( productdata.item for company )
Query Subject = ( productdata.item for product group)
Query Subject = ( productdata.item for product )

Does this make any sense?

 

[blom0344]

For this you will not need additional query items at all:

1. One query can feed multiple lists.
2. Each list will contain a set of dimensions (forgive the phrase, I used to work with BO)
3. Changing the set of dimensions will yield different rolled up presentations of the data

The essence is to distinguish between aggregate and rollup behavior here. differently aggregated sets would imply multiple queries/dataitems.
The rollup is performed by the server by using the aggregated set as a base and rooling up according to the non-facts of a list.

Ties Blom