September 13, 2011 at 12:09 pm
when on cube design "calculations" tab or in mdx query mode when i expand any + on a dimension there is an "Unknown" at the bottom of all of them. is this some error i have in my design? what is this Unknown? i cannot seem to trace it down to what is causing it as i can get no properties on it.
doug
September 14, 2011 at 6:30 am
The "unknown" is the unknown bucket that is created automatically by each dimension. The cube will place all values that have no corresponding surrogate key to that dimension in the unknown bucket.
Check the dimension properties, there you can turn it off.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 25, 2011 at 10:58 pm
And also, assign default values to dimension entities. Not displaying the 'Unknown members' will just hide the dim(s).
Raunak J
September 27, 2011 at 2:54 am
And also, assign default values to dimension entities.
I don't normally recommend this because when the dimension is not present, it can create confusing information for the user.
As for the Unknown, you should have your own UNKNOWN value that all unknown entries will be placed against. I make this value with a key of 0 so that in combination with a left join in the final load I can say COALESCE(fieldname, 0) AS columnname.
September 27, 2011 at 3:43 am
I agree with RonKyle Unkown members should be handled before they they get to the cube in the ETL process by creating an unkown member and assigning this to the missing values.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply