Skip to Content
0
Former Member
Feb 21, 2012 at 10:51 AM

BEx Analyzer workbook

131 Views

Hello,

I am currently working on creating cost centre reports which should be sent out to cost centre managers on a monthly basis.

For example: The cost centre report for the cost centre named ABC should be sent out to ABCu2019s manager every month.

I created a BEx query and mapped it to a workbook in BEx Analyzer. There are around 300 cost centres and what I did is, created a selection variable for cost centre n the workbook. So the cost centre managers can input their cost centre to see the report.

My concerns are:

a) Since I have put a selection variable for cost centre, anyone can view the report. For instance, cost centre report for cost centre XYZ can be viewed by cost centre manager of ABC. How do we restrict the cost centres to their respective cost centre managers?

For example, Cost centre report for Cost centre XYZ can only be viewed by its respective cost manager. No other cost centre managers should see it. How do we do this in Analyzer workbook?

b) Which is the best way to distribute this report?

We currently use a SharePoint website to share documents. If we upload the workbook to the SharePoint site, my understanding is that the user will have to open the workbook in BEx Analyzer to view the report. The users have to be trained to do it in this case and all of them do not have BEx Analyzer at the moment. So I guess uploading it to the SharePoint site is not a practical idea.

Please reply with your solutions

Thanks in advance

Edited by: suriyagayathri on Feb 21, 2012 11:00 AM