For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
To implement this requirement we have to make a couple of table joins from FA side which was not implemented as of now.
Customers which are importing sales data into IC and creating reports from them we have to provide a solution with FA database tables join like below:
Need to consider the participant's data directly from the database, so that we can cross-compare the same when implemented in OTBI.
SALES DATA with PARTYID as main columns followed by all the main dimensions columns BASE ID values, FOR IC data, we have participant ID for the equivalent PARTYID columns followed by all the base dimensions columns BASE ID values. Please refer to attached Mockups
Points to note - We have to make the join between PARTID from sales and PARTYID from IC.
Mandatory Join, We have to join ORDER_ID from sales and TRANSACTION_ID from IC. Because functionally OREDR_ID = TRANSACTION_ID. I.E. SALES REPS who are making orders, only those are considered as TRANSACTIONS in IC. Hence we have to consider this joins for PROPER reporting data.
REPORT WITH BOTH SALES AND IC ATTRIBUTES -
Final Dashboard - Entire Prototype built on Oracle Data visualization Desktop Tool.
1) Credit AMOUNT calculated based on the SPLIT PCT for each transaction handled by the participant.
2) SPLIT PCT was given if two participants involved in one single transaction.
3) Earning AMOUNT will be 5% of the credit amount.
4) Transactions with status "CREDITED" are only considered for credit amount calculations
5) Similarly credits with status "Credited" are only considered for earning calculations.
Attainment Ranking & Summary
Subject Areas used – IC Performance & Earning Summary
Who can use this report (Roles) - Incentive Compensation Manager/ Analyst/ Sales Representative
The below dashboard is a sample implementation that shows how the Performance and Earnings Summary Subject area can be used to report metrics related to payment recovery.
This report is designed for the benefit of an Incentive Compensation Manager and/or an Incentive Compensation Analyst to help them understand the advance amount recovered and also the advance to be recovered based on ITD and PTD calculations so that the payments can be adjusted as required. Further, the Subject Area has been enhanced to support reporting of comp plan assignment types (Direct/Role-based) and also whether the participant’s incentive has been customized at a comp plan level.
All these enhancements are available from 19D onwards.
Quarterly Recovery Amounts by Participant:
A WAVE view provides info about all the recovery amounts by the participants against the target by Quarter.
You can move to each quarter by the using slider to move between quarters.
Period wise Recovery Amounts by Participant:
A bar chart provides info about all the recovery amounts by the participants against the target by each period. You can move to each quarter by the using slider to move between quarters.
Hi,
We have implemented the Sales rep Kanban report to show the Sales stages for various opportuntines. For some of the users its displayed fine where as for some of the users the top section is missing.
Do we need any setup for this Kanban report to display correctly
Thanks,
Prakash
Hi,
We have implemented the Sales rep Kanban report to show the Sales stages for various opportuntines. For some of the users its displayed fine where as for some of the users the top section is missing.
Do we need any setup for this Kanban report to display correctly
Thanks,
Prakash
Attainment Summary
Who can use this report (Roles) - Incentive Compensation Manager/ Analyst/ Sales Representative
Cascading prompts is a feature that is liked by many customers because it allows them to have a preview of their data through prompts before actually seeing the data.
Most of the times customers want to do themselves a cascading report, the below example will show how to do the cascading within the report and you can select only required values.
Example: In the below report we have four prompts “Year”, “Participant”, “Unit of measure”, “Performance Measure”.
Cascading prompts will work by showing the results of the second prompt followed by the values you selected in the first prompt and goes on.
I.e. participant prompt values will show based on what year you selected, and performance measure will show values based on which participant and year we selected.
We can do this by selecting whichever prompt values we wanted to cascade and then go to edit section selecting more options and choosing “limit Values By”.
We can follow the same process for all the prompts which are needed to include as cascading.
Year wise participant list:
We have selected the year 2018 and all the participants involved in 2018 only will be listed.
Year, Participant wise performance measure:
We have selected the year 2016 and Participant as “Allison Flores” and only related performance measure values are showing up.
Without this change, you will end up seeing all the participants’ data irrespective of year and seeing all performance values irrespective of year and participant selected.
Un-archive “Attainment Summary.catalog” files which have all the individual report, dashboard prompt, and the dashboard.
Ensure that you un-archive it under /shared/custom folder to retain the references that the dashboard has to those individual files (else you may correct those again in the dashboard)
Hi Community,
i need your help please on a BI-Reporting subject within Sales Cloud R13-18C.
Here is the scenario: i created a report based on Accounts and their opportunities, which are showing basically 2 axes (X= Opportunity Status which may be Lost, Won or Open), then Y= Expected revenue, which is the expected volume by Opportunity)
The report will be embedded as Mqshup content link within a sub-Tab in the Accounts (means within an account, you have several sub-Tabs, like contacts, opportunities, relationships etc...and i added another sub-tab called analysis, which will open this BI report.
All this works perfectly fine, but the rerport shows all volumes bases on the 3 statuses (open/lost/won) and is not filtered on the current account. Can somebody please help on how to go about it?
I need the report to trim values and show only those related to opportunities of the current account, where i've the sub-tab opened. When i select another one, it should be showing values of the second one..etc.
Manny thanks in advance and best regards
Nawfal El Hannoun
What is the Change?
Prior to R13.19A, BI Administrator has the privilege to create and run Direct Database Query in BI Answers. In R13.19A, this feature has been disabled by default. Specifically, two privileges that control direct database query access, namely ‘Edit Direct Database Analysis’ and ‘Execute Direct Database Analysis’, have been denied for authenticated users.
Reports created with ‘Direct Database Query’ option prior to R13.19A will receive a system error when executed in R13.19A. To prevent the system error, customers can revert the R13.19A privilege changes by granting BI Administrator privilege to both ‘Edit Direct Database Analysis and ‘Execute Direct Database Analysis’.
Please note: This change does not affect BI Publisher SQL reports created with BI Publisher Data Model or BI Answers reports created with Logical SQL.
How to revert the change?
BI Administrator can modify direct database analysis privileges in BI Administration -> Manage Privileges page. To grant BI Administrator access to direct database query, customers can remove ‘Authenticated User’ that has ‘Denied’ permission from the seeded privileges and add a new role of ‘BI Administrator Role’ with ‘Granted’ permission.
Repeat the same step to grant ‘BI Administrator Role’ to ‘Execute Direct Database Analysis’ privilege.
Future Product Direction
Direct database query is not a supported OTBI feature for building reports. Customers are encouraged to use BI Answers to create interactive analyses, use BI Publisher for fixed-format reports and use BI Cloud Connector (BICC) for data extraction. If customers have created OTBI reports with Direct Database Query option, Oracle development strongly recommends migrating those reports to use OTBI subject areas as Direct Database Query will be deprecated in OTBI in 12 months.
Please refer to attached document for more detailed information. If you have further questions, please contact Oracle Support.
Subject Areas used – IC - Earnings Real Time, IC - Credits Real Time, IC - Transactions Real Time
Who can use this report (Roles)? - Sales Manager/ Incentive Compensation Manager/ Sales VP
The following report is a managers view of his team's targets, earnings, and attainments from Incentive Compensation
Note:
All the below dashboards, reports are made based on the Oracle standard diction on formatting and layouts
Users are allowed to download the .catlog file and make their own customizations.
This e-mail is sent by Oracle OTBI product management.
Starting with Release 13.18.10, a brand-new OTBI Help landing page is available -> https://docs.oracle.com/en/cloud/saas/business-intelligence/index.html. From an OTBI 18.10 instance (or a later release), users can click on the ‘OTBI Help’ link in Answers and launch the OTBI Help landing page. This page is a quick launch pad to relevant OTBI help documents – subject area guide, data lineage, report list and OTBI product Help. Users can also book mark the OTBI Help landing page and launch it directly from a browser. The OTBI Help landing page will save users from having to go to different places to locate OTBI help.
The subject area guide is a new tool that gives users helpful information on how to use a subject area, related business questions, and security roles. The hyper-linked subject area guide replaces the subject area description spreadsheets that OTBI product management have published in Customer Connect.
We welcome your feedback on the new OTBI Help landing page and suggestions on improving OTBI help and usability.
As a Sales Manager, I want to see the negative reporting data i.e.
Negative Reporting:
Since the dashboard here has all the reports that shows the data in a negative context, it is aptly named as negative reporting dashboard.
This dashboard is an example of how a negative report can be created with few examples.
Essentially, to create a negative report, following high level steps are to be performed:
Let’s take a simple case where we want to see all the Accounts without any Activities
Step 1: Get the list of all the accounts (A)
Step 2: Get list of the accounts with activities (B)
Step3: A – B will give us the list of all the Accounts without activities
Thus to create such a report, we need to use a SET operation (MINUS).
The Catalog file attached here has a dashboard that essentially uses the same principle above for each of the reports and it shows –
Please find the complete observations and current standings –
The entire idea of building this prototype is to provide a reporting solution which has both SALES and IC metrics.
The current model doesn’t support continuous reporting from sales to IC, hence to achieve this we want to integrate common dimensions shared across both the pillars i.e. joining both the pillars data using employee resource hierarchy from sales and participant hierarchy from IC. Similar to the partner dimension project.
By considering the above assumption we have started building the prototype by using SALES mockup (The one used for all the SALES POCS) and IC mockup(One we built completely new).
Sales mockup flow “Campaign-Lead-Opty-Order”, IC mockup flow “Transaction-Credit_earning-Payment”.
Joins established to build the prototype are SALES.PartyID = IC.PartyID and SALES.OrderID = IC.TransactionID.
Pointes to Note:
Entire data model and dashboard was completed by considering above joins.
Current joining flow is “IC → Resource Hierarchy → SALES”, from the current FA model we were able to identify the joins to link IC facts to resource hierarchy dimensions(PFA FA tables screenshot).
Whereas we are encountering trouble finding the joins to resource hierarchy → sales facts. Because in the current model Order details are coming from ORDER management and SALES data ending with Opportunity data.
using Order_num from transactions table we can join IC data with Order management data but later from order management to SALES Oppty, we don't have proper joins to establish.
There are no proper joins to get SALES Oppty data and SALES facts to build the solution at RPD level.