Hi,
I need to do cumulation on calculated dimension.
Could you please help me with this on both calculated dimension and on script level.
Cumulation could be done on "ReceivedQty"
Script:
LOAD
if(isnull(UPPER(po_version)),'-',UPPER(po_version)) as "Base",
po_version as "Target",
UPPER(ems) as "EMS*",
UPPER(mpn) as "MPN*",
UPPER(maker) as "MAKER*",
UPPER(supplier) as "SUPPLIER*",
po_version&supplier as test,
upper(NPI_flag) as "NPI Flag_V",
months as "MONTH*",
year as "YEAR*",
if( months&'-'&year >0,months&'-'&year) as MonthYear,
if(Ceil(Month(Date#(months&year, 'MMMYYYY'))/3)&'-'&year>0, year&'-'&'Q'&Ceil(Month(Date#(months&year, 'MMMYYYY'))/3)) as "Quarter*",
ReceivedQty as "Delivered Quantity",
BalanceQty as "Balance Quantity",
Total_RequestedQty ,
text("commodity_type") as "Commodity Type",
processed_at Where Left(ems, 3) <> 'PNE'and months <> 'None';
From xxxxxxxxx;
