Does anyone know why the DateDimensionView created with the Data Warehouse Configurator has the following SQL clause:
select * from date where dateid > 0x0000000003E7
The clause "dateid > 0x0000000003E7" is preventing a cube, mscsSales, to be processed. What determines the value 0x0000000003E7 is to be used in this clause
Thanks in advance!
Problem When Processing a Cube from Commerce
pmanisekaran
When the cube is processed I get the following error:
"A member with key '000000000001' was found in the fact table but was not found in the level 'Date Id' of the dimension 'Date'.; Time:1/23/2007 3:22:24 PM"
I think the problem is that the child class has records with id=0x000000000001 an the parent doesn't have this id. I got to this conclusion executing some queries on the database. If I comment the clause "where dateid > 0x0000000003E7" in the view the cube is processed successfully. But I don't think I should do this, right I mean, I must be doing something wrong in the whole datawarehouse import process to get such a situation where I have "children without a parent".
Do you know what could be wrong
cfaulk
Instance data written by the CSOLEDB Provider gets a surrogate key that is represented as a binary(6) in the table corresponding to the class. In this case, DateId is the id. All classes that are parents to some child class in a relationship must have a well defined default record so that child instances that don't supply parent keys or instance data can still maintain referential integrity. Those default records have an id=1. User data has ids that start at 1000 (0x03e8).