Skip to Content
0
Former Member
Apr 14, 2010 at 09:40 AM

Authorization in SAP BO for the webi built on universes from Bex Query

121 Views

Hi,

Can anyone please guide me regarding authorization in SAP BO for the webi built on universes from Bex Query.

I am having the authorizing variable (Plant) in Bex Query in characteristic restriction and Rows block.

When i am creating a webi from universe built from bex query with all the dimensions available in rows and column section of Bex, with admin user (BO ADMIN)(access rights, Admin in BO & SAP_All in SAP BW), the report runs fine and gives data across all the plants for BOADMIN user.

But when i try to view and refresh the same report for BOTEST user(access to 2 plants in SAP BW end and View On Demand access to the report in BO), the report throws an error prompt "Error in MDDataSetBW.GetCellData(WIS 10901)" . Instead, when i put the authorizing variable (Plant) as a prompt in condition section of edit query tab, the report runs fine for BOTest User.

Is it necessary to put the authorizing variable in condition section as a prompt....

Pls help....i have already posted some queries regarding this but can not resolve the error i receive...

regards,

Akhil