Hello Users,
I have a report that has data level security built on Call Center Regional Office. When report is run using this regional office code and date parameters it runs fine with prompt displaying only the region that USer belongs to.
The requirement is to display Local office and not not Regional center.(But local office prompt should be populated with the user based region )
example :
Region ARC has Local office -Arc A
Arc B
Arc C
Region ADD has Local Office ADD1
ADD2
ADD3
when a user from Region ADD logs in , he should only see Date Selection and ADD1, ADD2, ADD 3 populated for local office.
Currently using a prompt page with Date, Region and Local office prompt.
How do i Implement this without cascading the region prompt?
this is the parameter map used to assign data level security in FM
#$[Region Security]{$account.personalInfo.userName}#
If I understand, when the user runs the report it should be filtered specifically to his user and a prompt should be visible showing the local offices.
Easiest way to do this would be to add the filter to the local officer query.
[Namespace].[Table].[Region] = #$[Region Security]{$account.personalInfo.userName}#
Is there any reason that filter can't be applied in the framework model? If it's set using a data security filter, you won't have to worry about setting the filters on each query in your report.
Thank You Paul. This filter is already set in Framework Manager and security works fine.
The challenge is User needs to see the local offices of the region he belongs to without displaying the Region prompt.
How do we pre populate the local office prompt based on users region?
If he belongs to Region 1, when the report is run he only needs to see local offices pertaining to that region and not all regions.
Does this make sense?
Can you filter Prompt Query for Local Offices Prompt by Logged User Region?
Is the security filter only on the fact table? Try putting it on the region dimension too.
Thank You Paul. Adding the local office to Query Subject which has Region Security , worked.
Now it only displays local offices belonging to that Region .