none
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:
    http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/threads

    You may search the correct forum for your question:
    http://social.technet.microsoft.com/Forums/en/categories

    You can also post the question to find :
    http://social.technet.microsoft.com/Forums/en/whatforum/threads

    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: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Thursday, November 29, 2012 9:06 AM