Hard to explain so I attached links:
I am trying to build a similar report in OBIEE, this is a screen shot from the other reporting software. Its grouped by Order Type and Order Number, and for each Order number three tables are grouped by it, WO Completiions, Material Issues and Labour. In other words, the user wants the know the Completions, Issues and Labour for each Order Number.
When trying to build it in OBIEE I am only able to do the following:
Each table (Complettions, Labor and issues ) are individualized and not separated by Order Number like the first link.
Hopefully this makes sense
I believe you cannot exactly do the same thing this other tool has done, but something which gives almost a similar layout with the information.
I would say (from the data i see on the pics),talk with the users and suggest them other better designs.
Edited by: user12210196 on Oct 22, 2012 12:38 PM
There is a possibility using Narrative view!!
If possible give a try something below. You need to do more formatting using HTML.
I see a lot of work in HTML code wise to get BI look and feel.
Hope this helps, pls mark if helps
<td colspan=2> inner table goes
Did you try this option?
Edited by: veeravalli on Nov 16, 2012 10:09 AM