CODEWITHSUNDEEP
databasessasdata-warehouseolap-cube
user3909563
user3909563

Reputation: 5

Ssas cube wizard doesn't create measures for fact table columns

When I create a ssas cube, I don't get any measure columns in fact table. The only measure is Fact table count value. I don't understand why. Then when I add a dimension fact table fields appear in the dimension. There is only a count field which is not a column in Fact table.

I have tried several times to create but the wizard doesn't give me the right columns to choose. What do I do, please?

Fact table columns are human_fatalities, number_of_service_hour_lost , other_cost,service_cost,Surrogate_keys to the different dimensions.

Upvotes: 0

Views: 568

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31795

The wizard will only suggest numeric columns for measures. If you cannot change the table, perhaps you can create a view that casts the columns as a numeric data type. If that is not possible, you can create computed columns in your Data Source View that convert the measure columns to a numeric data type.

Upvotes: 2

Related Questions