Apply Province Filter of Dept Dimension to Province filter of Funder Dimension

[vincydza@gmail.com]

The  Hierarchy of the Department and Funder Dimensions is as follows.

Department (All)      Funder (All)
Province                  Province
Program                  Category
Department             Funder

The requirements of the report are to provide users with filter criteria on the Program of Department hierarchy and the Category from the Funder Hierarchy. However, the filter criteria for the Province have to be supplied only once i.e. Ontario province.

When the same filter parameter is applied to the Department province and the Funder province, the report is returning an error message


OP-ERR-0145 Unsupported comparison between objects in different dimensions: dimension1="[Funders (All)]" and dimension2="[Department (All)].[By Department]". Error processing filter 'members([KPICUBE].[Funders (All)].[Funders (All)].[Province (Funder)]) = ?pProvince?'.

How can a report be created so that the province filter criteria is selected only once and applied to both the dimensions?

Please advise.

[MFGF]

The  Hierarchy of the Department and Funder Dimensions is as follows.

Department (All)      Funder (All)
Province                  Province
Program                  Category
Department             Funder

The requirements of the report are to provide users with filter criteria on the Program of Department hierarchy and the Category from the Funder Hierarchy. However, the filter criteria for the Province have to be supplied only once i.e. Ontario province.

When the same filter parameter is applied to the Department province and the Funder province, the report is returning an error message


OP-ERR-0145 Unsupported comparison between objects in different dimensions: dimension1="[Funders (All)]" and dimension2="[Department (All)].[By Department]". Error processing filter 'members([KPICUBE].[Funders (All)].[Funders (All)].[Province (Funder)]) = ?pProvince?'.

How can a report be created so that the province filter criteria is selected only once and applied to both the dimensions?

Please advise.

Hi,

A detail filter like this is a relational reporting construct, but you are using a dimensional package. The levels of your hierarchies contain members, not values. Each member is identified by a Member Unique Name (MUN), and when you display these members the report shows you the member captions. This means that although the provinces in the two dimensions might look the same when a report renders the member captions, they are actually different behind the scenes because each has a different MUN.

What do the MUNs look like in your package? You can see them if you expand the package tree and the relevant Members folder, and right-click on a member.

I would also avoid using any detail filters too. Instead, use a slicer filter (if the members are not being displayed) or a query calculation with a dimensional expression such as tuple() (if the members are being displayed) to get consistent results.

Cheers!

MF.

[vincydza@gmail.com]

Thank you.