Forum Discussion

cdebackere's avatar
cdebackere
Resolver I
1 year ago
Solved

interdimentional reporting

I have following facts (allReservations) and dimentions model. I uses a factless fact table (allObjectReservations) to properly manage the n-m relations between a reservation (the fact) and its objec...
Need Help
  • cdebackere's avatar
    cdebackere
    1 year ago

    You are right. I should have done that right from the start as part of my learning cycle.

    Anyway: I finally made an 'identical' model, but scaled down to 2 dimentions and a handfull of records/rows.

    Thanks to your tip.

    I identified the reason why it didn't work:

    I used a single factless facts table for linking all dimentions to the facts table.

    When splitting that table into several factless fact tables per dimention all reporting started to work.

    So with a single DAX call I split objectReservations into roomReservations and personReservations.

     

    Looking back onto it, it is very logical why using a single factless fats table doesn't work .. but again .. it's a learning cycle

     

    Hope it helps someone else

     

    BR

    Christof

Anonymous's avatar
Anonymous
Not applicable
1 year ago

There are alot of bi-directional relationship I can see in the model view. What I suggest, is start with a smaller model with just the one fact and one dimension. Do not use bi-directional and see if you can get a report from that one relationship. Next, add a second dimension and test. Keep builder (and not use bi-directional) until you get to a point where the last dimension is added that affects report, then add bi-directional to just that one dimension relationship.

  • cdebackere's avatar
    cdebackere
    Resolver I
    1 year ago

    You are right. I should have done that right from the start as part of my learning cycle.

    Anyway: I finally made an 'identical' model, but scaled down to 2 dimentions and a handfull of records/rows.

    Thanks to your tip.

    I identified the reason why it didn't work:

    I used a single factless facts table for linking all dimentions to the facts table.

    When splitting that table into several factless fact tables per dimention all reporting started to work.

    So with a single DAX call I split objectReservations into roomReservations and personReservations.

     

    Looking back onto it, it is very logical why using a single factless fats table doesn't work .. but again .. it's a learning cycle

     

    Hope it helps someone else

     

    BR

    Christof