RANGE AND PATTERN SELECTION IN REPORTING SOLUTIONS RELATED TO ANALYTICAL MODELS
Various embodiments of systems and methods for range and pattern selection in reporting solutions related to analytical models are described herein. Selection of range of values or pattern selection is performed and then the values are transformed to a list of single variables known to the underlying online analytical processing system.
1 . A computer implemented method comprising:
receiving a user entry of one or more identifiers (IDs) as a range of ordered values for querying data and generation of analytical result, the one or more IDs being external representation of one or more universally unique identifiers (UUIDs);
analyzing the one or more IDs to extract a list of non-ordered UUIDs, the list of non-ordered UUIDs being internal representation of the one or more IDs;
passing the extracted list of non-ordered UUIDs to an Online Analytical Processing (OLAP) processor; and
selecting data, through the OLAP processor, using the list of non-ordered UUIDs for the generation of the analytical result.
2 . The method of claim 1 , wherein the IDs are human readable IDs.
3 . The method of claim 1 , wherein the one or more UUIDs are used as keys of business object instances.
4 . The method of claim 1 , wherein the one or more UUIDs are used to model references between business model instances.
5 . The method of claim 1 , wherein analyzing the one or more IDs to extract the list of non-ordered UUIDs further comprises pre-querying a master data Multidimensional View (MDAV), the master data MDAV maintaining ID-UUID mapping.
6 . The method of claim 1 , further comprising filtering the data selected through the OLAP processor using a predefined filter.
7 . The method of claim 1 , wherein selecting, through the OLAP processor, data using the list of non-ordered UUIDs further comprises selecting the data from a transactional MDAV.
8 . A computer system including at least one processor for executing program code and memory, the system comprising:
a user interface to receive a user entry of one or more identifiers (IDs) as a range of ordered values for querying data and generation of analytical result, the one or more IDs being external representation of one or more universally unique identifiers (UUIDs);
a parameter handling module to analyze the one or more IDs and to extract a list of non-ordered UUIDs, the list of non-ordered UUIDs being internal representation of the one or more IDs; and
an OLAP processor to select data from a data source using the list of non-ordered UUIDs for the generation of the analytical result.
9 . The system of claim 8 wherein the IDs are human readable IDs.
10 . The system of claim 8 , wherein the one or more UUIDs are used as keys of business object instances.
11 . The system of claim 8 , wherein the one or more UUIDs are used to model references between business model instances.
12 . The system of claim 8 , wherein the parameter handling module is further operable to pre-query a master data Multidimensional View (MDAV), the master data MDAV maintaining ID-UUID mapping.
13 . The system of claim 8 , further comprising a filtering module to filter the data selected through the OLAP processor.
14 . An article of manufacture including a non-transitory computer readable storage medium to tangibly store instructions, which when executed by a computer, cause the computer to:
receive a user entry of one or more identifiers (IDs) as a range of ordered values for querying data and generation of analytical result, the one or more IDs being external representation of one or more universally unique identifiers (UUIDs);
analyze the one or more IDs to extract a list of non-ordered UUIDs, the list of non-ordered UUIDs being internal representation of the one or more IDs;
pass the extracted list of non-ordered UUIDs to an Online Analytical Processing (OLAP) processor; and
select data, through the OLAP processor, using the list of non-ordered UUIDs for the generation of the analytical result.
15 . The article of manufacture of claim 14 , wherein the IDs are human readable IDs
16 . The article of manufacture of claim 14 , wherein the one or more UUIDs are used as keys of business object instances.
17 . The article of manufacture of claim 14 , wherein the one or more UUIDs are used to model references between business model instances.
18 . The article of manufacture of claim 14 , wherein the instructions to analyze the one or more IDs to extract the list of non-ordered UUIDs further comprise instructions to pre-query a master data Multidimensional View (MDAV), the master data MDAV maintaining ID-UUID mapping.
19 . The article of manufacture of claim 14 , further comprising instructions, which when executed by a computer, cause the computer to filter the data selected through the OLAP processor using a predefined filter.
20 . The article of manufacture of claim 14 , wherein the instructions to select, through the OLAP processor, data using the list of non-ordered UUIDs further comprise instructions to select the data from a transactional MDAV.