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

Question on joining 2 queries

Started by asmfloyd, 15 Feb 2022 01:34:33 PM

Previous topic - Next topic

asmfloyd

Hi,
  I am joining 2 queries. Each of my queries have 12 unique fund names. Each query have a measure value for which I am setting the Detail aggregation property as "Total" to calculate the sum of individual funds inside each queries).
  When I equi join both queries using unique fund names, I get 12 funds. But the measure values are incorrect. What can be wrong in the join?

Thanks,

bus_pass_man

You can't create a join in a dashboard and it doesn't have a UI object called a query so I imagine that you're working in report studio.

What's in the two queries? Is one a fact and the other a dimension?  Are they both mixes of dimensions and facts?

What is the nature of the incorrect values? 

Why you are doing the join? Why not a union? It isn't clear what is in the queries (hence previous question) but I'm guessing from what you said (which is a problem, you should have a clear enough idea of the problem which you are trying to solve to be able to define it in your question) that you have a query with some fact associated with funds.  In another query you have a fact which is related in some way to the fact of the first query. (one being the data for 2021 and the other the data for the years prior to that for example).  If that is the case then a union would be appropriate.

How do you know the values are incorrect and not exactly what you've asked the query engine to do?  If they are incorrect, how are they incorrect?

Why you are doing this modelling in your reporting tool rather than a modelling tool?

What is the nature of the relationships in the source model between the objects used to create these queries?  This, of course, is assuming the nature of the source, as it could be a DMR or a cube.

So the initial answer to the question what be wrong in the join could be, the fact you're trying to do a join.

MFGF

Now moved from the Dashboards board to the Reporting board.

MF.
Meep!

asmfloyd

Thank you MF for moving it. When I created, I accidentally done under Dashboards and was unable to move from there.
  My issue was I missing one additional join condition. Due to this, it was creating cartesian join which made the result value high. I thought error was due to Detail aggregation property.

Thanks bus_pass_man for your inputs .