Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
Just wanted to know the alternative ways to create quarter dimension from Year field..
I have used inline wizard but it takes time to refresh .Just wanted to know if there is an efficient way to do the same so that i can reduce the reload time of the application.
Regards
Arvind
HI,
If you have date field, you can use following to get the quarter.
Load
DateField,
'Q' & Ceil(Month(DateField)/3) AS CalendarQuarter
From xyx.
Regards,
Kaushik Solanki
HI,
If you have date field, you can use following to get the quarter.
Load
DateField,
'Q' & Ceil(Month(DateField)/3) AS CalendarQuarter
From xyx.
Regards,
Kaushik Solanki
Dear Kaushik,
Is this much faster than inline wizard i mean from performance point of view
Regards
Arvind