question

SqlServerExpert avatar image
SqlServerExpert asked

Select day of year from time dimension in SSAS as of today's date

Day of year and date are columns in DimTime table. How I can write calculation in SSAS to get day of year as measure from DimTime dimension as per today's date?

ssasmdxdimension
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
SqlServerExpert avatar image
SqlServerExpert answered

Please advice.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.