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

Problem with dynamic filters

Started by binf, 30 Aug 2023 02:21:32 AM

Previous topic - Next topic

binf

Dear Community,

I have a strange problem with my report. I am working with a relational model. In the FrameworkManager I have built a star schema, 1 fact table and 6 dimension tables (see "bild1.png"). The report itself is a normal crosstab, where the columns and rows are from the dimension tables and the crosstab intersection is from the fact table (the "zaehler" column). The data is pre-filtered by the prompt page. In the report, there are an additional 4 menus to perform live filtering (see "bild2.png"). These menus are linked by cascading sources. Additionally all possible sums are calculated. Now the problem, when I run the report, the crosstab is displayed correctly but not the filters. The first one is correct, the other three are empty (see "bild3.png"). When I select something in the first one, the second one does not show the correct result either. The procedure below calculates all possible values and always returns an additional line "Alles ausgewählt", but it is missing here.

Now I already have this kind of report in use, and there is not the problem. But there I have not built the data sources of the filters used on the prompt page in the star schema. Therefore I have separated the query "dim - Quelle" (see "bild4.png"). Now, when I run the report, the 4 menus are correctly filled and the selection works also(I have a script which automatically refreshes the page every time I click in the menus). But, now I can't generate totals in the crosstab anymore and I can't sort without a cross join error!

What am I doing wrong? I want correctly filled selection menus and totals in the crosstab.

I hope someone can help me, I'm getting desperate here.

Greetings


PS: Unfortunately, I can not upload pictures here in the forum. He can not access them.