Forum Discussion

CMAC_Terry's avatar
CMAC_Terry
Helper I
8 years ago
Solved

Calendar since September Update

New to the software but having lots of problems with time deminsions since the Sept 2017 update.   I've imported two cubes from SSAS and used one dataset of date to create a calender:  Calendar Ta...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Terry,

     

    The cause is the dates in [fact***entry] are datetime rather than date. I added a new column and changed the relationship. It returns normal now.

    New key Date.Datetime = [Key Date.DateTime].[date]

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Sharing the link of OneDrive is OK. If you can't post it here, you can send me private message.

 

Best Regards!

Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Terry,

     

    You have to share the file first. I can access it.

     

    >>>We're sorry, but xxx can't be found in the cmacgroup-my.sharepoint.com directory. Please try again later, while we try to automatically fix this for you.

     

    Best Regards!

    Dale

    • CMAC_Terry's avatar
      CMAC_Terry
      Helper I
      8 years ago

      I think I need your email address to share, could you post.

       

      Thanks, 

       

      Terry

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Terry,

         

        The cause is the dates in [fact***entry] are datetime rather than date. I added a new column and changed the relationship. It returns normal now.

        New key Date.Datetime = [Key Date.DateTime].[date]

         

         

         

         

         

         

         

         

         

         

         

         

         

         

        Best Regards!

        Dale