SSAS Cube Data Type Error

[Anonymous]

Hi All,

I have an issue with the GA4 Connector, that I'm hoping you can all help me with?

When I try to add certain measures from the SSAS Cube, some of the measures import with a data type of integer. However, the dataset has decimals in it.
I can change the data type after the data has imported. However, at that point it's already thrown up an error. Do you know if there is a way for me to set the data type that I want to import it as, so that I can change it to decimal number?
Thanks All

[Anonymous]

Hi @Anonymous 

Please check the data type in as cube is decimal, and after importing the data, you can try to use convert() function to change its type, you can refer to the following link.

CONVERT function (DAX) - DAX | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi. I'm using the Google Analytics Connector, so I'm not sure if I can change the data type in the cube itself?

Thanks, Toby