You need to implement a time dimension

You are developing a SQL Server Analysis Services (SSAS) multidimensional database.
The underlying data source does not have a time dimension table.
You need to implement a time dimension.

What should you do?

You are developing a SQL Server Analysis Services (SSAS) multidimensional database.
The underlying data source does not have a time dimension table.
You need to implement a time dimension.

What should you do?

A.
Use the SQL Server Data Tools Dimension Wizard and generate a time table on the
server.

B.
Create a CSV file with time data and use the DMX IMPORT statement to import data from
the CSV file.

C.
Create a time dimension by using the Define dimension intelligence option in the
Business Intelligence Wizard.

D.
Create a time dimension by using the Define time intelligence option in the Business
Intelligence Wizard.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Ralph

Ralph

A is correct
D would generate time dimension in the data source