Help with Report Logic in SAP BI BOE

[Former Member]

Hello, I'm not sure if I'm at the right place or not, but I'm using the SAP BusinessObjects (I'll provide some screenshots to better explain my issue)

edw.jpg

Some background;

There are SO (service orders) received in the entire company and each SO has multiple tasks that are completed by different people and in different departments. So if you're displaying a report with all SOs without any filter you'd find one SO duplicated as many times as the unique tasks it has. Now to restrict my findings and do analysis on SOs that have just passed by or were completed by our department, I apply a filter on the table in my report that would display those SOs that contain the task name specified. My problem comes here: what I end up with is selected rows or in most cases one row that has that task with the SO as the primary indicator. But I don't want that, I'd like it to display all the rows and tasks related to the SO if the SO has that one task name included.

I tried simplifying it as much as possible I would appreciate any kind of help thanks in advance.

cross posted just in case

http://www.forumtopics.com/busobj/viewtopic.php?p=1054903#1054903

[jyothirmayee_s]

Hi,

So you want to display all the Tasks and SO's as Summary report and look like want to give user ability to choose Tasks.

Create Input control on Task.

When user opens the report then they will see all the tasks and SO's, They can apply filter on the fly analysis choosing single or multiple tasks.

Will this help?.

Thanks,

Jothi

[jyothirmayee_s]

Hi,

I'm little confused on the issue here,

Correct me if I'm wrong: you want to see only the "Equipment Installation" SO's in the report?.

When you apply filter on specific Task Name, then you should see the results pertaining to it.

Thanks,

Jothi

[Former Member]

That's not exactly it. The report is one Task lever and each SO has many different tasks. in this particular report I require all SOs that have the tasks Equipment Installations or PI Installation to show up. the problem is because of my filter by task name, it only displays rows for those particular tasks while the original SO might have so many more (that are not EQUIPMENT Installation or PI Installation). I want it so that if either tasks are present among the vast sea of different tasks in one order that all tasks and their details regarding that specif order would show up. Hope that makes more sense.