Workbooks

[Former Member]

Hello Prakash,

I have a problem with Workbooks.Can you advise me.

Here is the situation.I have end user with 4 roles.

1.General Role-It has general authorizations for the user and has S_RFC,S_TCODE,S_GUI,some authorizations for SPOOL and BACKGROUND JOBS, and

S_BDS_DS with values

ACTVT 03,30,

CLASSNAME--ALVLAYOUTTEMPLATES,BW_CATLOGS.

CLASSTYPE--BO,OT

2.General Menu Role for user.

3.BW MENU ROLE---it has queries and workbooks.

4.Authorization role for BW--has S_RS_AUTH

S_RS_COMP

S_RS_COMP1

S_RS_HIER

S_RS_ICUBE

S_RS_MPRO

S_RS_ODSO

and analysis Authorizations.

Problem is.

Now when user opens workbook and executes it the workbook is populated with newdata.

The user is able to delete the rows and save the work book.

Say when he opened workbook he has 10 rows.Now he deleted 2 rows and saved and closed the work book.

Now when he opens again he can see only 8 rows because he deleted 2 rows.When he executes workbook only 8 fields are populated.

Its security breach.Can you suggest me how to remove This SAVE option.

When he hits button save he gets option SAVE WORKBOOK AS.

SAVE WORKBOOK

SAVE WORKBOOK VIEW.

I want to restrict user with SAVE option.

NOTE:when i run query i get 10 rows .

But i execute workbook i dont get the 10 rows because deleted 2 rows.

I want to disable the user Either deleting the rows or saving the workbook.

This is all in BI 7.0..we are in the process of upgrading from BW 3.1 to BI 7.0.

Thanks,

Abhiram

[Former Member]

Abhiram,

Remember BEx reports are Excel Sheets, so if a row or column is deleted and this workbook is saved you cannot retrieve it back when you open it up again. Now what you can do is set the workbook to refresh when it is opened, then the result cells are automatically repopulated. This means the deleted cells will be populated again (provided this data still exists in the provider). This automatic refresh flag can be set in the 'Workbook Setting' (button on the BEx Toolbar) under the 'General' tab 'Refresh Workbook on Open'.

Also, using BI security you can prevent users from saving workbooks in BI roles but you cannot prevent users from saving BEx workbooks on their own machine.

Regards,

Rohit