topic Re: Cube drill through in Administration and Deployment https://communities.sas.com/t5/Administration-and-Deployment/Cube-drill-through/m-p/183819#M2397 <HTML><HEAD></HEAD><BODY><P>I am not a cube developer, but from my experience assisting my clients who build cubes, here to offer my 2 cents:</P><P>Since your cube is from star schema tables, the drill-through table needs to be the full join of the fact table and all of the dimension tables. I would choose to use 'view'.</P><P></P><P>Haikuo </P></BODY></HTML> Wed, 03 Sep 2014 14:35:33 GMT Haikuo 2014-09-03T14:35:33Z Cube drill through https://communities.sas.com/t5/Administration-and-Deployment/Cube-drill-through/m-p/183818#M2396 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>I got the following question.</P><P></P><P>I got a cube with a fact table, dimension A, dimension B.</P><P></P><P>I want a drill through column A1, column A2, column B3 for example. How do I establish this?</P><P></P><P>Regards,</P><P></P><P>Filip</P></BODY></HTML> Wed, 03 Sep 2014 11:41:55 GMT https://communities.sas.com/t5/Administration-and-Deployment/Cube-drill-through/m-p/183818#M2396 Filipvdr 2014-09-03T11:41:55Z Re: Cube drill through https://communities.sas.com/t5/Administration-and-Deployment/Cube-drill-through/m-p/183819#M2397 <HTML><HEAD></HEAD><BODY><P>I am not a cube developer, but from my experience assisting my clients who build cubes, here to offer my 2 cents:</P><P>Since your cube is from star schema tables, the drill-through table needs to be the full join of the fact table and all of the dimension tables. I would choose to use 'view'.</P><P></P><P>Haikuo </P></BODY></HTML> Wed, 03 Sep 2014 14:35:33 GMT https://communities.sas.com/t5/Administration-and-Deployment/Cube-drill-through/m-p/183819#M2397 Haikuo 2014-09-03T14:35:33Z