Alternative to inline wizard for creating quarter field from Year dimension

[rajtechnocraft]

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

[kaushiknsolanki · Accepted solution]

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

[rajtechnocraft]

Dear Kaushik,

Is this much faster than inline wizard i mean from performance point of view

Regards

Arvind