Home Forums Data Warehousing Analysis Services Cube Process Failure - Is there a way to process Dimensions before the Cubes Automatically RE: Cube Process Failure - Is there a way to process Dimensions before the Cubes Automatically

  • May 15, 2015 at 12:35 pm

    #1798304

    Martin Schoombee (5/15/2015)

    VRT (5/15/2015)

    what is the data source you are using. If its other than SQL Server, you will be getting this kind of errors.

    Not true...the issue experienced by the OP has nothing to do with the type of data source. Missing or unmatched attribute key errors mean that a fact table contains a key that could not be found in the dimension. The error has more to do with what is processed and how, and not the type of data source.

    You are right. But Key errors meaning some times we also get duplicate key errors. I dont see any thing wrong with my key columns. But it is also hard to understand with huge tables. yes I do work on more than 50 million records.

    I also get some time duplicate key error for non-key columns...I use queries instead of tables.

    I thought in that way, If its not really make sense I can delete that post.

    Thank You