Topic
  • 1 reply
  • Latest Post - ‏2013-05-13T19:25:31Z by rperzul
GOICEHOCKEY
GOICEHOCKEY
18 Posts

Pinned topic Unsupported Comparison between Objects

‏2013-05-10T17:52:49Z |

Folks,

I am getting the following error after trying to have the Query to use the parameter that is created as a part of a different Dimension as a

part of the filteration.

Dimension A

SITECD   COUNT

1111             5

2222             6

 

Dimension B

SITECD SITE NAME 

1111        Europe

2222         US

 

Now, the following filteration is failing

[dsCube-].[XXX].[XXX].[SITECD] in (?SiteP?)

 

The parameter SiteP is generated from a different Query from a different Dimension that has a listing of SITES and their Names. Basically a none-fact table.

 

Unsupported comparison between objects in different dimensions: dimension1="[SITECD]" and dimension2="[SITE_Listing]". Error processing filter 'members([dsCube].[XXX].[XXX].[SITECD]) in (?SiteP?)'.

Thx in advance for your time!!

  • rperzul
    rperzul
    62 Posts

    Re: Unsupported Comparison between Objects

    ‏2013-05-13T19:25:31Z  

    Hi,

    it looks like you are using a dimensional model/cube as data source. Do I understand you correctly that you have one Query that references Dimension A to supply the prompt values for ?SiteP? and want to filter on a data item that references Dimension B with parameter ?SiteP?

    This is not supported. Filtering with dimensional models/cubes incorporates a member unique name (MUN) that includes the dimension name. And Cognos will notice that you are using different dimensions on both sides of the filter expression.

    Can you try to clearly explain your business problem in order to find a proper solution.

    Regards,

    Ron