Master Calendar to Fact Table Monthly,Quaterly

[priya945]

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

[sunny_talwar]

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?

[priya945]

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

[sunny_talwar]

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

[priya945]

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