Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
Thanks
In properties, presentation mark 'vertical'
Regards
Burkhard
On the Presentation tab - > check Vertical
I believe this is what you are looking for.
Best,
Sunny
Thanks Vinay Bangari
Hi,
On Properties --> Presentation --> There is a option Vertical --> Check it
Thank you,
Satya Paleti
Hi Kush141087
Thanks for you reply
LET vMinDate = NUM(Date#('2014-01-01', 'YYYY-MM-DD')); //FY13 and onward
LET vMaxDate = NUM(Date#('2016-12-31', 'YYYY-MM-DD'));
tmp_CALENDAR:
LOAD
Date($(vMinDate) + RowNo() - 1) AS tmp_Date
AUTOGENERATE
$(vMaxDate) - $(vMinDate) + 1;
Set vFM = 10; // First month of fiscal year
MASTER_CALENDAR:
LOAD
tmp_Date AS %ORDER_DATE_KEY,
Week(tmp_Date) AS Week
RESIDENT tmp_CALENDAR
ORDER BY tmp_Date ASC;
DROP TABLE tmp_CALENDAR;
LET vMinDate = NUM(Date#('2014-01-01', 'YYYY-MM-DD')); //FY13 and onward
LET vMaxDate = NUM(Date#('2016-12-31', 'YYYY-MM-DD'));
tmp_CALENDAR:
LOAD
Date($(vMinDate) + RowNo() - 1) AS tmp_Date
AUTOGENERATE
$(vMaxDate) - $(vMinDate) + 1;
Set vFM = 10; // First month of fiscal year
MASTER_CALENDAR:
LOAD
tmp_Date AS %ORDER_DATE_KEY,
Week(tmp_Date) AS Week
RESIDENT tmp_CALENDAR
ORDER BY tmp_Date ASC;
DROP TABLE tmp_CALENDAR;
LET vMinDate = NUM(Date#('2014-01-01', 'YYYY-MM-DD')); //FY13 and onward
LET vMaxDate = NUM(Date#('2016-12-31', 'YYYY-MM-DD'));
tmp_CALENDAR:
LOAD
Date($(vMinDate) + RowNo() - 1) AS tmp_Date
AUTOGENERATE
$(vMaxDate) - $(vMinDate) + 1;
Set vFM = 10; // First month of fiscal year
MASTER_CALENDAR:
LOAD
tmp_Date AS %ORDER_DATE_KEY,
Week(tmp_Date) AS Week
RESIDENT tmp_CALENDAR
ORDER BY tmp_Date ASC;
DROP TABLE tmp_CALENDAR;
Hi
thanks to reply..
Please find my following code
LET vMinDate = NUM(Date#('2014-01-01', 'YYYY-MM-DD')); //FY13 and onward
LET vMaxDate = NUM(Date#('2016-12-31', 'YYYY-MM-DD'));
tmp_CALENDAR:
LOAD
Date($(vMinDate) + RowNo() - 1) AS tmp_Date
AUTOGENERATE
$(vMaxDate) - $(vMinDate) + 1;
Set vFM = 10; // First month of fiscal year
MASTER_CALENDAR:
LOAD
tmp_Date AS %ORDER_DATE_KEY,
Week(tmp_Date) AS Week
RESIDENT tmp_CALENDAR
ORDER BY tmp_Date ASC;
DROP TABLE tmp_CALENDAR;