PDQs with me and my Team members

Ever wondered how the Siebel team views are solved. Using the generate reporting relationship it creates a de-normalized table with all the reporting relationships and use this as a based to perform a query. Similar to siebel, we can do a dynamic search in CRM 2011 to perform a me and my team members query.

PDQ with team members

As you can see in the query above, you can filter first based on current users team. For this you start with normal search spec and then select the owning user entity and then it's team and set the "Is standard" option to false and select its users entity and set the user like current user.

1. Owning user

2. Team - Set "Is standard" to No

3. Users - User like "current user"

Note:. This is a performance instensive query. Use with caution.

For Manager views, use the below query
1. Owning user
2. Team - Manager like current user

Note: This is a manager only view. Comparitively the performance is great with this query.

My View and My Teams View in CRM 2011

Hi,

I have been working with Siebel CRM before and I have been pretty much used to My Views and My Teams views in Siebel. (Position based visibility on records)
We used to have position (team) owned entities like Account, Contact, Opportunity and user owned entities like Activities and SR. Also in case of activities and service request quite often we need to look into your teams activities and teams requests. Although they are user owned entities in Siebel, we used the reporting logic to display this managerial view.

Similarly if we want to achieve a similar kind of functionality in CRM 2011, it's quite simple.

Use the advanced query editor to define the query as below.
Select the owner as the current user OR equal to the current user's teams

Also if you have used Siebel, when you are in Activities view, you will also see a view called "My Contact's activities" or "My Company's Activities". We can achieve the same in CRM 2011 as below. This is quite a powerful feature.

Note: Since these queries are resource intensive use with CAUTION. Use other filter conditions to filter more records. For example, I have used to filter only open activities.

See the next episode here