2 Replies Latest reply: Mar 24, 2014 7:47 PM by Marco Wedel RSS

    Datamodel

    Gyanaranjan Tripathy

      Hi,

      My datamodel have three tables.both the dimension tables are linked to the fact table with an Product_R_ID as key.

      I have given an alias as [Product R ID] to avoid synthetic key.I need to have this field in all three tables.

      Though it's giving correct results with a (star schema datamodel structure too) but does it affect anything/ is it wrong to give alias as i used this field as filter (in one sheet as Product_R_ID and in another [Product R ID]).

       

      Thanks in advance.