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

Active report 'All' in filter

Started by Olga1993, 02 Nov 2016 06:22:35 AM

Previous topic - Next topic

Olga1993

As far as I understand, if I want to have 'All' in filter and values aggregated for 'All', I need to make union in queries. Like an approach described in this video https://www.youtube.com/watch?v=CkR4VmZWSek
Or is there any other approach?

MFGF

Quote from: Olga1993 on 02 Nov 2016 06:22:35 AM
As far as I understand, if I want to have 'All' in filter and values aggregated for 'All', I need to make union in queries. Like an approach described in this video https://www.youtube.com/watch?v=CkR4VmZWSek
Or is there any other approach?

Hi,

You have a couple of options. If you are filtering an object (eg a visualization), simply unsetting the active report variable will result in nothing being filtered on, so you will see values for 'All'. You can unset a variable in a number of ways, eg using a button.

If you are using a dimensional package for your report, you can create a set of members to use as your filter values in the control, and include the "All" member from the hierarchy as one of the included members in the set.

If you are not filtering, but instead selecting a data deck, you can enable the default card of the data deck and include an unfiltered report container on this. Simply unsetting the variable will cause this to appear.

Cheers!

MF.
Meep!

Olga1993

You have a couple of options. If you are filtering an object (eg a visualization), simply unsetting the active report variable will result in nothing being filtered on, so you will see values for 'All'. You can unset a variable in a number of ways, eg using a button.

When I use this option I don't see the aggregated results. Ex., All brands - 1000, I see Brand 1 - 500, Brand 2 - 300, Brand 3 - 200. Yes, I use relational model.

MFGF

Quote from: Olga1993 on 02 Nov 2016 06:43:06 AM
When I use this option I don't see the aggregated results. Ex., All brands - 1000, I see Brand 1 - 500, Brand 2 - 300, Brand 3 - 200. Yes, I use relational model.

In a visualization? Are you displaying the item you are filtering on? Why?

MF.
Meep!

Olga1993

I want the following:
filter selection : All brands
Chart is changed by the filter and should show All brands - 1000. This can be reached by using union for query.
But when I use 'No value List Item' in the filter, I see Brand 1 - 500, Brand 2 - 300, Brand 3 - 200.

So my question is there any option to "All brands - 1000" instead of using union?

MFGF

Quote from: Olga1993 on 02 Nov 2016 07:40:14 AM
I want the following:
filter selection : All brands
Chart is changed by the filter and should show All brands - 1000. This can be reached by using union for query.
But when I use 'No value List Item' in the filter, I see Brand 1 - 500, Brand 2 - 300, Brand 3 - 200.

So my question is there any option to "All brands - 1000" instead of using union?

Is this a chart or a visualization?

MF.
Meep!

Olga1993

I use list and charts in one report and visualizations and list in another with the same requirement of All in filter.

MFGF

Quote from: Olga1993 on 02 Nov 2016 10:35:24 AM
I use list and charts in one report and visualizations and list in another with the same requirement of All in filter.

Which report are we talking about here? Can you explain?

Charts cannot be filtered by controls in active reports, as there is no client-side charting engine to re-render the charts within the MHT. Instead, you include the charts in decks or data decks (the latter with a master-detail relationship to the chart), and your active report controls "select" the deck or data deck.

Visualizations can be filtered by controls in active reports, as the RAVE visualization engine gets included in the rendered MHT. Your active report controls "filter" the visualization.

Can you explain which approach you are using in your report?

MF.
Meep!

Olga1993

I do the same approach as you describe.

MFGF

Quote from: Olga1993 on 02 Nov 2016 10:46:42 AM
I do the same approach as you describe.

I described two approaches - one for charts and one for visualizations. Which are we talking about here? Can you tell us exactly what you are using, how it's set up and what you are getting vs what you want to see?

MF.
Meep!

Olga1993

Quote from: Olga1993 on 02 Nov 2016 10:35:24 AM
I use list and charts in one report and visualizations and list in another with the same requirement of All in filter.

MFGF

Quote from: MFGF on 02 Nov 2016 10:55:11 AM
Can you tell us exactly what you are using, how it's set up and what you are getting vs what you want to see?
Meep!

Olga1993

In one active report: list + charts inside data decks.
Second report: list + visualization + visualization inside list.

My question was how to implemetn feature with 'All' in filter, so that I can see agregated values for 'All' in all report elemants.

Understand?

MFGF

Quote from: Olga1993 on 02 Nov 2016 11:21:48 AM
In one active report: list + charts inside data decks.
Second report: list + visualization + visualization inside list.

My question was how to implemetn feature with 'All' in filter, so that I can see agregated values for 'All' in all report elemants.

Understand?

In your first report, enable the default card of your data deck and add a version of the list/chart to this card which shows the view of data you wish to see for "All". When you unset the active report variable that drives the data deck, you will see the default card.

In your second report, unset the active report variable that filters your visualization, and you should see unfiltered results. This assumes you are not showing the filtered values directly in the visualization. We have to assume here because you don't seem to want to give us any details on how you have set up your visualization. For the list, move it to a data deck and use the same technique as in the first report.

MF.
Meep!

Olga1993

Af far as I can see, when I use approach with default data card I need to create duplicated chart with query with no granularity by brand. Correct?

MFGF

Quote from: Olga1993 on 03 Nov 2016 02:37:34 AM
Af far as I can see, when I use approach with default data card I need to create duplicated chart with query with no granularity by brand. Correct?

Yes - correct. The chart/list on the default card should be for all brands.

MF.
Meep!

Olga1993

So there is a question, whar is worse to duplicate chart and quesry for that or to use union in queries and one chart? :)

MFGF

Quote from: Olga1993 on 03 Nov 2016 05:37:28 AM
So there is a question, whar is worse to duplicate chart and quesry for that or to use union in queries and one chart? :)

What do you mean by "worse"? Both will result in an extra query being run as the MHT is generated...
Meep!

Olga1993

I mean what you would choose :)
Thank you for answering my questions!