I have a database with FactSales table that contains Date column of type I4. I have created a cube and linked dimensions via foreign keys as usual, however, since I have no DateTime table in the database I create it through the wizard and it now shows in Dimensions folder.
Now the question is: how do I link the Dimension to the cube? I have attempted to do so in Dimension Usage but to no avail. Please point me in the right direction to accomplish the task.
It now shows in Excel OLAP design, but does not filter by dates - most likely because it is not linked to the column in
FactSales
.

Asked by Daniel Protopopov
(99 rep)
Apr 29, 2016, 12:09 PM
Last activity: Oct 21, 2019, 06:09 AM
Last activity: Oct 21, 2019, 06:09 AM