STOCK COVERAGE CALCULATION IN AN OLAP ENGINE
A system includes definition of a time dimension as a formula exception aggregation reference dimension of a stock coverage measure, modification of filters of a demand measure to retrieve demand values outside a time filter of a cell, retrieval of individual values of the demand measure for each value of the time dimension, generation of a table comprising, for each value of a stock measure, values of the demand measure needed to calculate the stock coverage measure, and determination of the stock coverage measure based on the table and on the formula exception aggregation.
1 . A computing system comprising:
a data storage device;
a memory storing processor-executable program code; and
a processor to execute the processor-executable program code in order to cause the computing system to:
define a time dimension as a formula exception aggregation reference dimension of a stock coverage measure;
modify filters of a demand measure to retrieve demand values outside a time filter of a cell;
retrieve individual values of the demand measure for each value of the time dimension;
generate a table comprising, for each value of a stock measure, values of the demand measure needed to calculate the stock coverage measure; and
determine the stock coverage measure based on the table and on the formula exception aggregation.
2 . A computing system according to claim 1 , wherein generation of the table comprises:
determination of a first table comprising each value of the stock measure, the first key of the first table comprising dimensions C 1 through C n ;
determination of a second table comprising individual values of the demand measure for each value of a time dimension, the second key of the second table comprising dimensions C 1 through C n and the time dimension; and
execution of a 1:n join on the dimensions C 1 through C n of the first table and the second table.
3 . A computing system according to claim 2 , wherein modification of filters of a demand measure comprises:
changing of a first filter on a coherent range of time values to a second filter on all time values greater to or equal than the earliest of the coherent range of time values.
4 . A computing system according to claim 1 , wherein modification of filters of a demand measure comprises:
changing of a first filter on a coherent range of time values to a second filter on all time values greater to or equal than the earliest of the coherent range of time values.
5 . A non-transitory computer-readable medium storing program code, the program code executable by a processor of a computing system to cause the computing system to:
define a time dimension as a formula exception aggregation reference dimension of a stock coverage measure;
modify filters of a demand measure to retrieve demand values outside a time filter of a cell;
retrieve individual values of the demand measure for each value of the time dimension;
generate a table comprising, for each value of a stock measure, values of the demand measure needed to calculate the stock coverage measure; and
determine the stock coverage measure based on the table and on the formula exception aggregation.
6 . A non-transitory computer-readable medium according to claim 5 , wherein generation of the table comprises:
determination of a first table comprising each value of the stock measure, the first key of the first table comprising dimensions C 1 through C n ;
determination of a second table comprising individual values of the demand measure for each value of a time dimension, the second key of the second table comprising dimensions C 1 through C n and the time dimension; and
execution of a 1:n join on the dimensions C 1 through C n of the first table and the second table.
7 . A non-transitory computer-readable medium according to claim 6 , wherein modification of filters of a demand measure comprises:
changing of a first filter on a coherent range of time values to a second filter on all time values greater to or equal than the earliest of the coherent range of time values.
8 . A non-transitory computer-readable medium according to claim 5 , wherein modification of filters of a demand measure comprises:
changing of a first filter on a coherent range of time values to a second filter on all time values greater to or equal than the earliest of the coherent range of time values.
9 . A computer-implemented method comprising:
defining a time dimension as a formula exception aggregation reference dimension of a stock coverage measure;
modifying filters of a demand measure to retrieve demand values outside a time filter of a cell;
retrieving individual values of the demand measure for each value of the time dimension;
generating a table comprising, for each value of a stock measure, values of the demand measure needed to calculate the stock coverage measure; and
determining the stock coverage measure based on the table and on the formula exception aggregation.
10 . A computer-implemented method according to claim 9 , wherein generating the table comprises:
determining a first table comprising each value of the stock measure, the first key of the first table comprising dimensions C 1 through C n ;
determining a second table comprising individual values of the demand measure for each value of a time dimension, the second key of the second table comprising dimensions C 1 through C n and the time dimension; and
executing a 1:n join on the dimensions C 1 through C n of the first table and the second table.
11 . A computer-implemented method according to claim 10 , wherein modifying filters of a demand measure comprises:
changing a first filter on a coherent range of time values to a second filter on all time values greater to or equal than the earliest of the coherent range of time values.
12 . A computer-implemented method according to claim 9 , wherein modifying filters of a demand measure comprises:
changing a first filter on a coherent range of time values to a second filter on all time values greater to or equal than the earliest of the coherent range of time values.