how to drag columns from different tables in different package

[vas]

 

I need to genreage a report using different tables from diff columns ..

it asks for a relation .. i dont know how to give the relation so could any 1 help me out..

thanks

[MFGF]

I'm not sure what you're trying to do here...
a) Create a report containing query items from different query subjects within a single package?
b) Create a report containing query items from different query subjects in different packages?
c) Create a report containing tables populated by query items from different query subjects within a single package?
d) Create a report containing tables populated by query items from different query subjects in different packages?
e) Something else?

Could you be a bit more specific about what you're trying to do, and the problem you are having, which studio you are using, and how your reporting package(s) is/are defined?

Regards,

MF.

[vas]

i am trying to genreate a work order cost summary report..

1.. it has cloumns like  parent eqipment, work order, material cost,material , service cost, labour cost..

2. parent eqipment ,work order are query items from r5events query subject
3. material cost,par_code is from r5parts  query subject
4.service cost is from r5orderline query subject
5.service cost is from r5bookedhours query subject

when i drag them from the insertable objects pane it says no relation...

so i just wanted to know how to make the relation and get the result..

this has to be done generated from starting date to ending date..

[MFGF]

Hi,

OK, so your query items are from different query subjects defined in the same package?

What is the exact error message you are getting?  It's possible that the package you are using to base your report on may not have been set up properly.  Normally you should expect to be able to bring in any query items from any mixture of query subjects without getting messages such as "cross product queries are not allowed" or other similar errors.  However, unless you can give us the exact error you are getting, it's going to be hard to pinpoint the problem.

If you are missing relationships between query subjects, then it's probably going to be best to get these defined in Framework Manager and then get the package republished.  This is just a guess, though, based on the pieces of information given so far...

Regards,

MF.

[vas]

this is the message i receive when i drag a query item from different namespaces..

" the insertion location doesnot have any associated query. you can only perform this operation in the drop zone of a list , crosstab or chart , or after you associate a query with this page"

[MFGF]

Hi,

It may be something as simple as you not dropping in the correct place.  This message is displayed when you try to drop a data item onto the report page outside the boundaries of a list, crosstab or chart, all of which have a query associated with them.

What kind of report are you trying to create?  If it's a list, make sure that you are dropping the query items inside the list object (you should see a slim vertical rectangle with a flashing vertical line inside it if you are dropping in the right place.  You will see a single flashing vertical line on its own if you are dropping outside the list, and you will get the above error message).

If I'm barking up the wrong tree, please let me know! :-)

Best regards,

MF.

[sir_jeroen]

Bark... Bark... Bark... (in english: You're right with your answer, but you forgot to mentions that he first has to ADD a list-item to his report  :) )

[MFGF]

Hi RA,

I was assuming the report here was using the List template, so would already contain a list object - sorry, I should have been more precise.

Thanks for the barks :-)

MF.

[vas]

it is giving the same error..

i have to generate a work order report ... in which the query items in query subjects are in different namespaces..

one of the query items in the query subject from a particular namespace is related to a different query item in query subject from a different namespace..

For ex

(Work order) query item is in (R5events) query subject  which is in (work) namespace.

(material) query item is in (R5orders) query subject which is in (materials) namespace

(equipment) query item is in (R5events) query subject which is in (work) namespace but this query item is

also equal to the (stc_child)query item form (r5structures)query subject in (objects)namespace..

this is how the query items are and when i pull the dat it is restricting me..

should i give any join conditions, if yes ,where??or is there any other way to proceed this report..??

[CoginAustin]

Of course you need to join them if you are needing values from both.

I believe Cognos best practice is to create a bridge table where the 2 fact tables will be joined.

[sir_jeroen]

Vas... did you take any course in CRN?
Please start reading the manual and take a look at the samples provided by Cognos maybe this will make it a bit clearer for you..
This sounds hard but it's not meant that way... I'm only saying this because I believe you'll have take some courses to understand the fundamentals about relationships etc... and then you'll get a better picture of how CRN works...