URGENT - BW Security for Web Templates

[Former Member]

Hi All

I am relatively new to BW and am just putting my first major BW project live. I have just been told something by my colleague which seems strange to me, can anyone confirm or give me a workaround?

I have a number of Web Templates set up which use common Bex Queries as Data Providers (so two separate Web Templates may use the same query as Data Provider).

We are looking at Security settings, where one of these Web Templates is available to one user but not to another.

My colleague tells me that it's not possible to restrict authorization on webtemplates. Instead I have to duplicate my queries and have each web template using a different query so we can restrict security by query!!!!

Now that to me seems daft....it just increases the maintenance hugely because instead of changing a single query I now have to change multiple queries which are all copies of the same one.....just because BW can't handle security at Web Template level?

Is this true? Anybody got a workaround?

[Ashwin · Accepted solution]

Hi!

Actually I am not much aware of security in the area ow web templates.

But in general we dont need to hava separate query for the each user for restricting him/her to view some specific content. BW allows you to restrict the user access the data thats related to only specific parts of the hirarchy, or to only some part of the masterdata. for example we can restrict the user to access the data that related to the cost center he is responsible for or data that is belonging to his relavant customers. So even though user can acess the web template we can restrict the acess to the content that is visible to the user.As yóu have not given any specific details of the requirement like difference beetween templates and so on..i cant say how to set the authorizations.

with regards

Ashwin

[Former Member]

In our BW implementation, we manage security with roles. Users with a certain role would only have access to web templates that have been published to that role.

Our users view their roles via the portal, but if you don't have EP, you can use the Role Menu web item in a template.