Forum Discussion

cruzp's avatar
cruzp
Icon for Helper V rankHelper V
3 years ago
Solved

Creating a table contains Avg Days prior Closing per BU

Hello, 

 

I have a data model below where I have the fact tables that links to two dimensional table both have many to one relationship.

DIM_COST_CENTER does not have a relationship to DIM_OPPORTUNITY.

 

 

My goal is to have a table like below: 

 

Business Unit is from the table 'DIM_COST_CENTER'

Avg Days Close should be the difference between Closed Date and Created Date from table 'DIM_OPPORTUNITY'

 

I wanted to create the Avg Days Close within my fact table but I could not able to call the date fields from 'DIM OPPORTUNITY'

 

And create a table for Avg Days Close per Business Unit.

 

Please help how do I do it.

  • Hi cruzp 

    In order to get the exact values edit the relationship between FACT and 'DIM OPPORTUNITY' and set the cross filter direction to 'Both'

     
     


    Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
    Was this exchange helpful? A kudos 👍 would be appreciated

1 Reply

  • Hi cruzp 

    In order to get the exact values edit the relationship between FACT and 'DIM OPPORTUNITY' and set the cross filter direction to 'Both'

     
     


    Did it work ?  ‌‌ Mark it as a solution to help spreading knowledge
    Was this exchange helpful? A kudos 👍 would be appreciated