suggestion: Dimension health check should check the DataSize of all columns used as source

Topics: Resolved
Feb 24, 2010 at 12:39 PM

There is a problem in SSAS:
create a dimension based on a table in a datasourceview with datatype System.String => in the attribute the source gets DataType WChar, the DataSize is the same as in the source table
now change the datasize in the source table, changes are not transfered to the attribute source
Now it is very hard to find this. You get some error message only in case data is truncat.

I would suggest: Dimension Health Check should check the DataType and DataSize in Dimension attributes and compare them to the source table. Differences should be reported.

 

Coordinator
Feb 24, 2010 at 3:16 PM

Give this feature a spin and let us know what you think:

http://bidshelper.codeplex.com/wikipage?title=Dimension%20Data%20Type%20Discrepancy%20Check&referringTitle=Home

Thanks for providing this suggestion.

Feb 24, 2010 at 5:13 PM

Oh, I am very sorry for my posting! This is exactly what I need :-) Thank you again