If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

default selection of first dropdown value

Started by nancysinghal, 12 Jul 2016 03:12:35 AM

Previous topic - Next topic

nancysinghal

Hi All,

I am facing an issue wherein whenever I create a chart inside a data deck.
Chart has: Region in series which has multiple values.
After you connect data deck to a data drop down list, and run the report, the report output shows the chart displaying the first value under region . Rather it should display all the regions until, the user selects some particular region.

Can anyone please tell where am I missing?

Thanks in advance.
Regards,
Nancy

Lynn

Look into the "No Value List Item" property of your drop down list. Set this to "Show" and define a label for it by clicking on the drop down within the control. It will be the first item in the list by default. You can also set whatever label you choose as the default for the variable that is set by control.

nancysinghal

Hi Lynn,

I have done it already and set the label as: Select Region. But even without selecting any region from dropdown, running the report at first, shows the data for Region: Lake. Please look at the screenshot attached.

Regards,
Nancy

MFGF

Quote from: nancysinghal on 12 Jul 2016 03:12:35 AM
Hi All,

I am facing an issue wherein whenever I create a chart inside a data deck.
Chart has: Region in series which has multiple values.
After you connect data deck to a data drop down list, and run the report, the report output shows the chart displaying the first value under region . Rather it should display all the regions until, the user selects some particular region.

Can anyone please tell where am I missing?

Thanks in advance.
Regards,
Nancy

Hi,

Assuming your data deck is driven by Region values (and your chart is master/detailed to the data deck based on Region) then what you're seeing is exactly correct, and the report is doing precisely what you asked it to. Let me explain...

Imagine a data deck as being like a deck of cards. If you pick up the deck of cards and look at it, you can only see the topmost card - ie the first one in the pile. The same is true in your data deck - when you run the report initially, you're seeing the topmost (ie the first) card, containing a chart showing the region for that first card. Currently you don't have any cards that contain a chart showing all regions, so of course you're not seeing a chart showing all regions when your report runs.

Ok - so your next question is quite likely "How do I add a card to the data deck that is displayed when I first run the report and contains a chart showing all regions?"

The answer is to enable the Default Card for your data deck. The Default Card is displayed when no variable value is set for the data deck, but it isn't switched on by default. Select your data deck in the report and find the "Default Card" property - and set this to Yes.

In your data deck you will now see an extra tab for No Data Contents - this is your default card. Select this, and drag in a new chart showing all Regions. Don't set up a Master/detail relationship for this chart.

Cheers!

MF.
Meep!

nancysinghal

Yeah, it works. Thanku so much MFGF:)
Kudos.

I have got one more query.

Basically, I have 3 cascading prompts in my dashboard: Region, County and Office.
Based on user selection, it shows 4 charts:
1)Statewide, ie. default selection as u suggested which will display all regions on the chart.
2) If user selects some particular region, chart should display data for that region only and legend should show all counties corresponding to that region.
3) If user selects some particular county, chart should display data for that county only and legend should show all offices corresponding to that county.
4)If user selects some office, that office data should be displayed on chart.

I have achieved this using four charts and nested data decks. But performance has got really poor due to multiple charts.

I am trying to use 2 charts instead of four to achieve this:
I used a DI in series with a case stmt as below:
CASE WHEN
?pRegion? IS NOT NULL AND ?pCounty? is null
THEN
[County]
WHEN 
?pCounty? IS NOT NULL and ?pOffice? is null
THEN
[Office]
END

This throws an error that says: case statement should return a single value , not a set of members.

Please suggest some way around, or is this scenario is feasible at all.

Regards,
Nancy