select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. | select a11.MONTH_ID MONTH_ID,
sum(a11.TOT_COST) WJXBFS1
from MNTH_CATEGORY_SLS a11
where a11.MONTH_ID in (200001, 200002, 200003)
group by a11.MONTH_ID
into temp MD000 with no log
select a11.MONTH_ID MONTH_ID,
sum(a11.UNITS_RECEIVED) WJXBFS1
from INVENTORY_ORDERS a11
where a11.MONTH_ID in (200001, 200002)
group by a11.MONTH_ID
into temp MD001 with no log
select pa2.MONTH_ID MONTH_ID,
a11.MONTH_DESC MONTH_DESC,
(NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) WJXBFS1
from MD001 pa2, outer
MD000 pa1,
LU_MONTH a11
where pa2.MONTH_ID = pa1.MONTH_ID and
pa2.MONTH_ID = a11.MONTH_ID
and ((NVL(pa1.WJXBFS1, 0) + NVL(pa2.WJXBFS1, 0)) > 600000.0)
M1Running product (M1)aaba*bca*b*cda*b*c*dea*b*c*d*eLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateAfrikaans.,yyyy/MM/ddCatalan,.dd/MM/yyyyDanish,.dd-MM-yyyyDutch,.d-M-yyyyEnglish (UK).,dd/MM/yyyyEnglish (US).,M/d/yyyyFinnish,spaced.M.yyyyFrench (France),spacedd/MM/yyyyFrench (Canada),spaceyyyy-MM-ddGerman,.dd.MM.yyyyItalian,.dd/MM/yyyyNorwegian,spacedd.MM.yyyyPortuguese (Portugal),.dd-MM-yyyyPortuguese (Brazil),.d/M/yyyySpanish (International),.dd/MM/yyyySpanish (Mexico).,dd/MM/yyyySwedish,spaceyyyy-MM-ddLanguageDecimalDigit grouping
e.g. 1 Million in English = 1,000,000Short dateArabic.,dd/MM/yyyyBelarusian,spacedd.MM.yyyyChinese.,yyyy-M-dChinese (Hong Kong).,d/M/yyyyCroatian,.d.M.yyyyCzech,spaced.M.yyyyEstonian,spacedd.MM.yyyyGeorgian,spacedd.MM.yyyyGreek,.d/M/yyyyHebrew.,dd/MM/yyyyHindi.,dd-MM-yyyyHungarian,spaceyyyy. MM. dd.Indonesian,.dd/MM/yyyyJapanese.,yyyy/MM/ddKorean.,yyyy-MM-ddLatvian,spaceyyyy.MM.dd.Lithuanian,.yyyy.MM.ddMacedonian,.dd.MM.yyyyPolish,spaceyyyy-MM-ddRomanian,.dd.MM.yyyyRussian,spacedd.MM.yyyySerbian,.d.M.yyyySlovak,spaced. M. yyyySlovenian,.d.M.yyyyThai.,d/M/yyyyTurkish,.dd.MM.yyyyUkrainian,spacedd.MM.yyyyUrdu.,dd/MM/yyyyVietnamese,.dd/MM/yyyyImpala DatatypeMSTR DatatypeCHARACTERCharNUMERICNumericDECIMALDecimalINTEGERIntegerSMALLINTIntegerFLOATFloatREALFloatDOUBLEDoubleDATEDateTIMETimeTIMESTAMPTimeStampVARCHARVarCharBIGINTInt64TINYINTIntegerKeysDescriptionAlt-0153™Alt-0174®Alt-0169©Alt-0137‰Alt-251√Alt-236∞Alt-243≤Alt-242≥Alt-13♪Alt-14♫Alt-23↨Alt-24↑Alt-25↓Alt-26→Alt-27←Data in email0,0,1Data in email and to history list0,1,1Data and link to history list in email1,1,1Link to history list in email1,1,0[PAProjectHeader]Options in this portion refer to creating the Platform Analytics project on this machine.PAProject=Defines whether to create the Platform Analytics project, as determined
by the following values:
• 1: Create the Platform Analytics project on this machine.
• 0: Do not create the Platform Analytics project.PAProjectEncryptPwd=Defines whether the passwords are encrypted in the response file, as determined by the following values:
• 0: The passwords are not encrypted in the response file, which enables you to modify the passwords in the response file using a text editor. You can then distribute the response file to multiple users with various login and password credentials. However, be aware that this can compromise your database security if you do not remove the passwords from the response file before distributing it.
• 1: Encrypts the passwords in the response file, which ensures that your passwords are secure. This is the default behavior.PAProjectDSSUser=The user name to log in to the Strategy Metadata.PAProjectDSSPwd=The password for the user name above. This may be encrypted, depending on the PAProjectEncryptPwd= setting.PAProjectPkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsProjectObjects.mmpPAConfigurePkgFile=The full path and file name of the Strategy Platform Analytics project package file used to create the project. This is given by the installation path during installation: <install>/PlatformAnalyticsConfigurationObjects.mmpPAProjectDSNName=The Data Source Name for the database that contains your Platform Analytics Warehouse.PAProjectDSNUserName=The user name to connect to the Platform Analytics Warehouse database.PAProjectDSNUserPwd=The password for the user name above for the Platform Analytics Warehouse database. This may be encrypted, depending on the
PAProjectEncryptPwd= setting.PAProjectDSNPrefix=The prefix of the Platform Analytics Warehouse database. |
