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

Finding top 10 records after join the queries

Started by Sarayucog, 19 Jul 2011 02:07:28 AM

Previous topic - Next topic

Sarayucog

I have query1 and query2. In query I am finding current days data and in query2 I am finding previous days data. I want to show these two measures in the same list report. So I am joining into one query. I want to get top 10 records also.

Here my problem is if run these queries individually those are running fine and giving top 10 records. When Iam joining these queries into one query I am not getting top 10 records and not the correct data also.

What is the reason. Please tell me...

Your help will be more appriciated. Thanks in advance

Arsenal

is the ranking supposed to be on current day or previous day?
i mean, are you trying to author an overall ranked report? If your ranking on on just one of the measures then  why don't you try unranked queries for query 1 and 2 (just like you would when building unranked reports), join these two to form query3, bring in the dataitems you need into query3 and then rank this query 3 (something like rank([your measure value] for report) to get an overall top 10?

Sarayucog

Thanks for you response...

but this is not working. With this process also I am getting same result.

please share any other ideas....   anybody....

Lynn

It isn't clear to me how you are putting the queries together and what is wrong with your results. How are they joined? What does the data look like in Q1, Q2 separately and what do you see in the joined Q3?

Elaborating a little more beyond "not the correct data" and providing some sample data might help you get better suggestions.