BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Aug 23.

[Webi 4.x] Row level security - Bex Query and Mapping Table


 
Search this topic... | Search Web Intelligence... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Author Message
respana
Forum Member
Forum Member



Joined: 13 Jun 2018

Posts: 2



PostPosted: Wed Jun 13, 2018 8:46 pm 
Post subject: Row level security - Bex Query and Mapping Table

Architecture Basic Information:

SAP BusinessObjects BI Platform 4.2 Support Pack 3 Patch 10
Version: 14.2.3.2538

Information Design Tool 4.2
Build: 14.2.3.2538

BW: Release 730 SP 0010

Oracle Database 12c Release 2 12.2.0.1.0

Client Restrictions:
I can't use the BW security and can't create an SAP BW BICS client connection.

Hello experts, I have a requirement from a client to develop a webi report using a specific Bex query and on the other side a Mapping table on oracle with the structure containing users and product IDs needed to be filtered.

Which are the best recommendations to make this happen?

Thanks!
Rodrigo
Back to top
erik.stenson
Forum Enthusiast
Forum Enthusiast



Joined: 30 Jul 2012

Posts: 1293


flag
PostPosted: Thu Jun 14, 2018 4:46 pm 
Post subject: Re: Row level security - Bex Query and Mapping Table

probably set up a process to put the data from BW into oracle and then do your logic in oracle.

or may be able to create a multisource universe directly against bw tables (using relational connections )and oracle, this would bypass bex/bics
Back to top
respana
Forum Member
Forum Member



Joined: 13 Jun 2018

Posts: 2



PostPosted: Fri Jun 15, 2018 5:00 pm 
Post subject: Re: Row level security - Bex Query and Mapping Table

The first one to oracle is a good option, with the bics connection there's a ticket with sap, so at this point still is not an option.

Thanks for your response.
Rodrigo
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Web Intelligence  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0297 seconds using 17 queries. (SQL 0.0027 Parse 0.0009 Other 0.0261)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo