Skip to Content
0

Row security in the universe

Jun 08, 2017 at 06:58 AM

41

avatar image
Former Member

Dears,

Can you help us with the following query.This is just a scenario I would like to mention:

1)Table A has City and Delivery units.

2)Table B is a fact table with all the data based on delivery units. 3) We have joined A and B on delivery units 4) Row security is already defined based on a where clause on City 4) Object exists for table B and not for Table A 5)Now how can we ensure that whenever the Delivery unit is selected by the user in the report with other associated objects

(from Table B) it will be filtered based on the users association with the Groups and therefore the row security defined for the group. The confusion is if there is no object based on Table A how will the join condition on Delivery Unit be satisfied when I select objects from table B alone? Are we doing something wrong here?

Regards

Vaibhav

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Jun 08, 2017 at 07:50 AM
0

You can apply filter on Class B.create one filter like city is not null.in this filter properties check the checkbox apply on class.

After that if user select objects only from class B only still your join will work.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks amit. I am confused with another implementation in the universe(not developed by us). There is an object Delivery Unit mapped to associated column from table B. The LOV sql QUERY of this object has the where clause which joins table A.delivery unit=table B.delivery unit. I am not sure how an object can be created in this way?To test if i create an identical object and map it to delivery unit i can only see normal LOV query as" select distinct table B.delivery unit from table b". So not sure how can a where condition be defined in the lov?can you help?

Regards

Vaibhav

0