IP Library Granted Patent US 12,282,985
Granted Patent B2
US 12,282,985 · App. 18/062,256 · Granted Apr 22, 2025

User selectable dimension ungrouping for enterprise cloud analytic charts

Inventors: Robert Wilkie (Vancouver, CA); Gloria Law (Vancouver, CA); Yue Qian Huang (Vancouver, CA)
Assignee: SAP SE
G06T11/206G06F3/0482G06F16/26G06T11/001H04L67/60G06T2200/24
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 12,282,985
App. No.
18/062,256
Granted
Apr 22, 2025
Kind
B2
Abstract

An analytic chart data store may contain an enterprise information data structure, based on a result set received from a back-end application computer server, and a user selectable dimension ungrouping indication. The enterprise information data structure may include: an outermost dimension arranged on a row axis; an innermost dimension arranged on the row axis; and measure values arranged on the row axis. A computer processor of an analytic chart creation platform may determine that the user selectable dimension ungrouping indication is set to “ungroup.” Responsive to said determination, the analytic chart creation platform may automatically re-organize the enterprise information structure such that the innermost dimension information is arranged on the column axis instead of the row axis. The analytic chart creation platform may then automatically create an analytic chart and transmit the chart to a remote user device.

Claims (44)

1. A system associated with cloud-based enterprise analytics, comprising:

an analytic chart data store that contains an enterprise information data structure, based on a result set received from a back-end application computer server, wherein the enterprise information data structure includes:

an outermost dimension arranged on a row axis,

an innermost dimension arranged on the row axis comprising an enterprise color feed, and

measure values arranged on the row axis; and

an analytic chart creation platform coupled to the analytic chart data store and including:

a computer processor, and

a memory storage device coupled to the computer processor and including instructions that, when executed by the computer processor, enable the analytic chart creation platform to:

determine that a user associated with a remote user device is accessing a context menu,

automatically provide an “ungroup” option on the context menu to the user if, and only if, both (i) a chart type supports a sort or rank operation, and (ii) there is at least one dimension in the color feed that is not duplicated in other dimension type feeds,

responsive to the user selecting the “ungroup” option, automatically re-organize the enterprise information structure by adjusting a query to the back-end application computer server such that the innermost dimension information is arranged on the column axis instead of the row axis,

automatically create an analytic chart based on the re-organized enterprise information data structure, and

transmit the created analytic chart to the remote user device via a distributed communication network.

2. The system of claim 1 , wherein the analytic chart creation platform subsequently determines that the user has now selected a “group” option and again re-organizes the enterprise information data structure such that the innermost dimension information is arranged on the row axis instead of the column axis.

3. The system of claim 1 , wherein the analytic chart creation platform performs a sort operation on the re-organized enterprise information data structure.

4. The system of claim 1 , wherein the analytic chart creation platform performs a rank operation on the re-organized enterprise information data structure.

5. The system of claim 1 , wherein new analytic charts have the user selectable dimension ungrouping indication automatically set to “ungroup”.

6. The system of claim 5 , wherein the user can suppress the automatic setting of the user selectable dimension ungrouping indication to “ungroup”.

7. A computer-implemented method associated with cloud-based enterprise analytics, comprising:

accessing, by a computer processor of an analytic chart creation platform, an analytic chart data store that contains an enterprise information data structure, based on a result set received from a back-end application computer server, wherein the enterprise information data structure includes:

an outermost dimension arranged on a row axis,

an innermost dimension arranged on the row axis comprising an enterprise color feed, and

measure values arranged on the row axis;

determining that a user associated with a remote user device is accessing a context menu;

automatically providing an “ungroup” option on the context menu to the user if, and only if, both (i) a chart type supports a sort or rank operation, and (ii) there is at least one dimension in the color feed that is not duplicated in other dimension type feeds;

responsive to the user selecting the “ungroup” option, automatically re-organizing the enterprise information structure by adjusting a query to the back-end application computer server such that the innermost dimension information is arranged on the column axis instead of the row axis;

automatically creating an analytic chart based on the re-organized enterprise information data structure; and

transmitting the created analytic chart to the remote user device via a distributed communication network.

8. The method of claim 7 , wherein the analytic chart creation platform subsequently determines that the user has now selected a “group” option and again re-organizes the enterprise information data structure such that the innermost dimension information is arranged on the row axis instead of the column axis.

9. The method of claim 7 , wherein the analytic chart creation platform performs a sort operation on the re-organized enterprise information data structure.

10. The method of claim 7 , wherein the analytic chart creation platform performs a rank operation on the re-organized enterprise information data structure.

11. The method of claim 7 , wherein new analytic charts have the user selectable dimension ungrouping indication automatically set to “ungroup”.

12. The method of claim 11 , wherein the user can suppress the automatic setting of the user selectable dimension ungrouping indication to “ungroup”.

13. A non-transitory, computer readable medium having executable instructions stored therein that, when executed by a computer processor cause the processor to perform a method associated with cloud-based enterprise analytics, the method comprising:

accessing, by a computer processor of an analytic chart creation platform, an analytic chart data store that contains an enterprise information data structure, based on a result set received from a back-end application computer server wherein the enterprise information data structure includes:

an outermost dimension arranged on a row axis,

an innermost dimension arranged on the row axis comprising an enterprise color feed, and

measure values arranged on the row axis;

responsive to the user selecting the “ungroup” option, automatically re-organizing the enterprise information structure by adjusting a query to the back-end application computer server such that the innermost dimension information is arranged on the column axis instead of the row axis;

automatically creating an analytic chart based on the re-organized enterprise information data structure; and

transmitting the created analytic chart to the remote user device via a distributed communication network.

14. The medium of claim 13 , wherein the analytic chart creation platform subsequently determines that the user has now selected a “group” option and again re-organizes the enterprise information data structure such that the innermost dimension information is arranged on the row axis instead of the column axis.

15. The medium of claim 13 , wherein the analytic chart creation platform performs a sort operation on the re-organized enterprise information data structure.

16. The medium of claim 13 , wherein the analytic chart creation platform performs a rank operation on the re-organized enterprise information data structure.

Assignments (1)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 6, 2022
From: WILKIE, ROBERT; LAW, GLORIA; HUANG, YUE QIAN
To: SAP SE
Reel/Frame 061995/0872 →
Continuity (1)
Related Publication 20240185489A1 · Jun 6, 2024
References Cited (8)
US 10956989B2 · Baker · 2021 [cited by examiner]
US 11301811B2 · Marom · 2022 [cited by examiner]
US 20060112123A1 · Clark · 2006 [cited by examiner]
US 20110310112A1 · Zolotovitski · 2011 [cited by examiner]
US 20210342399A1 · Sisto · 2021 [cited by examiner]
Mahajan KN, Gokhale LA. Advanced charting techniques of Microsoft excel 2016 aiming visualization. International Journal of Computer Sciences and Engineering (IJCSE). 2019;7(1). [cited by examiner]
Hora JM, Kronz A, Möller-McNett S, Wörner G. An Excel-based tool for evaluating and visualizing geothermobarometry data. Computers & geosciences. Jul. 1, 2013;56:178-85. [cited by examiner]
Excel Board, How to Create Multi-Category Chart in Excel, Jun. 14, 2017, https://www.youtube.com/watch?v=cozNbt5HhZ4. [cited by examiner]