I have to produce a report with some measures / dimensions like the following one


+---------------+---------------+-----------------+------------+-----------------+
| date | province |active_clients| no. sales | total_stores |
+---------------+---------------+-----------------+------------+-----------------+
| | AAAA | 500 | 100 | 80 |
| 2017-01-04| BBBB | 275 | 200 | 88 |
| | CCCC | 999 | 203 | 89 |
+---------------+---------------+-----------------+------------+-----------------+


Both measures 'active_clients' and 'no.sales' are calculated from fact tables.
On the other hand, the last one is calculated from dimension store (and it is not related with dimension date) and does not depend on facts of that day (it is the total number of stores we have, no matter if they sold on that day or not).


I've searched all around online and I can't find a solution to solve it with Pentaho Schema Workbench.




Can anyone help me, please?


Thank you,