Forum Discussion

ysapiyev's avatar
ysapiyev
Responsive Resident
8 years ago

Date import from SSAS cube

Hi everyone,

 

I have SSAS cube with live connection as data source, and I have date input. However, slicer does not recognize it as date. How it can be fixed? What data type should be in SSAS source?

 

Regards,

Yerkhan

Need Help

3 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi ysapiyev

     

    What is the underlying datatype of the date column in the SSAS cube?  I assume this is a multidimensional cube?

     

    Often the MDX model uses a couple of columns for an attribute.  A common scenario in the MDX world is to use Integer values for the Key and a text value for the Name.  Neither of these will be picked up as dates in Power BI.  Ideally you should expose a date for both the key and name - for the purpose of Power BI.  Do you have the ability to modify the SSAS cube?

    • ysapiyev's avatar
      ysapiyev
      Responsive Resident
      8 years ago

      Phil_Seamark.

       

      It is multidimensional cube.

       

      In SSAS cube, date is recognized by Power BI as hierarchy. I have an ability to modify it.

      Also, by any chance, did you face the issue that all data in cube is recognized as Power BI measures by Power BI, not fields?

       

      Regards,

      Yerkhan

      • ysapiyev's avatar
        ysapiyev
        Responsive Resident
        8 years ago

        Hi everyone,

         

        I have SSAS multidimensional cube as data source with live connection. I faced two problems:

         

        1. Slicer can't read date field in my data as date.

         

        2. All data recognized as Power BI measures, not fields. Therefore, I can't use data aggregation in visuals.

         

        How it can be solved?

         

        Regards,

        Yerkhan