Forum Discussion

nsam101's avatar
nsam101
Frequent Visitor
9 years ago

Number format from SSAS cube lost

I have a number of measures defined in my multidimensional AS cube where the number of decimal places is explicity set, either directly against the incoming database measure or in a cube calculated m...
xppdev's avatar
xppdev
Frequent Visitor
9 years ago

Same issue here, and I belive we used to be able to categorize data as well. I vaguely remember assigning City and other address info in our proof of concept. The formatting really needs to be in the Power BI tool as we are trying to get our users to utilize more of a self service reporting model. Ex, some users may not want to see any decimals. Or even just show the thousands.

We can not import cubes or tabular models either. Once I add a date dimension, I get an immediate memory error. We are working through MS to try and resolve, but no answers as of yet. These issues are making it difficult to implement the product.

rednuht's avatar
rednuht
Frequent Visitor
8 years ago

I'm facing a possibly related problem where I apply some case transformations (uppercase, lowercase, etc.) to string columns in the SSAS model using the Query Editor, but those changes are ignored in Power BI.