I have fact table with date_id column and date table with year, month, day columns. I can create a dimension with one dimension type. What influences the choice of the type? I dont see the diffence between this types in results.
Asked
Active
Viewed 450 times
1 Answers
1
You need to label a dimension as a time Dimension if you want to use time arithmetic functions such as MTD or QTD: http://mondrian.pentaho.com/documentation/schema.php#Time_dimensions
Martin Loetzsch
- 587
- 5
- 12