I have a requirement where the skin of the users should change depending on their Roles/Groups , In obiee we can implement multiple skins and pass them using session variable 'Skin' for a given user based on thir group.
Implement an initialization block to assign skin session variable:
Verificaition using session manager:
Front end:
Implement an initialization block to assign skin session variable:
Verificaition using session manager:
Front end:
Currently, we've
ReplyDeleteSELECT USER_STYLE FROM USER_SKIN_STYLE
WHERE upper(USERNAME)=upper(':USER') , where,
‘:USER’ retrieves logged on username
USERNAME refers to table column
Can you please tell me , how can I modify this sql such that, I get the custom skin based on User Group ? and at the sametime it should check for Username as well..
Thanks!