Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 56 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- 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