Skip to Content
0
Former Member
Oct 27, 2009 at 11:22 AM

SAP BO WebI Report on top of BI Bex Query with Authorization Variable

127 Views

Hi,

We are trying to restrict row level data using BI 7.0 analysis authorization concept. We have an authorization variable in the Bex query and is working perfect in Bex Analyzer as well as in RSRT.

Now we are trying to achieve the same thing in BO webI. We created an Universe using Authentication Mode SSO. We are on BOXI 3.1 and implemented SSO. When we try to run the query in WebI we get the error

"A database error occured. The database error text is: Error in MDDataSetBW.GetCellData..(WS 10901)"

Just for testing purpose, when we use query filter in WebI and use Values from List, it is showing only the authorized value it supposed to show and runs well with that value selected. But we have to achieve this without the query filter in WebI.

So are we missing some thing here or any patch issue? Please share if you have done this type of reports in BO.

Thanks in advance for your help.

Moorthy.