A Appendix: Roles and Permission Grants
Application roles control access to metadata objects, such as subject areas, tables, and columns. For example, certain Retail Insights Cloud Service roles may not have access to view certain presentation tables. Metadata object security is configured in the Oracle BI Repository, using the Oracle BI Administration Tool. The Everyone user group is denied access to some of the presentation tables and only related roles have explicit read access. This access can be extended to subject areas and columns.
Note:
By default in Oracle Analytics, only Retail Insights Cloud Service permissions at the presentation tables and dashboard level have been configured. Dashboard permissions are not specific to business roles, but rather they are hidden from normal business users to prevent confusion over base content versus custom content.
Roles and Permission Grants
The following table shows the dashboards that are accessible for the specific roles assigned to a user. A user can have more than one role assigned to them; the role permissions are additive.
| Presentation Table(s) | AltHierarchy Insights | Consumer Insights | Customer Detail Insights | Customer Insights | Customer Loyalty Insights | Customer Order Insights | Customer Segment Insights | Employee Insights | Flex1 Insights | Flex2 Insights | Flex3 Insights | Flex4 Insights | Franchise Insights | Inventory Insights | Planning Insights | Promotion Insights | Purchase Order Insights | RIApplication Administrator | Sales Insights | Science Insights | Supplier Insights | Tender Insights |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Allocation |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Business Calendar |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Buyer |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Category Management Group |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Clearances |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Clusters |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Comp Store |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Consumer |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Consumer Segment |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Coupon |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Customer |
No |
No |
Yes* |
Yes* |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Behavior |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
|
Customer Household |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Loyalty Account |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Loyalty Activity |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Loyalty Award Activity |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Loyalty Program |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Order |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Order Fulfillment |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Order Origin Channel |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Order Promotion Transaction |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Order Status Fact |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Order Submit Channel |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Order Tender Type |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Order Transaction |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Segment |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Segment Allocation |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Customer Segment Loyalty Score |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Employee |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Error Administration |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
Yes |
No |
No |
|
From Organization |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Fulfillment Organization |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Gift Card Sales |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
|
Gregorian Calendar |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Inventory Adjustment |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Inventory Position |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Inventory Receipts |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Inventory Transfer |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Inventory Unavailable |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Item |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Markdown |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
|
Market Item |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Net Cost |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
|
Net Profit |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
|
Organization |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Organization Customers |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Plan1 |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
|
Plan2 |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
|
Plan3 |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
|
Plan4 |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
|
Plan Forecast 1 |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
|
Plan Forecast 2 |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
|
Pricing |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
|
Product Org Attributes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Promotion |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
|
Promotion Actuals |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
|
Promotion Baseline |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
|
Promotion Budget |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
|
Promotion Forecast |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
|
POS Sales |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
Yes |
No |
No |
|
Purchase On Order |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
|
Purchase Order |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
|
Purchase Type |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Reason |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Related Item |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Retail Discount Type |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Retail Flex Fact 1 |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Retail Flex Fact 2 |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Retail Flex Fact 3 |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Retail Flex Fact 4 |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Retail Sales Promo Trx ID |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Retail Transaction Code |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Retail Type |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Retailer To Franchise |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Return To Vendor |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Sales |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
|
Sales Consignment |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
|
Sales Extension |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
|
Sales Discount |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
|
Sales Pack |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
|
Sales Promotion |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
|
Season Phase Planning |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Selling Organization |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Shipment Method |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Shipment Type |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Status |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Stock Count |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Stock Count Perpetual |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Stock Count Systemic |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
|
Stock Ledger |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
No |
Yes |
No |
No |
No |
|
Store Traffic |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
No |
|
Substitute Item |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Supplier |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
|
Supplier Compliance |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
|
Supplier Invoice |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
|
Tender Type |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
|
Time of Day |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
Yes |
|
Touch Point |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Trade Area |
Yes |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Transaction Tender |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
|
Transfer Status |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
Yes |
No |
No |
No |
No |
No |
|
Transfer Status Detail |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |
No |
Yes |
No |
No |
No |
No |
No |
|
Trial and Repeat |
No |
No |
No |
Yes |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
|
Unit Cost |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
No |
Yes |
No |