Server-side cross-model filtering

1. A system comprising:

a client system comprising:

a memory storing processor-executable program code; and

a processing unit to execute the program code to cause the client system to:

determine a filter on a first dimension of a first data model, wherein a second dimension of the first data model is associated with a first dimension of a second data model and the first dimension of the first data model is a non-linked dimension to the second data model; and

a server system comprising:

a memory storing processor-executable program code; and

a processing unit to execute the program code to cause the server system to:

generate a calculated dimension based on the determined filter and the second dimension of the first data model;

apply the filter to the calculated dimension generate filtered rows;

execute an inner join on the filtered rows of the calculated dimension and a fact table of the second data model to generate a result table including one or more measure values of the second data model; and

generate a visualization including the result table, wherein the user device is to display the visualization.

2. A system according to claim 1 , a client system to receive an indication of the association of the second dimension of the first data model with the first dimension of the second data model.

3. A system according to claim 1 , wherein a third dimension of the first data model is associated with a third dimension of the second data model.

4. A system according to claim 1 , wherein the first dimension of the first data model is not associated with any dimension of the second data model.

5. A system according to claim 1 , the client system to transmit a pre-query to the server system to request generation of the calculated dimension based on the second dimension and filtering of the calculated dimension to generate the filtered rows of the calculated dimension.

6. A system according to claim 5 , the server system to store the filtered rows of the calculated dimension as an intermediate table.

7. A computer-implemented method comprising:

receiving a filter on a first dimension of a first data model;

determining an association between a second dimension of the first data model and a first dimension of a second data model, wherein the first dimension of the first data model is a non-linked dimension to the second data model;

generating a calculated dimension based on the determined filter and the second dimension, the rows of the calculated dimension being identical to the rows of the second dimension;

applying the filter to the rows of the calculated dimension to generate filtered rows of the calculated dimension;

executing an inner join on the filtered rows of the calculated dimension and a fact table of the second data model generate a result table including one or more measure values of the second data model; and

generating a visualization including the result table.

8. A method according to claim 6 , further comprising receiving an indication of the association of the second dimension of the first data model with the first dimension of the second data model from a client system.

9. A method according to claim 6 , wherein a third dimension of the first data model is associated with a third dimension of the second data model.

10. A method according to claim 6 , wherein the first dimension of the first data model is not associated with any dimension of the second data model.

11. A method according to claim 6 , further comprising receiving a pre-query to request generation of the calculated dimension based on the second dimension and filtering of the rows of the calculated dimension to generate the filtered rows of the calculated dimension.

12. A method according to claim 11 , further comprising storing the filtered rows of the calculated dimension as an intermediate table.

13. A server system comprising:

a memory storing processor-executable program code; and

a processing unit to execute the program code to cause the system to:

receive an exclude filter on a first dimension of a first data model;

determine an association between a second dimension of the first data model and a first dimension of a second data model, the first dimension of first data model being a non-linked dimension to the second data model;

generate a first calculated dimension based on the second dimension of the first data model;

apply a reverse of the exclude filter to rows of the first calculated dimension;

generate a second calculated dimension based on the second dimension of the first data model;

apply the exclude filter to rows of the second calculated dimension;

execute a left outer join on a fact table of the second data model, the filtered rows of the first calculated dimension, and the filtered rows of the second calculated dimension to generate a result table including one or more measure values of the second data model; and

generate a visualization including the result table.

14. A system according to claim 13 , further to receive an indication of the association of the second dimension of the first data model with the first dimension of the second data model from a user.

15. A system according to claim 13 , wherein a third dimension of the first data model is associated with a third dimension of the second data model.

16. A system according to claim 13 , wherein the first dimension of the first data model is not associated with any dimension of the second data model.

17. A system according to claim 13 , further to:

receive a first pre-query to request generation of the first calculated dimension based on the second dimension and application of the reverse of the exclude filter to the rows of the first calculated dimension; and

receive a second pre-query to request generation of the second calculated dimension based on the second dimension and application of the exclude filter to the rows of the second calculated dimension.

18. A system according to claim 17 , further to:

store the filtered rows of the first calculated dimension as a first intermediate table; and

store the filtered rows of the second calculated dimension as a second intermediate table.