https://communities.sas.com/t5/SAS-Visual-Analytics/Does-LASR-Schema-perform-a-sort-by-key/m-p/462627#M10216 <P>Hi everybody,</P><P>&nbsp;</P><P>i'm currently not understanding so well how the LASR Schema works.</P><P>I have one fact table 10M records and one dimension table 1M records. The cardinality it's 1 to n.</P><P>Viewing the output i understand that:</P><P>- VA performs an inner join</P><P>- VA performs a sort by key: using the output table in an Exploration if i filter for a specific value, which should have two rows, i can see only the first row.</P><P>&nbsp;</P><P>Could anyone help me?</P><P>&nbsp;</P><P>Thank you</P> Wed, 16 May 2018 10:46:28 GMT gabras 2018-05-16T10:46:28Z https://communities.sas.com/t5/SAS-Visual-Analytics/Does-LASR-Schema-perform-a-sort-by-key/m-p/462627#M10216 <P>Hi everybody,</P><P>&nbsp;</P><P>i'm currently not understanding so well how the LASR Schema works.</P><P>I have one fact table 10M records and one dimension table 1M records. The cardinality it's 1 to n.</P><P>Viewing the output i understand that:</P><P>- VA performs an inner join</P><P>- VA performs a sort by key: using the output table in an Exploration if i filter for a specific value, which should have two rows, i can see only the first row.</P><P>&nbsp;</P><P>Could anyone help me?</P><P>&nbsp;</P><P>Thank you</P> Wed, 16 May 2018 10:46:28 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Does-LASR-Schema-perform-a-sort-by-key/m-p/462627#M10216 gabras 2018-05-16T10:46:28Z