April 17, 2015 at 5:35 am
Hi Guys,
I'm confused I'm trying to setup a dimension so when the key is not found it replaces the value with the unknown member. I've setup the dimension as follows
UnknownMember = Visible
UnknownMemberName = 'Unknown'
Error Configuaration
KeyErrorAction = ConvertToUnknown
KeyErrorLimit = -1
KeyErrorLimitAction = StopProcessing
KeyNotFound = IgnoreError
but when I try and process the cube it's fails with key not found it reports it's convert it to an unknown member but the error limit has been reached so has stopped processing.
The only way I can get it to process is to change the error configuration in the dialog that opens when you process the cube which I assume is applying to all dimensions not just the one I want it setting up for. Surely I shouldn't have to do this it should be picking it up from the dimension configuration shouldn't it?
April 17, 2015 at 8:32 am
The only thing I can think of that you may have missed, is changing the ErrorConfiguration property from "(default)" to "Custom".
You may have seen this already, but here's a good article on custom error configurations: http://www.mssqltips.com/sqlservertip/3476/sql-server-analysis-services-ssas-processing-error-configurations/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply