January 13, 2010 at 9:46 am
Hi,
I have very curious problem.
I have 2 tables Item and Vendor in relationship 1:N:
Data looks like:
Item table:
Item1 Vendor_code1
Item2 Vendor_code1
Item3 Vendor_code3
...
Vendor table:
Vendor_code1
Vendor_code2
Vendor_code3
Vendor_code4
...
The problem is that, when I want to deploy cube, the error on this dimension appear:
Warning2Errors in the OLAP storage engine: The attribute key was converted to an unknown member because the attribute key was not found. Attribute SPARKYS Item of Dimension: SPARKYS Item from Database: Sparkys SSAS Solution, Record: 3.00
The very strang thin is, that the Record: 3 exists it table Item!!
So the question is, why this error had appear?
Anyone can help ?
January 13, 2010 at 11:19 am
Although it is hard to tell from the the details you have provided, but it seems like you have some data issue, in the error it says Attribute SPARKYS Item of Dimension: SPARKYS, which means problem is in the shown attributes data.try checking if it have Null/Empty values (both) in the <SPARKYS> of the <SPARKYS>, either it should be consistently null or Empty
or provide more details like table structure showing the datatypes, full error dump etc.
regards
Jit
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply