cancel
Showing results for 
Search instead for 
Did you mean: 

Column level security in a webi Report

Former Member
0 Kudos

Hello Experts!

I am going nuts on this. Please advise

I have 4 Individual reports based on four difference user roles.

Client do not want to maintain 4 different reports instead he want a single report but want to see only the data meant for specific role.

I am thinking of creating a dummy dimension in the universe level and then assign to a list of values with the business roles ( as I do not know how the business role is configured as of now ) and use that as the Prompt and capture it as User response.

I want to merge all these four reports to one and based on the userresponse, want to hide the additional columns,

Please advise, what would would be the best way to achieve this.

Thank you in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member207878
Active Participant
0 Kudos

Hi,

Please refer below thread, if it helps:

http://decisionfirst.files.wordpress.com/2013/03/column-level-security-with-idt.pdf

Cheers,

Sahil

CKnall
Explorer
0 Kudos

The PDF has another usecase and is not usefull for this scenario. I am facing the same problem as Rishi Ambavaram

Henry_Banks
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

If Business Security Profiles via Information Design Tool (IDT) don't satisfy you use-case, please could you expand on your requirements for implementing column-level security on objects by users and groups?


regards,

H