CODEWITHSUNDEEP
ssisssasssas-2008
user1810575
user1810575

Reputation: 831

SSAS Cube Measure fact table error

I have a SSAS Cube with dimensions and measure/facts tables. I'm not able to add any string data type columns to measure group while creating cube. I get below error. "Errors in the metadata manager. The data type of the 'Loan Type' measure is not valid because the data type of the measure is a string type."

I did double check the data type for my column and it's varchar() on database and wchar in SSAS cube. I have changed the data type to Inherited and it still doesn't work. Not sure what to do.

Question: Can i add string/varchar data type to measure group in cube. I know measures are usually Int/double/date columns. Is there a possibility, Let me know also the error.

Thanks!!

Upvotes: 1

Views: 2895

Answers (2)

Jaime Montoya
Jaime Montoya

Reputation: 7701

"Measures are the bits of numerical data that we need to aggregate." (Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition, by Brian Larson).

You mentioned that "measures are usually Int/double/date columns." Have you tried using numerical values for your measures? Then you could use string data types for your dimensions if needed.

Upvotes: 0

mmarie
mmarie

Reputation: 5638

Loan type should be an attribute of a dimension rather than a measure. SSAS works best with a dimensional model.

If you need to make a drill though action, there is built-in functionality for that in SSAS which allows you to choose which dimension attributes should be included). If you move to Tabular SSAS, you can use BIDS Helper to help you build the drill through.

Upvotes: 2

Related Questions