System and method for locking context of sets of members in crosstabs
View Patent ↗A context locking method and system lock context of a set of members in a crosstab for further data exploration and analysis. The context locking system has a context information manager and a locking manager. The context locking method information manager collects context information of the selected member. The context locking method manager locks the context of the selected set based on the context information during further exploration or analysis of the crosstab, while allowing the locked set to reflect data changes in the data source.
1. A method that is implemented on a computer, the method comprising:
receiving a request to create a constant filtered set definition to select a set of members in a crosstab, the crosstab including data retrieved from a data source;
creating, with an expression based filter that depends on data in the data source, the constant filtered set definition;
selecting, after the creation of the constant filtered set definition, the set of members in the crosstab based on the constant filtered set definition; and
updating the set of members in the crosstab based on the constant filtered set definition and a change to the data in the data source without updating the set of members in the cross tab based on a change to a global definition corresponding to the crosstab such that the constant filtered set definition overrides the global definition.
2. The method as claimed in claim 1 , further comprising:
capturing and saving a current filter applied to the set of members; and
capturing and saving a definition of an opposite axis of the crosstab.
3. The method as claimed in claim 2 , further comprising:
capturing and saving an actual value of any current default measure in the set of members; and
capturing and saving an actual value of a current scope of the crosstab.
4. The method as claimed in claim 1 , further comprising overriding a global definition corresponding to a future crosstab for the constant set of members.
5. The method as claimed in claim 4 , wherein a tuple handler ensures that the constant filtered set definition remains constant for a tuple.
6. The method as claimed in claim 5 , further comprising providing adding a default setting to an argument of the tuple to make the tuple independent from the change to the global definition corresponding to the crosstab.
7. The method as claimed in claim 4 , wherein the future filter context, opposite axis definition with respect to future filters, and/or actual values of any default measures and/or scope are overridden with respect to changing corresponding default values in future crosstabs.
8. The method as claimed in claim 5 , further comprising generating a query with a tuple completing function to complete a tuple by defining a representative member of each dimension in an OLAP cube representing the data source, and specifying a default member with respect to a dimension that is not represented in the set members.
9. The method as claimed in claim 8 , wherein the query generating comprises obtaining an actual value of any current default measure from the OLAP cube.
10. The method as claimed in claim 1 , further comprising handling dependency of the set of members to at least one additional set of members in the crosstab by removing the dependency.
11. The method as claimed in claim 10 , further comprising changing the constant filtered set definition to be fixed to a current constant filtered set definition of an additional set of members.
12. A system comprising:
a lock request manager, stored on one or more non-transitory computer readable storage medium and operated by a controller, that receives a request to create a constant filtered set definition to select a set of members in a crosstab, the crosstab including data retrieved from a data source; and
an expression based filter, stored on one or more non-transitory computer readable storage medium and operated by the controller, that creates the constant filtered set definition and selects, after the creation of the constant filtered set definition, the set of members in the crosstab based on the constant filtered set definition so that an update to the set of members in the crosstab based on the constant filtered set definition and a change to the data in the data source is effectuated without updating the set of members in the crosstab based on a change to a global definition corresponding to the crosstab such that the constant filtered set definition overrides the global definition.
13. The system as claimed in claim 12 , further comprising a context information manager that captures and saves a current filter applied to the set of members and captures and saves a definition of an opposite axis of the crosstab.
14. The system as claimed in claim 13 , wherein the context information manager also captures and saves an actual value of any current default measure in the set of members and captures and saves an actual value of a current scope of the crosstab.
15. The system as claimed in claim 12 , wherein a global definition corresponding to a future crosstab for the constant set of members is overridden.
16. The system as claimed in claim 15 , further comprising a tuple handler ensures that the constant filtered set definition remains constant for a tuple.
17. The system as claimed in claim 16 , wherein a default setting is added to an argument of the tuple to make the tuple independent from the change to the global definition corresponding to the crosstab.
18. The system as claimed in claim 15 , wherein future filter context, opposite axis definition with respect to future filters, and/or actual values of any default measures and/or scope are overridden with respect to changing corresponding default values in future crosstabs.
19. The system as claimed in claim 15 , a query is generated with a tuple completing function to complete a tuple by defining a representative member of each dimension in an OLAP cube representing the data source, and specifying a default member with respect to a dimension that is not represented in the set members.
20. The system as claimed in claim 19 , wherein the query generating comprises obtaining an actual value of any current default measure from the OLAP cube.
21. A computer program product comprising a non-transitory computer readable storage medium having a computer readable program, wherein the computer readable program when executed on a computer causes the computer to:
receive a request to create a constant filtered set definition to select a set of members in a crosstab, the crosstab including data retrieved from a data source;
create, with an expression based filter that depends on data in the data source, the constant filtered set definition;
select, after the creation of the constant filtered set definition, the set of members in the crosstab based on the constant filtered set definition; and
update the set of members in the crosstab based on the constant filtered set definition and a change to the data in the data source without updating the set of members in the crosstab based on a change to a global definition corresponding to the crosstab such that the constant filtered set definition overrides the global definition.
22. The computer program product as claimed in claim 21 , wherein the computer is further caused to:
capturing and saving a current filter applied to the set of members; and
capturing and saving a definition of an opposite axis of the crosstab.
23. The computer program product as claimed in claim 22 , wherein the computer is further caused to:
capturing and saving an actual value of any current default measure in the set of members; and
capturing and saving an actual value of a current scope of the crosstab.