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