BusinessObjects Board

Multi-select Checkbox or List Builder

other Xcelsius - Crystal Dashboard Design
#1

Hi Experts,

I am a beginner to Xcelsius and i have this requirement where Users want to select a column or multiple columns using Checkbox or List Builder.

Region State County Revenue
North Montana Madison $10,000
North Minnesota Pine $20,000
North Minnesota Benton $25,000
South Texas Collin $50,000
South Texas Smith $40,000
South Alabama Blount $15,000
East New York Clinton $60,000
East New Jersey Essex $40,000
East New Jersey Camden $35,000
West California Fresno $55,000
West California Imperial $50,000
West Oregon Wasco $30,000

We have 3 check boxes or 3 objects in List Builder

-Region
-State
-County

If Only Region selected then User wants to see All Four Regions and Aggregated Revenue data by Regions.
If Only State selected then User wants to see All States and Aggregated Revenue data by States.
If Only County selected then User wants to see All Counties and Aggregated Revenue data by Counties.

If Region and State both selected then we want to see both objects values and Revenue (total 3 columns) aggregated by State(lower granularity in this case).

If Region, State, and County selected then we want to see all objects values and Revenue (total 4 columns) aggregated by County as this is at lowest granularity.

Any help will be appreciated.

TIA

justdesi (BOB member since 2006-06-28)

#2

Where is your data and how are you accessing it?

Debbie

Debbie :uk: (BOB member since 2005-03-01)

#3

Debbie,

What i am trying to do is to pull all the data in excel and then show this in Xcelsius. Attached Spreadsheet.

Or we can run this on the fly using query as web service.

First one looks better, may require some aggregation at excel. Any idea ?

Thanks
Book2.xls (32.0 KB)

justdesi (BOB member since 2006-06-28)

#4

Sorry - not allowed to download files here!

What I was trying to establish is this:

If you can run queries on the fly, then have one graph and one dropdown. Run your first query to populate the dropdown, then make it dynamic depending on user selection.

Eg: First dropdown is list of countries. When user selects - say - England, run query to fetch English counties. When user selects county, run query to fetch towns in that county. Pass the user selection back out to the query dynamically so you only need a couple of queries to do everything.

Debbie[/quote] :smiley:

Debbie :uk: (BOB member since 2005-03-01)