locked
Why a member from a dimension is being replace by another ? ( Tabular Model ). RRS feed

  • Question

  • hi to all , i have a model contains fact of account revenue , a time dimension and scd of account.

    the scd (type 2) is changing when an account get a new color.

    when i queries the model by PowerPivot i sometimes get wrong color for an account in a date priod , 

    for example , I would expect to see color 3 for account 1 at 04-06-2010 , But instead I see  color 1 - as you can see in the picture bellow.

    FACT , SCD :

    Result :

    i prcess all , deploy , mark dim_time as date dim , and i steel cant find the error ,

    can someone help me , pls , thanks !


    yaniv012 from M.S.



    • Edited by yaniv012 Monday, August 10, 2015 11:57 AM buti
    Monday, August 10, 2015 11:50 AM

Answers

  • hi to all the great people that make develope possible ,

    probably i had a bug in the model , i built it from zero and now its OK , THANKS !


    yaniv012 from M.S.

    • Proposed as answer by Michael Amadi Thursday, August 13, 2015 6:37 AM
    • Marked as answer by Charlie Liao Monday, August 17, 2015 6:32 AM
    Wednesday, August 12, 2015 8:58 AM

All replies

  • I can't make heads or tails of this without some sample data.
    Monday, August 10, 2015 1:14 PM
  • hi Seth , give your email , i will send you the data ,

    thanks !


    yaniv012 from M.S.

    Tuesday, August 11, 2015 5:24 AM
  • hi to all the great people that make develope possible ,

    probably i had a bug in the model , i built it from zero and now its OK , THANKS !


    yaniv012 from M.S.

    • Proposed as answer by Michael Amadi Thursday, August 13, 2015 6:37 AM
    • Marked as answer by Charlie Liao Monday, August 17, 2015 6:32 AM
    Wednesday, August 12, 2015 8:58 AM