Year duplicate Dimension error in creating Hierarchy SQL Server OLAP cube RRS feed

  • Question

  • I am new to OLAP development. I am facing the following below issue.

    I have an invoice dimension and attributes as year, month, date along with others. I would like to create hierarchy for year ->month->Date. while creating the relation ship between invoiceid-->Year-->Month(created key as month+year)-->date

    I get duplicate key error for year 2011 while processing the dimension I understand there are duplicate year. I would like to find the correct approach for this issue Can anyone help me?

    Wednesday, November 28, 2012 6:49 PM

All replies

  • Hi There--

    With the description the issue, It doesn't look like a project server 2010's cube issue.

    It seems that you have erroneously posted your question in a user forum dedicated to Project server , an enterprise project management tool.  I would suggest that you post a question in SQL server Analysis service's forum:

    You may search the correct forum for your question:

    You can also post the question to find :

    Hope this helps.  

    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog:

    Thursday, November 29, 2012 9:06 AM