If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Help with Hidden Prompts and applying data level security

Started by actcognosuser, 05 Nov 2019 12:35:14 PM

Previous topic - Next topic

actcognosuser

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}#

CognosPaul

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.

actcognosuser

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?

Andrei I

Can you filter Prompt Query for Local Offices Prompt by Logged User Region?

CognosPaul

Is the security filter only on the fact table? Try putting it on the region dimension too.

actcognosuser

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 .