In this example, the Internet Sale fact table has 3 columns that are related to the date dimension: Order Date, Ship Date and Due Date. The relationship between the date table and the date keys in a fact table must be established for the Time Intelligence functions to work. Also, an entry of -1 as a surrogate key with Nulls or unknowns in the attributes can throw off the Marking as Date table as well as DAX Time Intelligence functions.įigure 2 Mark as date Table in a tabular model NOTE: The table has to have a column that is unique and this column has to be a date or datetime data type. Figure 2 shows the menu choice for marking a table as date table. Once the date table is imported, the table is marked as Date table. The import of this table is essential for Time Intelligence in a tabular model. There is such a thing as a time dimension with a time like 12:30PM and attributes like an hour and minute, but this article is all about the date – Year, Quarter, Month and Day. Some people still reference this as a time dimension, but in most cases, the table will have dates and no times. The SSAS Tabular Model will need to be built with a date dimension. SSAS enables Time Intelligence with 2 features: the date table and DAX functions.įigure 1 Year to date measure for total product costs Business users are going to want the ability to see measures a like year to date as well as the period over period comparisons. An Analysis Service (SSAS) database can help accomplish this important step. The ability to view data over time helps analyze measures in actionable steps. In the analytical world, time is an important slicer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |