Skip to Content
0
Former Member
Aug 07, 2012 at 08:11 AM

Help with Unx over Relational Connection, with SSO & BW Authorizations

39 Views

dear all,

i seem to be cornered.

I am sourcing data from an SAP BW 7.3 to my BI 4.0 SP4 (Feat Pk 3)

after realizing BICs data source does not handle drill downs in webi, i was given the option to create a hierarchical model for the drill down, or use a universe. I am trying with a universe, using the IDT.

i have created my BW "relational connection", built the "foundation" and the consequent "universe". here i managed to build my custom scope of analysis for my drill down. all works well and running a test query is good.

when used the universe for my webi, i realized i needed to pass a parameter to the universe as i was using SSO, and need to filter the data appropriate to the user. here is where the problem starts.

unlike BICs where i can use a query, and an authorization variable, with a relational connection, i cannot access anything other than cubes, dso's, and characteristics. it seems i cannot access queries. AM I RIGHT IN THINKING THIS ?

if so, how can i implement SSO security, ultimately to the source of the relational connection. in my case, it is a multi-provider.

thanks in advanced

g