Forum Discussion

mkatipal's avatar
mkatipal
New Member
8 years ago

data type change analysis services

Hi, Am looking for ways to be able to change the data type of a Dimension attribute (like Resume number) from numerical to text data type. That will allow me to analyze some related facts. I dont s...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello,

 

I am also having this problem. I prepared a report with SSAS live connection and I need to change one column's data type to "Barcode", but I can not do it at this moment.

 

Did you get the proper solution?

Best regards.

wwhittenton's avatar
wwhittenton
Helper II
7 years ago

Hi husss,

 

See the response from v-jiascu-msft on 12-20-2017 at 6:54. The rules could have changed by now, since that was 11 months and a lifetime ago, but I don't think Microsoft has made it possible to change the data type from a direct query just yet.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Hello,

    Unfortunately did not change. Still in SSAS connection, data type can not be changed, that is why I converted my model to Direct Query mode which provides me this changing.

    Thanks for your attention.
    • arturomontes198's avatar
      arturomontes198
      New Member
      7 years ago

      hello

       

      i have the same problem

       

      even if i round the field in ssas, it don't work.

       

      have you found something

       

      regards

       

      arturo