Wednesday, July 19, 2023

Analysis Service - How to create a measure of varchar datatype in SSAS cube

Work round:
1) We can do some work around if we have data like Age (21,50, 75) which is stored in VARCHAR datatype.
2) We can change the Data source view definition for the cube
3) Create a new column (Age_INT) with some numeric data type e.g. Integer and map our varchar column (Age) to this new column say Age_INT.
4) We can use this newly created column (Age_INT) for our calculated member.

No comments:

Post a Comment