none
SSAS Error

    Question

  • Hi

    1) Errors in the OLAP storage engine: A duplicate attribute key has been found when processing: Table: 'dbo_Dim_x0020_Document_x0020_Type', Column: 'Item_x0020_No_', Value: '1100'. The attribute is 'Item No'.

    How can I resolve this on package level.

    2) I am also not able to see all the fields of a fact table when creating cube, where I can se all fields in dataview.
    • Edited by MohitJainMJ Tuesday, July 08, 2014 12:42 PM
    Tuesday, July 08, 2014 12:39 PM

Answers

  • Hi,

    In the second point I can view various fields eg: Name, Class, Subject, Marks etc.

    But when making a cube of it in the measures I can see only Class, Subject. i.e only some of the fields

    Hi MohitJainMJ,

    Sorry for the delay.

    You said that you can see all the fileds in the datasource view, and can only see few fileds on the cube right? When generate a cube or a dimension, we can select the columns as the attributes on the dimension, only the columns which were selected can be visible.

    Regards,


    Charlie Liao
    TechNet Community Support

    Monday, July 14, 2014 2:36 AM

All replies