Best Practice of SSAS

• sachdeva.purnima

  Grasshopper

  Points: 17

  More actions

  April 17, 2012 at 4:32 am

  #150893

  I have two branches in my Fact Table ,Booking Branch and Contracting Branch, I want to see Amount on the three basis

  1. When both branches are same ,

  2. When Booking branch is own and contracting is other

  3. When Contracting is own and Booking is other

  For this Should I use multiple Fact table or Single Fact Table and handle with MDX.

• Chris Umbaugh

  Ten Centuries

  Points: 1334

  More actions

  April 17, 2012 at 6:45 am

  #1474677

  sachdeva.purnima (4/17/2012)

  ---

  I have two branches in my Fact Table ,Booking Branch and Contracting Branch, I want to see Amount on the three basis

  1. When both branches are same ,

  2. When Booking branch is own and contracting is other

  3. When Contracting is own and Booking is other

  For this Should I use multiple Fact table or Single Fact Table and handle with MDX.

  What is a "branch"? Is that a dimension?

  Chris Umbaugh
  Data Warehouse / Business Intelligence Consultant
  twitter @ToledoSQL

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  April 18, 2012 at 10:38 pm

  #1475814

  sachdeva.purnima (4/17/2012)

  ---

  I have two branches in my Fact Table ,Booking Branch and Contracting Branch, I want to see Amount on the three basis

  1. When both branches are same ,

  2. When Booking branch is own and contracting is other

  3. When Contracting is own and Booking is other

  For this Should I use multiple Fact table or Single Fact Table and handle with MDX.

  This looks like you are dealing with role playing dimensions.

  Raunak J