Enabling Multi Organization Reporting

The multi organization reporting is not enabled by default and can be enabled by altering the new view added in Personify 7.4.2 “BO_Psm_Org_Unit_Member_VW “

Alter the above view by commenting the following lines in the view:

select Bo_User,User_Id,Org_Id,Org_Unit_Id  

from dbo.PSM_ORGUNIT_MEMBER  

and un-comment the following lines of code in the view:

select a.Bo_User,b.User_Id,b.Org_Id,b.Org_Unit_Id  

from dbo.PSM_ORGUNIT_MEMBER a, dbo.PSM_ORGUNIT_MEMBER b  

where a.user_id = b.user_id  

So the modified view should look as follows:

alter view [dbo].[BO_Psm_Org_Unit_Member_VW]    

AS(    

--select Bo_User,User_Id,Org_Id,Org_Unit_Id  

--from dbo.PSM_ORGUNIT_MEMBER  

--<<Comment the above two lines and un-comment the below three lines for multi ORG support>>  

select a.Bo_User,b.User_Id,b.Org_Id,b.Org_Unit_Id  

from dbo.PSM_ORGUNIT_MEMBER a, dbo.PSM_ORGUNIT_MEMBER b  

where a.user_id = b.user_id  

)

Now execute the view. The results of the view has all the business objects users with data for all the org/org units they have access to. The universes and reports are configured to look at the view for the logged in users org/org unit information, thereby allowing multi organization reporting.