SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
SQL PassExplanationselect a12.REGION_ID REGION_ID,
sum(a11.TOT_DOLLAR_SALES) WJXBFS1
into #ZZMD00
from CITY_CTR_SLS a11
join LU_CALL_CTR a12
on (a11.CALL_CTR_ID = a12.CALL_CTR_ID)
where a12.REGION_ID in (2, 3, 5)
group by a12.REGION_IDCompute the report level metric. Only some of the Regions in the warehouse will appear in the result.select count(distinct a11.ORDER_ID) WJXBFS1
into #ZZMD01
from ORDER_FACT a11Compute the total number of orders across the entire warehouse.select pa11.REGION_ID REGION_ID,
pa11.WJXBFS1 WJXBFS1,
pa12.WJXBFS1 WJXBFS2
into #ZZOL02
from #ZZMD00 pa11
cross join #ZZMD01 pa12Join the metric results into a single table. This result will have three rows, one for each region allowed in the filter, with the same Count value for each row.select a11.REGION_ID REGION_ID,
a11.REGION_NAME REGION_NAME,
pa12.WJXBFS1 WJXBFS1,
pa12.WJXBFS2 WJXBFS2
from LU_REGION a11
left outer join #ZZOL02 pa12
on (a11.REGION_ID = pa12.REGION_ID)Obtain all the Region attribute elements, outer joined to the result set. The Count metric will exist in this dataset only in rows that have a Revenue value.RegionRevenueCountNortheast Mid-Atlantic3,413,340200,000Southeast2,016,186200,000Central South1,380,991200,000Northwest Southwest England France Germany Canada Web
|
