Profile picture for user broadussm

I need to create a report in which there are three connected objects. For example, Org Unit is connected to Position is connected to Person. I am able to build the report so this is produced.

However, ALL Person objects that are connected to the position are returned. For example, if the Org Unit was Germany Division and the Position was Sales Rep, my report that I have created returns Germany Division and Sales Rep but when it goes to connect the Persons to the Sales Rep, it includes Persons who occupy the Sales Rep Position outside of the Germany Division Org Unit.

Is there a way to filter the results of two connected objects based on a third object?

Let me know I need to explain myself better.

Thanks!

by Torsten Haase
Posted on Fri, 12/17/2010 - 13:44

Hi Stefan,

but this means, that somewhere in a model, there is another OrgUnit (say France Division) connected to the same Object definition of "Sales Rep". Otherwise no other results are possible, if you query this way:

1. for OrgUnit "German Division" give me all connected Positions

2. for every result of 1: give me all connected Persons

BR,

Torsten

0
by Stefan Broadus Author
Posted on Fri, 12/17/2010 - 15:05

Thanks for the post Torsten.

If you run the report in this way, would it not return all connected persons to that position, regardless of org unit? This is what I want to filter, if possible, so my output might look something like this:

1. Org Unit: Germany Division

  • Manager: John
  • Sales Rep: Mark

2. Org Unit: France Division

  • Manager: Paul
  • Sales Rep: Mary

The tricky thing here is that there is no direct connection between person and org unit. While this may be an easy fix for this example (just create a connection in the database between persons and org unit), I have other ideas for this type of filtering in which it would not be practical to connect the first and third element in the chain.

Thanks again for your help,

Stefan

0
by Alexia Economacos
Posted on Wed, 06/27/2018 - 09:47
Hello, Does anyone have an answer to Stefan's question? I am facing exactly the same issue. Thank you in advance Alexia
0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • Profile picture for user freddy
  • Profile picture for user mikhubb
  • Profile picture for user harryratia
  • DC
  • ВА
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock