Not Able to change the datatype of my DATE dimension attribute

BK 6 Reputation points
2023-01-13T14:50:55+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,430 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,310 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Hupkes, W.P. (Wouter) 21 Reputation points
    2023-01-14T19:54:29.8966667+00:00

    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.

    0 comments No comments

  2. 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".

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.