How to filter the data of the Query before Active Report to be generated?

[alex_]

Hi Guys,

I have the following case:
For my project I have to use Active Reports. I have used Cognos 10.2.2.
The clients want to filter the data of Active Report before being generated. They what to filter some of the Items and the report have to be generated only for selected Items not for all data.

I tried to put the Detail filter on the Prompt Page, but it didn't works. The report page no return any values.

I'll be very pleased if somebody gives me an idea how to resolve this requirement.

Thanks!

[MFGF]

Hi Guys,

I have the following case:
For my project I have to use Active Reports. I have used Cognos 10.2.2.
The clients want to filter the data of Active Report before being generated. They what to filter some of the Items and the report have to be generated only for selected Items not for all data.

I tried to put the Detail filter on the Prompt Page, but it didn't works. The report page no return any values.

I'll be very pleased if somebody gives me an idea how to resolve this requirement.

Thanks!

Hi,

The basic approach you are using is correct - you need to write the report so that only the desired values are retrieved. The method for doing this will depend on what sort of package you are using - relational or dimensional. You haven't told us this, and you haven't provided any detail on how you created your filters / prompts. If you can provide this information we would be better able to assist.

Cheers!

MF.

[alex_]

Sorry, about that 

I have using dimensional data model.

As I mentioned above I have filter the data before Active Report to be generated.

Column:

Element Types

Phone

Power

Router

and so on :)

For example: I have a Column for 'Element Types' whit values: 'Phone', 'Power', 'Router' and so on.
I have to filter the other data on the report which has some relation only with 'Phone', 'Power', 'Router' and so.
With the other words, the clients should be able to select 'Phone' or 'Power' and the report should be display only the data which has some relation with selected item - in our case for 'Phone' or 'Power' from column 'Element Types'. Before the Active Report to be generated.

I putted on the Prompt Page standard filter 'Value prompt' to take parameters from 'Element Types' in (?Param_Element Types?).
When I run the report, on the prompt page I can choose some values from 'Element Types' filter. For example 'Phone', but when the Active Reports is generated it didn't return any values – empty report.

The problem is that the Active Reports didn't working with parameters as a Standard Reports.

It will be great if somebody gives me Idea or approach haw to filter the report only for selected values and this selection is made on the prompt page or something like that,
but this filtration have to be made before Active Report to be generated.

Thanks

[MFGF]

Sorry, about that 

I have using dimensional data model.

As I mentioned above I have filter the data before Active Report to be generated.

Column:

Element Types

Phone

Power

Router

and so on :)

For example: I have a Column for 'Element Types' whit values: 'Phone', 'Power', 'Router' and so on.
I have to filter the other data on the report which has some relation only with 'Phone', 'Power', 'Router' and so.
With the other words, the clients should be able to select 'Phone' or 'Power' and the report should be display only the data which has some relation with selected item - in our case for 'Phone' or 'Power' from column 'Element Types'. Before the Active Report to be generated.

I putted on the Prompt Page standard filter 'Value prompt' to take parameters from 'Element Types' in (?Param_Element Types?).
When I run the report, on the prompt page I can choose some values from 'Element Types' filter. For example 'Phone', but when the Active Reports is generated it didn't return any values – empty report.

The problem is that the Active Reports didn't working with parameters as a Standard Reports.

It will be great if somebody gives me Idea or approach haw to filter the report only for selected values and this selection is made on the prompt page or something like that,
but this filtration have to be made before Active Report to be generated.

Thanks

Hi,

If you're using a dimensional package, you shouldn't be defining detail filters in the queries of your reports. Instead you either select the members directly into a set via a query calculation

ie [your Element Types level] -> ?Your Element Types parameter?   then use this in the report container that displays your Element Types instead of using the level

or if the element types are not displayed in the object, add a slicer member set to the slicer filter section of the query, using the same expression

Cheers!

MF.