Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My Fact table contains Weekly,Monthly,Quaterly values as below. I want to create a Master Calendar and connect it to the fact table Weekly,Monthly,Quaterly . Please suggest how can I achieve this
Load * Inline [
Metric, Date, Frequency, Value, Flag
A , 01/12/2018, Weekly, 08,Y
B , 01/12/2018,Weekly, 10, Y
C , 01/12/2018, Weekly, 04, Y
A , - , Monthly, 15,N
B , - , Monthly, 20,N
C , - , Quaterly,12, N
];
Thanks
What would Monthly value connect to Master Calendar table on? There is no date to know which month it is. Can you provide the master calendar table look that you are hoping to get here?
Thanks Sunny for your time. My data is as below
Test:
Load * Inline [
Metric, Date, Frequency, Value, Flag, Month, Qtr
A , 01/12/2018, Weekly, 08, Y, 12, Q3'18
B , 01/12/2018, Weekly, 10, Y, 12, Q3'18
C , 01/12/2018, Weekly, 04, Y, 12, Q3'18
A , - , Monthly, 15, N, 1, Q4'18
B , - , Monthly, 20, N, 1, Q4'18
C , - , Quaterly, 12, N, -, Q4'18
];
Expected o/p as below, when Monthly filter is selected
Metric | Jan'18 |
A | 15 |
B | 20 |
and for Quaterly Filter
Metric | Jan'18 |
C | 12 |
I need to create a Master Calendar for above requirement, Please help
Thank you
But you can get the same output without creating a master calendar. What exactly are you looking the master calendar to do here? I am missing the link here
I need to have the Jan'18 in Month filed & Q1'18 in Qtr filed to use as dimensions rt? so creating a Master calendar and associating with Fact table
Thank You