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