Queries
for Deviation Analysis 
Technical Names:
|
CRM ABC Deviation analysis relative to second ABC Classification |
0CRMAMC01_Q0001 |
|
CRM ABC Deviation analysis relative to first ABC Classification |
0CRMAMC01_Q0002 |
|
ABC Deviation analysis relative to second ABC Classification |
0DMAMC01_Q0001 |
|
ABC Deviation analysis relative to first ABC Classification |
0DMAMC01_Q0002 |
|
Deviation of CRM ABC Classification from CRM Clustering analysis |
0CRMAMC01_Q0003 |
|
Deviation of CRM Clustering analysis from CRM ABC Classification |
0CRMCMC01_Q0003 |
|
Deviation of ABC Classification from Clustering analysis |
0DMAMC01_Q0003 |
|
Deviation of Clustering analysis from ABC Classification |
0DMCMC01_Q0003 |
|
Deviation of CRM ABC Classification from CRM Decision Tree analysis |
0CRMAMC01_Q0004 |
|
Deviation of CRM Decision Tree analysis from CRM ABC Classification |
0CRMTMC01_Q0003 |
|
Deviation of ABC Classification from Decision Tree analysis |
0DMAMC01_Q0004 |
|
Deviation of Decision Tree analysis from ABC Classification |
0DMTMC01_Q0003 |
|
CRM Clustering Deviation analysis rel to 2nd Clustering analysis |
0CRMCMC01_Q0001 |
|
CRM Clustering Deviation analysis relative to first Clustering |
0CRMCMC01_Q0002 |
|
Clustering Deviation analysis relative to second Clustering |
0DMCMC01_Q0001 |
|
Clustering Deviation analysis relative to first Clustering analysis |
0DMCMC01_Q0002 |
|
Deviation of CRM Clustering analysis from CRM Decision Tree |
0CRMCMC01_Q0004 |
|
Deviation of CRM Decision Tree analysis from CRM Clustering |
0CRMTMC01_Q0004 |
|
Deviation of Clustering analysis from Decision Tree analysis |
0DMCMC01_Q0004 |
|
Deviation of Decision Tree analysis from Clustering analysis |
0DMTMC01_Q0004 |
|
CRM Decision Tree Deviation analysis rel to 2nd DT analysis |
0CRMTMC01_Q0001 |
|
CRM Decision Tree Deviation analysis rel to 1st DT analysis |
0CRMTMC01_Q0002 |
|
Decision Tree Deviation analysis relative to second DT analysis |
0DMTMC01_Q0001 |
|
Decision Tree Deviation analysis relative to first DT analysis |
0DMTMC01_Q0002 |
Use
The queries for deviation analysis display information about the number of Business Partners or Customers in one analysis, that is, First Analysis, but are not analyzed or present in the Second Analysis.
For the selection of the First Analysis, a variable is provided. The Second Analysis is specified through a variable in the relevant prequery.
In the query CRM
ABC Deviation analysis relative to second ABC Classification
(0CRMAMC01_Q0001), the Second ABC Classification is selected through a
variable in the prequery CRM ABC Classification, BPs in 2nd
analysis (0CRMAMC01_Q0005), whereas the First ABC Classification is specified
through the variable First ABC Classification (0P_AA01).
This query has a symmetric counterpart, which exchanges the role of the first and second analysis: CRM ABC Deviation analysis relative to first ABC Classification (0CRMAMC01_Q0002).
For Deviation Analysis, the following queries have been provided. The first set of queries report on the number of Business Partners (0BPARTNER).
|
Query |
Analysis Type |
Prequery |
Variables |
|
CRM ABC Deviation analysis relative to second ABC Classification (0CRMAMC01_Q0001) |
ABC Classification with ABC Classification |
CRM ABC Classification BPs in 2nd analysis (0CRMAMC01_Q0005) |
|
|
CRM ABC Deviation analysis relative to first ABC Classification (0CRMAMC01_Q0002) |
ABC Classification with ABC Classification |
CRM ABC Classification BPs in 1st analysis (0CRMAMC01_Q0006) |
|
|
Deviation of CRM ABC Classification from CRM Clustering analysis (0CRMAMC01_Q0003) |
ABC Classification with Clustering |
CRM Clustering analysis BPs in 1st analysis (0CRMCMC01_Q0006) |
|
|
Deviation of CRM Clustering analysis from CRM ABC Classification (0CRMCMC01_Q0003) |
Clustering with ABC Classification |
CRM ABC Classification BPs in 1st analysis (0CRMAMC01_Q0006) |
|
|
Deviation of CRM ABC Classification from CRM Decision Tree analysis (0CRMAMC01_Q0004) |
ABC Classification from Decision Tree |
CRM Decision Tree analysis BPs in 1st analysis (0CRMTMC01_Q0006) |
|
|
Deviation of CRM Decision Tree analysis from CRM ABC Classification (0CRMTMC01_Q0003) |
Decision Tree with ABC Classification |
CRM ABC Classification BPs in 1st analysis (0CRMAMC01_Q0006) |
|
|
CRM Clustering Deviation analysis rel to 2nd Clustering analysis (0CRMCMC01_Q0001) |
Clustering with Clustering |
CRM Clustering analysis BPs in 2nd analysis (0CRMCMC01_Q0005) |
|
|
CRM Clustering Deviation analysis relative to first Clustering (0CRMCMC01_Q0002) |
Clustering with Clustering |
CRM Clustering analysis BPs in 1st analysis (0CRMCMC01_Q0006) |
|
|
Deviation of CRM Clustering analysis from CRM Decision Tree (0CRMCMC01_Q0004) |
Clustering with Decision Tree
|
CRM Decision Tree analysis BPs in 1st analysis (0CRMTMC01_Q0006) |
|
|
Deviation of CRM Decision Tree analysis from CRM Clustering (0CRMTMC01_Q0004) |
Decision Tree with Clustering |
CRM Clustering analysis BPs in 1st analysis (0CRMCMC01_Q0006) |
|
|
CRM Decision Tree Deviation analysis rel to 2nd DT analysis (0CRMTMC01_Q0001) |
Decision Tree with Decision Tree
|
CRM Decision Tree analysis BPs in 2nd analysis (0CRMTMC01_Q0005) |
|
|
CRM Decision Tree Deviation analysis rel to 1st DT analysis (0CRMTMC01_Q0002) |
Decision Tree with Decision Tree
|
CRM Decision Tree analysis BPs in 1st analysis (0CRMTMC01_Q0006) |
The second set of queries for Deviation Analysis report on Customers (0CUSTOMER).
|
Query |
Analysis Type |
Prequery |
Variables |
|
ABC Deviation analysis relative to second ABC Classification (0DMAMC01_Q0001) |
ABC Classification with ABC Classification |
||
|
ABC Deviation analysis relative to first ABC Classification (0DMAMC01_Q0002) |
ABC Classification with ABC Classification |
||
|
Deviation of ABC Classification from Clustering analysis (0DMAMC01_Q0003) |
ABC Classification with Clustering |
||
|
Deviation of Clustering analysis from ABC Classification (0DMCMC01_Q0003) |
Clustering with ABC Classification |
||
|
Deviation of ABC Classification from Decision Tree analysis (0DMAMC01_Q0004) |
ABC Classification from Decision Tree |
||
|
Deviation of Decision Tree analysis from ABC Classification (0DMTMC01_Q0003) |
Decision Tree with ABC Classification |
||
|
Clustering Deviation analysis rel to 2nd Clustering analysis (0DMCMC01_Q0001) |
Clustering with Clustering |
||
|
Clustering Deviation analysis relative to first Clustering (0DMCMC01_Q0002) |
Clustering with Clustering |
||
|
Deviation of Clustering analysis from Decision Tree (0DMCMC01_Q0004) |
Clustering with Decision Tree
|
||
|
Deviation of Decision Tree analysis from Clustering (0DMTMC01_Q0004) |
Decision Tree with Clustering |
||
|
Decision Tree Deviation analysis rel to 2nd DT analysis (0DMTMC01_Q0001) |
Decision Tree with Decision Tree
|
||
|
Decision Tree Deviation analysis rel to 1st DT analysis (0DMTMC01_Q0002) |
Decision Tree with Decision Tree
|