on 12-13-2013 3:31 PM
I have one table that has parent tickets and one table that has work orders, which are sometimes, but not always, children of tickets.
I need to combine all of these into one query "table" so that I can sort/group/tally the aggregate of all work orders and tickets for a month.
The names of the fields differ, ie:
Incident table:
Incident #, date open, date close, group, subject
Work order table:
HD# [this is incident #], date open, date close, group, subject
I also need to know how to join on the incident #.
I'm thinking this will be easiest in the SQL.
Many thanks!
Leslie
.
Isn't it more easy to join the Incident table and Work Order table in the Universe with Cardinality 1:N and with outer join to Work Order Table?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That was my original thought, but I'm fighting with the SQL.
I want to do the join on incident and work order numbers
If I have the fields:
incidentnumber from incident
workordernumber from work orders
incidentnmber from work orders
Can you help me formulate the join?
This will be hugely appreciated, and thanks so much everyone for your helpful comments!
Answering both questions.
Ideally I would like to see:
Incident 22556
Incident 24352
and Work Order
34797
38473
Appear like:
Incident
22556
24352
34797
38473
Some Incidents have work orders associated with them but not all
Some Work orders have incidents associated with the but again not all
I pressed the sql button and was able to edit from there.
I am coming from Crystal Reports and need to convert my reports to WebI, so am not all that familiar with WebI yet.
Many thanks!!
Leslie
If these are based on two queries then use merged dimension on the common objects of both the queries..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you merge the characteristics in WebI Leslie?
With regards
Gill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Work order table also has field work order no.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Leslie,
If these are two tables present in your universe, than easiest way will be two join the two tables in universe and create objects from those tables.
You can use these created objects in the webi report.
If these are coming from two different queries in the report than you can make use of merge dimension concept..
Details of using merge dimension in webi are in below link:
http://scn.sap.com/docs/DOC-49941
Thanks
Gaurav
Hi Leslie,
This unmerged column from the other query can not be directly included in the block.
Try below workaround:
Create a detail variable for those columns which are not merged from second query and associate that to the merged dimension.
For eg.
If query 1 has columns a,b,c,d and query 2 has a,e,f and all dimensions types, than you can use in a single block merged dimension a with either e,f or a with b,c,d.
The workaround to include e and f column from query 2 in block having a,b,c,d would be to create detail variable for the column e and column f and associate these two variables to the merge dimension a and use these detail variable instead of original columns in the block.
Let us know, if this is working.
Thanks
Gaurav
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.