18 Replies Latest reply: Dec 16, 2015 8:11 PM by jagan mohan rao appala RSS

    RE:Script error

    Chanty 4u

      hi all,

       

       

      I hve master calender when i am usng innerjoin it shwng error......

       

      y it is shwng error in temp calender?

        • Re: RE:Script error
          Tamil Nagaraj

          Hi Suresh,

           

          Could you post your script or application.?

            • Re: RE:Script error
              Chanty 4u

              MinMax:

              Load

              Max(Date) as MaxDate,

              Min(Date) as MinDate

              Resident TASKDETAILS;

               

              // Creating Date Variables

               

              Let vMinDate=Num(Peek('MinDate',0,'MinMax'));

              Let vMaxDate=Num(Peek('MaxDate',0,'MinMax'));

              Let vToday = $(vMaxDate);

               

              Drop Table MinMax;

               

              // TEMPORARY CALANDER

              TempCal:

              Load

                   Date($(vMinDate)+ RowNo() -1) as TempDate

                   AutoGenerate $(vMaxDate) - $(vMinDate) +1;

                  

               

              //*****Master Calender*****

              MasterCalender:

              Load

              TempDate as Date,

                  Year(TempDate) as Year,

                  Month(TempDate) as Month,

                  Day(TempDate) as Day,

                  Week(TempDate) as Week,

                  WeekEnd(TempDate) as WeekEnd,

                  'Q' &Ceil(Month(TempDate)/3) as Quarter,

                  Date(MonthStart(TempDate),'MMM-YYYY') as MonthYear,

                  InYearToDate(TempDate,$(vToday),0) *-1 as CurYTDFlag,

                  InYearToDate(TempDate,$(vToday),-1) *-1 as LastYTDFlag

                  Resident TempCal;

               

              Drop Table TempCal;

                • Re: RE:Script error
                  Tamil Nagaraj

                  The above script works for me. Where is your inner join.?

                    • Re: RE:Script error
                      Chanty 4u

                      that is calender

                      below is script

                      TASKDETAILS:

                      LOAD

                          PROJECT_NUMBER,

                          TASK_PROJECT_DESC AS PROJECT_DESC,

                          TASK_CODE AS TSK_TASK_CODE,

                          TASK_NAME AS  TSK_TASK_NAME,

                      //     TARGET_START_DATE,

                      //     TARGET_END_DATE,

                      //     EARLY_START_DATE,

                      //     EARLY_END_DATE,

                      //    ACT_START_DATE,

                      //    ACT_END_DATE,

                          COMPONENTS as TSK_COMPONENTS,

                          COMPONENT_DESCRIPTION as TSK_COMPONENT_DESCRIPTION,

                          COST_CODE,

                          PHYS_COMPLETE_PCT as TSK_PHYS_COMPLETE_PCT,

                          TASK_ID as TSK_TASK_ID,

                          PROJ_ID,

                          PROD_SUPERVISOR_CODE,

                          PROD_SUPERVISOR_NAME,

                          DISCIPLINE_CODE,

                          DISCIPLINE_ID,

                          DISCIPLINE_NAME,

                          FACILITY_CODE,

                          FACILITY_NAME,

                          LOCATION_CODE,

                          MAIN_COMP as TSK_MAIN_COMP,

                          MAIN_COMP_DESC as  TSK_MAIN_COMP_DESC ,

                          MILESTONE as TSK_MILESTONE,

                          PROGRESS_AS_OF_CURRENT_MONTH,

                          PROGRESS_AS_OF_LAST_MONTH,

                          BASE_START_DATE as Date,

                          'Bstart' as TransType,

                           BASE_START_DATE

                         // BASE_END_DATE

                      FROM [lib://Project Apps/PPROGRESS_P6TASK_Details_V.qvd]

                      (qvd);

                      FIRST TABLE

                      TASKDETAILS1:

                      INNER JOIN(TASKDETAILS)

                       

                      LOAD

                          PROJECT_NUMBER,

                          TASK_PROJECT_DESC AS PROJECT_DESC,

                          TASK_CODE AS TSK_TASK_CODE,

                          TASK_NAME AS  TSK_TASK_NAME,

                      //     TARGET_START_DATE,

                      //     TARGET_END_DATE,

                      //     EARLY_START_DATE,

                      //     EARLY_END_DATE,

                      //    ACT_START_DATE,

                      //    ACT_END_DATE,

                          COMPONENTS as TSK_COMPONENTS,

                          COMPONENT_DESCRIPTION as TSK_COMPONENT_DESCRIPTION,

                          COST_CODE,

                          PHYS_COMPLETE_PCT as TSK_PHYS_COMPLETE_PCT,

                          TASK_ID as TSK_TASK_ID,

                          PROJ_ID,

                          PROD_SUPERVISOR_CODE,

                          PROD_SUPERVISOR_NAME,

                          DISCIPLINE_CODE,

                          DISCIPLINE_ID,

                          DISCIPLINE_NAME,

                          FACILITY_CODE,

                          FACILITY_NAME,

                          LOCATION_CODE,

                          MAIN_COMP as TSK_MAIN_COMP,

                          MAIN_COMP_DESC as  TSK_MAIN_COMP_DESC ,

                          MILESTONE as TSK_MILESTONE,

                          PROGRESS_AS_OF_CURRENT_MONTH,

                          PROGRESS_AS_OF_LAST_MONTH,

                         // BASE_START_DATE,

                          BASE_END_DATE as Date,

                          'BEnd' as TransType,

                           BASE_END_DATE

                         

                      FROM [lib://Project Apps/PPROGRESS_P6TASK_Details_V.qvd]

                      (qvd);

                      TASKDETAILS1:

                      INNER JOIN(TASKDETAILS)

                       

                      LOAD

                          PROJECT_NUMBER,

                          TASK_PROJECT_DESC AS PROJECT_DESC,

                          TASK_CODE AS TSK_TASK_CODE,

                          TASK_NAME AS  TSK_TASK_NAME,

                      //     TARGET_START_DATE,

                      //     TARGET_END_DATE,

                      //     EARLY_START_DATE,

                      //     EARLY_END_DATE,

                      //    ACT_START_DATE,

                      //    ACT_END_DATE,

                          COMPONENTS as TSK_COMPONENTS,

                          COMPONENT_DESCRIPTION as TSK_COMPONENT_DESCRIPTION,

                          COST_CODE,

                          PHYS_COMPLETE_PCT as TSK_PHYS_COMPLETE_PCT,

                          TASK_ID as TSK_TASK_ID,

                          PROJ_ID,

                          PROD_SUPERVISOR_CODE,

                          PROD_SUPERVISOR_NAME,

                          DISCIPLINE_CODE,

                          DISCIPLINE_ID,

                          DISCIPLINE_NAME,

                          FACILITY_CODE,

                          FACILITY_NAME,

                          LOCATION_CODE,

                          MAIN_COMP as TSK_MAIN_COMP,

                          MAIN_COMP_DESC as  TSK_MAIN_COMP_DESC ,

                          MILESTONE as TSK_MILESTONE,

                          PROGRESS_AS_OF_CURRENT_MONTH,

                          PROGRESS_AS_OF_LAST_MONTH,

                         // BASE_START_DATE,

                          BASE_END_DATE as Date,

                          'BEnd' as TransType,

                           BASE_END_DATE

                         

                      FROM [lib://Project Apps/PPROGRESS_P6TASK_Details_V.qvd]

                      (qvd);

                    • Re: RE:Script error
                      Simone Spanio

                      Hi,

                      the script you posted works for me too.

                      What kind of error are you getting?

                       

                      S.

                  • Re: RE:Script error
                    sagar kusuma

                    Hi suresh,

                     

                    How can we run this script?specify the error which you are getting in detail.