Sales Cloud Report Sharing Center

Sales Cloud Shared Reports

Topic

    Harshavardhan Konathala
    Reporting using Cascading prompts – Attainment Summary
    Topic posted March 22, 2019 by Harshavardhan KonathalaBlue Ribbon: 750+ Points, last edited March 22, 2019, tagged Account, Activity, Assets, BI Publisher, Business Plan, Business Plan Objective, Channel Account Manager, Channel Sales Manager, Chart, Competitors, Contact, Customer, Dashboard, Data Visualization, Deals, Employee, Enrollment, Forecast, Household, Reporting and Analytics, Resource, Sales, Sales Campaign, Sales Executive, Sales Manager, Sales Representative, Shared Reports, Trends, Users, Year 
    161 Views, 3 Comments
    Title:
    Reporting using Cascading prompts – Attainment Summary
    Summary:
    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.
    Content:

    Business Use Case:

    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.

    How to deploy:

    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)

    Implementation notes:

    1. The data fetched is for the selected Year, Participant Name, Unit of measure and Performance Measure.
    2. From R13 onwards, you are allowed to select multiple values to check the results .E.g. You can submit one year and all the period/participant vales to see how the responses compare on different parameters
    Version:
    Oracle Business Intelligence 11.1.1.9.0
    Image:

    Comment