Search for existing answers to your product and support questions.
Familiarize yourself with our support site and learn best practices in working with our team.
Manage Service Requests, View and update service requests submitted by you and others in your organization.
Submit a new issue to our technical support team.
Oracle B2C Service insights from our Technical Support team subject matter experts
Browse resources to assist you in launching your implementation and ensure a successful go-live.
Access your OCI account.
Find product documentation for supported versions of B2C and documentation libraries for related service solutions.
You will have the tools to improve your customers' experience when you learn about all the things our products can do.
Find links for API documentation, Custom Processes, Customer Portal, and Agent Browser UI Extensibility Framework.
Explore how accelerators are designed to demonstrate how an integration scenario could be built using the public integration and extension capabilities of the Oracle B2C Service.
Prepare for a successful transition by reviewing upcoming release changes and enhancements.
Explore webinars, events, and feature kits to learn about B2C Service features, functionality, and best practices from the technical experts.
Oracle MyLearn offers a portfolio of free and paid subscription-based learning resources to help you gain valuable skills, accelerate cloud adoption, increase productivity, and transform your business.
Empower your team with the skills to implement, configure, manage, and use your applications with Customer Experience Cloud Training.
Our goal is to facilitate a friendly, supportive environment where members can easily collaborate with each other on solutions and best practices.
Ask and answer questions specific to B2C.
This is an exciting resource intended to help with your Oracle Service Cloud Analytics.
Share product improvement ideas and enhancement requests with Oracle Development, while collaborating with other Oracle customers and partners.
Update your phone number, email notification preferences, and severity 1 and severity 2 contact preferences.
View the contact managers within your organization.
Find contact information of the Technical Account Manager (TAM) and Client Success Manager (CSM) for your organization.
Environment:
Analytics, Rollup Options Oracle B2C Service, All versions
Resolution:
You can define rollup levels in a report to group data beneath headings in the report. You can add additional rollup levels to further break down the data under each heading by grouping data under sub-headings. Using rollups, you can group rows in a report that share the same value in the columns you select for the rollup levels.
To add Rollups to a report, follow the steps below:
1. Create a new report, or from an open report, click the Home tab. 2. Click the Rollups button located in the Analyze section of the Ribbon. 3. Select Choose Columns to open the Rollups window. 4. Enter the following field information.
Select output columns from the drop-down menus in this section to use as the primary rollup level. Once you select a column, you can select the sort order for the rollup column. Options include Do Not Sort, Sort Ascending, and Sort Descending.
You can add additional columns to the primary rollup level in this section by selecting the columns from the other drop-down menus. When multiple columns are used in a rollup level, the data displayed together under the same rollup heading has the same values in all the columns selected for the rollup level.
Show Field in View
Select this check box to display the rollup column you selected as a column in the report. If this check box is not selected, the column name displays in the rollup heading, but is not included as a column in the report output.
Select output columns from the drop-down menus in this section to use as the secondary rollup level. Once you select a column, you can select the sort order for the rollup column. Options include Do Not Sort, Sort Ascending, and Sort Descending.
Secondary rollup levels break down the data in the primary rollup level according to the columns selected for the secondary level.
Once you define a secondary rollup level, an additional Then By field displays, allowing you to define a third rollup level to further break down the data grouped under the secondary rollup level.
Note: If records grouped under the secondary rollup have null values for the rolled-up field and if the rolled-up column is formatted to display blanks for records with null values, the header for the secondary rollup level does not display.
Select this check box to display the rollup headings and sub-headings. If this check box is not selected, the headings do not display, though the report data is still sorted as if the headings were present.
Display Rollup Headings Multi-Line
Select this check box to display each rollup column as a separate heading. If this check box is not selected when using multiple columns in the same rollup level, the columns for the rollup level display in the same heading.
Note: This check box is disabled if the Display Rollup Headers option is not selected.
Display Rollup Column Headings
Clear this check box to hide the name of the rolled-up column on rollup group headings. By default, the name of the column you roll up is displayed for each rollup group.
Select this check box to show the output column headers before each rollup heading and sub-heading. If this option is not selected, the column headers display only at the top of the report.
Select this check box to display the number of items under each rollup heading and sub-heading.
Select this check box to collapse all rollups in the report when it initially loads.
5. To remove the rollups you have selected on the Rollups window, click the Clear All button. 6. Click the OK button to generate the report using the rollups settings. 7. To remove rollups from your report, click the Rollups button and select Reset. 8. To display the number of records in each rollup, click the Rollups button and select Display Group Counts. 9. To show or hide headings for each rollup group, click the Rollups button and select Display Rollup Headings to enable or disable the option. 10. To show or hide the name of the rolled-up column in the heading for each rollup group, click the Rollups button and select Display Column Headings to enable or disable the option. 11. To show or hide repeating column headers, click the Rollups button and select Repeat Column Headings to enable or disable the option. 12. To collapse all the rollup headings in a report, click the Rollups button and select Collapse All. When viewing a report with rollup headings, you can click the minus or plus button next to each heading to collapse or expand the headings to hide or display the rows under the headings.