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

Pass weeks from Month slider to chart

Started by prav78, 09 Mar 2016 06:12:53 AM

Previous topic - Next topic

prav78

Greetings,

I'm a beginner in Active Reports and I need your help.

I have a 12-month data slider sourced from time query with fields:
- Mon-YY (e.g Jan-16),
- YYYYMM (e.g 201601),
- YYYYMMWW (e.g 20160101, 20160102 ... 20161253) &
- WW (e.g WK-01, ..... WK-53).

YYYYMM is currently used in other charts within the dashboard.



My aim is when the slider is move to January 2016 and so on, all the weeks in that month will display on a chart.
The query for the chart contains the following fields:
- Job_Count, 
- Entered_Date_YYYYMM,
- Entered_Date_YYYYMMWW &
- WW (same format as above).


My question is how do I pass the YYYYMMWW values from the slider to the charts?

Your help is much appreciated.
Thanks.

MFGF

Quote from: prav78 on 09 Mar 2016 06:12:53 AM
Greetings,

I'm a beginner in Active Reports and I need your help.

I have a 12-month data slider sourced from time query with fields:
- Mon-YY (e.g Jan-16),
- YYYYMM (e.g 201601),
- YYYYMMWW (e.g 20160101, 20160102 ... 20161253) &
- WW (e.g WK-01, ..... WK-53).

YYYYMM is currently used in other charts within the dashboard.



My aim is when the slider is move to January 2016 and so on, all the weeks in that month will display on a chart.
The query for the chart contains the following fields:
- Job_Count, 
- Entered_Date_YYYYMM,
- Entered_Date_YYYYMMWW &
- WW (same format as above).


My question is how do I pass the YYYYMMWW values from the slider to the charts?

Your help is much appreciated.
Thanks.

Hi,

If you mean charts (as opposed to visualizations) you're going to need to use a data deck. The data deck will be driven by the same item you are using in your slider (I'm assuming this is YYYYMM?) Your charts will need to be within the data deck, and you will need to set up a master/detail relationship between each chart and the data deck, based on the YYYYMM item. Finally, the slider will need to set an Active Report Variable which is then used to select the data deck.

Cheers!

MF.
Meep!