Hi Experts,

I have to create quarter functionality 

Q1 = Jan24, Feb24, Mar24

Q2 = Apr24, May24, June24

Q3 = Jul23, Aug23, Sep23    (If we enter to July Q3 should be Jul24 and Q4 remains same)

Q4 = Oct23, Nov23, dec23  

I'm trying with code, 

LET S_DATE_START = NUM(YEARSTART(ADDYEARS(TODAY(), -2)));
LET S_DATE_END = NUM(FLOOR(MONTHEND(TODAY())));

DATE_CALENDAR:
LOAD
CALENDAR_DATE AS %KEY_CALENDAR_DATE,
DATE(CALENDAR_DATE) AS CALENDAR_DATE,
YEAR(CALENDAR_DATE) AS CALENDAR_YEAR,
DUAL(DATE(CALENDAR_DATE, 'MMMM'), NUM(MONTH(CALENDAR_DATE))) AS CALENDAR_MONTH,
NUM(MONTH(CALENDAR_DATE)) AS CALENDAR_MONTH_NUM,
NUM#(DATE(CALENDAR_DATE, 'YYYYMM')) AS CALENDAR_YEAR_MONTH_NUM,
DATE(WEEKSTART(CALENDAR_DATE), 'YYYYMMDD') AS CALENDAR_WEEK_ORDER,
DAY(CALENDAR_DATE) AS CALENDAR_DAY,
DUAL(WEEKDAY(CALENDAR_DATE), NUM(WEEKDAY(CALENDAR_DATE))) AS CALENDAR_WEEK_DAY,
'Q' & CEIL(NUM(MONTH(CALENDAR_DATE))/3) AS CALENDAR_QUARTER,
DUAL(DATE(CALENDAR_DATE, 'MMM-YYYY'),
NUM#(DATE(CALENDAR_DATE, 'YYYYMM'))) AS CALENDAR_YEAR_MONTH,
DUAL(NUM(DAY(WEEKSTART(CALENDAR_DATE)), '00') &'/'& DATE(WEEKEND(CALENDAR_DATE), 'DD-MMM-YYYY'),
YEAR(WEEKSTART(CALENDAR_DATE)) & NUM(WEEK(WEEKSTART(CALENDAR_DATE)), '00')) AS CALENDAR_WEEK;
LOAD
($(S_DATE_START) + RECNO()) - 1 AS CALENDAR_DATE
AUTOGENERATE((S_DATE_END - S_DATE_START) + 1);

SET S_DATE_START=;
SET S_DATE_END=;

EXIT SCRIPT;

Thanks in Advance!

Hello, I have the following measure which I use to obtain a measure of efficiency for an individual employee. I would like to make it work for all of the employees instead. This means that, for me, the employee should be compared to the average of all the other ones grouped together.

I tried using set expression, but I am afraid with the logic that I use here it's going to be counterproductive, as I added {< Employee = >} to all spots I could and it still doesn't work out well. 

Alt(
  (
      Sum(
          Aggr(
              Count( {< ACTION_CODE = {'LABOR_OFF'}>} distinct MainSFC) * Tempo_Medio,
              MainSFC
          )
      )
  )
  /
  // Conteggio ore in minuti per giorno distinto e moltiplicato per numero dipendenti
  (
      (
      Count( 
          distinct GiornoSettimanaLavorato
      ) 
      * 7.5 * 60 * GetSelectedCount(Employee)
      )

  // Sottrarre le ore di assenza disponibili 
          - 
          IF(
              GetSelectedCount(Employee) > 0, 
              Sum(Absence * 60),
              0
          )
  )
  ,0
)

Hello All,

I have a scenario in my project.

I have to read the data from a database table with rows/xml file. I have to load this data to a xml field as body in another xml so that i can eventually feed the tRest client with this to generate a response.

so the flow is as below:

xml file---> xml field in xml file( generated as body)--> tRest client as input ( xml body needs to be an input)

Can you tell me how can i do this?

Our Source and Target system are cloud rds Postgres and Cloud Aurora Postgres respectively.

We had Source and Targets having same no of columns and Same primary Keys ..

However couple of table are frequently failing with 

Table 'lcadm'.'spb_shipment_route_exp (subtask 0 thread 1) is suspended. Cannot compute expression, not all column values are in the data record

Table 'lcadm'.'spb_order' (subtask 0 thread 1) is suspended. Cannot compute expression, not all column values are in the data record

(or)Table 'lcadm'.'spb_shipment_route_exp' (subtask 0 thread 1) is suspended. Failed to get delete statement for table lios_raw.spb_shipment_route_exp,
stream position 0000005F/4CECD9C8.53.0000005F/4CECF7188

We had referential integrity constraints (FK)  @ source. Does the source tables having Foreign keys will triggers above compute errors and suspend tables ? Please advise.  

Hi team, 

We are migrating data from Mongodb to Redshift. We need to convert the Json format to tabular format while transferring data .

Is there any way to do this transformation for mongodb as a source.

Regards,

Sushant