You could try to create a new attribute with the same name and set its data type to "Date" and then use this new attribute in your calculations and hierarchies instead of the original one.
Not Able to change the datatype of my DATE dimension attribute
Hi All,
I created a SSAS MD, I have a date dimension "chargedate", in this I have the following attributes,
DATEKEY,DISPLAYDATE,YEAR,QUARTER,MONTH,WEEK. The display date has datatype as Regular, but when I tried to change it to Date, it is reverting to Account. Please advice.
Thanks
2 answers
Sort by: Most helpful
-
-
Seeya Xi-MSFT 16,571 Reputation points
2023-01-18T06:45:56.29+00:00 Hi BK,
You can try reopening the project or changing to a different version of VS. if this doesn't solve your problem, I suggest you go to the VS feedback site and post this thread.
https://developercommunity.visualstudio.com/VisualStudio/report?entry=problem
Best regards,
Seeya
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".