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 multiple queries

Started by b737, 20 Aug 2013 01:03:18 PM

Previous topic - Next topic

b737

I have problem with multiple queries, because when I run report it gives me back only numbers 1 and 2, and not numbers which it should

Grim

We are going to need more information than this to try and help you.
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

MFGF

Quote from: b737 on 20 Aug 2013 01:03:18 PM
I have problem with multiple queries, because when I run report it gives me back only numbers 1 and 2, and not numbers which it should

Hmmm. If I posted a question to you saying "My car has a problem - the light is on" what would your suggested resolution be? You wouldn't be able to give me one, because the question I gave you was completely devoid of any meaningful details. I hope you can see that your question above is just as devoid of any meaningful details, so if you want us to be able to help you you should tell us what your queries are doing, how they are coded, how they are joined/unioned/linked via master-detail etc etc.

Cheers!

MF.
Meep!

Grim

Quote from: MFGF on 20 Aug 2013 04:07:08 PM
Hmmm. If I posted a question to you saying "My car has a problem - the light is on" what would your suggested resolution be? You wouldn't be able to give me one, because the question I gave you was completely devoid of any meaningful details. I hope you can see that your question above is just as devoid of any meaningful details, so if you want us to be able to help you you should tell us what your queries are doing, how they are coded, how they are joined/unioned/linked via master-detail etc etc.

Cheers!

MF.

That's what I said....in not so many words....  ;D
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

b737

Ok, sorry, I have been in hurry.

I am trying to create join of two queries, where Query1 is taking data from one table, and Query2 from other table (Query attribute). The same for both quires is that they have [City] and [Year], other is different, I have two measures,and two more Data Items from different tables. I am using join (link) by [City], I am not sure should I do that. When run report it gives me back only numbers 1 and 2, as I can see it only shows me position where real numbers should be.

Thank you for help