CODEWITHSUNDEEP
sql-serverssasssms
K4timini
K4timini

Reputation: 741

SSAS - Empty Generated Time Dimension Table

I'm facing a strange problem about SSAS.

I created a time dimension by using Dimension Generator Wizard. I chosen to create a time dimension in my data source.

It works fine, I can browse by cube and filtering on date.

Now, I would like to browse this table to check values, however the time table is empty in SSMS. So when I select the "TOP 100 rows", 0 rows are retrieved.

Upvotes: 0

Views: 189

Answers (1)

K4timini
K4timini

Reputation: 741

Due to a strange mistake, when I browsed the table in SQL Server, no rows were retrieved. I decided to delete and recreate the Time dimension (created in the data source) by using Dimension Wizard in SSDT. It works well.

To customize the table, I decided to create a view from the dimension table, then I added some changes. Finally, I changed the dimension table to the new view in SSDT (data source view).

Upvotes: 1

Related Questions