Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need help in creating the Fiscal Month Name for the Dimenions in the chart. Currently , I use below function but it gives me only the numbers as 1 to 12 but instead I want the charts to display the months starting from Apr, May, ---- Till March.
SET vFM = 4;
Load *,
Mod(Month-$(vFM), 12)+1 as fMonth;
My Current Output : -
please help me to fix this.
Thanks in Advance,
Arun
try creating preceding load like below script and change dimension fMonth to FMonth
SET vFM = 4;
Load * , Dual(Month, fMonth) as FMonth;
Load *,
Mod(Month-$(vFM), 12)+1 as fMonth ,
I did get error for fMonth , but got it fixed . Thanks for the quick response.
Thanks for the quick response.