Forum Discussion
sam_gift
2 years agoHelper I
Data Modelling for Fact Table which refers to a same column for Revenue, Standard Cost
Hi, the fact table in my current model have a column called reporting_currency.
and there is an other column called rep_id
If the rep_id is 1,2,3,4 then reporting_currency is for Revenue.
If rep_id is 5,6,7,8 then reporting_currency is Standard Cost.
What is the better approach to maintain the fact table when I want to create different columns for Revenue and standard cost.
The reason, I am asking is I want to calculate SGM % which is DIVIDE((Revenue-Standard Cost)/Revenue) as a column to establish the Static Segmentation process for percentage bucketing.
1 Reply
- Ashish_MathurSuper User
Hi,
Share data in a format that can be pasted in an MS Excel file and show the expected result.