Categories
- All Categories
- 121 Oracle Analytics News
- 21 Oracle Analytics Videos
- 14.4K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 8 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Configurable Security Context - There should be option to have OR or AND clause.
Configurable Security Context - As per current design it shows all combinations of cost center and balancing segment. But customer is requesting for the feature where user can see only cost center and only balancing segments which are assigned to user
for eg:
If we assigne Balancing Segment 403 and Cost Center 000
Then report puts 'OR' clause.
(T424140.SEC_OBJ_CODE in ('35e037ab-55e4-4c1e-a27a-dc383453d97e') or T424141.SEC_OBJ_CODE in ('786d822f-7da1-4864-93d6-268a93e622fe')) )
Due to this we get all combinations. Customer is expecting only assigned cost center and balancing segment.
So, there should be 'AND' clause instead of OR.
Answers
-
If you specify the same functional group name for both custom security contexts you created, the data filters will be combined using the OR operator. If you need an AND operator between the data filters, you must specify a different functional group.
1 -
Different functional group means? where should I create, kindly elaborate this. I have created two contexts. one for balancing segment and another for cost center.
0 -
Thank you for this solution. This worked.
0