Skip to Content
0
Former Member
Apr 10, 2007 at 07:41 PM

BI - Portal Design?

22 Views

Suppose i have 13 queries which is from different application areas - FI , CCS , EAM

Now this application areas are further divided into sub area like:

FI - CC/PCA , GL , Consolidation.

CCS - Billing , Back Office

EAM - Service , Regulatory

Now assuming these 13 queries are in these different sub-areas

CCA/PCA - Query1

GL - Query2 , Query3

Consolidation - Query 4 , Query 5 , Query 6

Billing - Query 7 , Query 8

Back Office - Query 9

Service - Query 10 , Query 11

Regulatory - Query 12 , Query 13

Now assume that there are 2 users A and B.

Now user A has access to the below mentioned :

FI -CCA/PCA - Query1

FI -Consolidation - Query 4

CCS - Billing - Query 7

Now the approach i was thinking of was to create Roles in the PCD for the Application area and Sub areas,

For Eg : FI Role , CC/PCA Role , GL Role , Consolidation Role.

Also create ivews in PCD for all the Queries and then assign these Ivews to the respective sub areas and then these sub area will be delta linked to the Application Areas. Now the problem is if i take this approach and i assign a specific role to the end user in PCD he/ she will be able to see all the queries that are assigned to that role even though he/ she is suposed to just see 1 query instead of 2 queries which he is authorized to run in the back end BI system(PFCG) as in the example above for user A.Is there any other approach i can take to do this restrictions.We are on BI 7.0-SP 11, EP 7.0 and we plan to use the federated approach.