When we are capturing our drill through query to the details, a condition of
1 = 0 is being placed where normally the vairables are set to define which
cell is being drilled through. We are using AS2000, with ORACLE as the
underlying database.

One time the query would be (this one works): (one cell, but same level)
SELECT "WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."LAST_ISSUE_DATE",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."CYCLE_COUNT_CODE",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."INV_ON_HAND_QTY",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."INV_ON_HAND_AMT",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."INV_MIN_QTY",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."INV_MAX_QTY",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."TRAN_ISSUE_AMT",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."TRAN_ISSUE_QTY",
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V". "WAREHOUSE_CODE",
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V". "STOREROOM",
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V". "PRIMARY_BIN",
"WAREHOUSE_ADMIN"."TBL_VENDOR_VIEW"."VENDOR_SUFFIX ",
"WAREHOUSE_ADMIN"."TBL_VENDOR_VIEW"."VENDOR_NAME",
"WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."MONTH_NUMBER _IN_YEAR",
"WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."YEAR",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."PEAB ODY_NUMBER",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."ITEM _DESC",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."COMP ONENT_TYPE",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."APPL ICATION_CORP",
"WAREHOUSE_ADMIN"."ORS_MANUFACTURER_DIM_VIEW"."MAN UFACTURER_ABBR",
"WAREHOUSE_ADMIN"."ORS_ABC_CODE_DIM_VIEW"."ABC_COD E",
"WAREHOUSE_ADMIN"."ORS_MATERIAL_TYPE_DIM_VIEW"."MA TERIAL_TYPE_CODE",
"WAREHOUSE_ADMIN"."ORS_REORDER_CODE_DIM_VIEW"."REO RDER_CODE",
"WAREHOUSE_ADMIN"."ORS_ITEM_USAGE_TYPE_DIM_VIEW"." ITEM_USAGE_TYPE_CODE"
FROM "WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ,
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM _V"
, "WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW", "WAREHOUSE_ADMIN"."TBL_VENDOR_VIEW",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW",
"WAREHOUSE_ADMIN"."ORS_MANUFACTURER_DIM_VIEW"
, "WAREHOUSE_ADMIN"."ORS_ABC_CODE_DIM_VIEW",
"WAREHOUSE_ADMIN"."ORS_MATERIAL_TYPE_DIM_VIEW"
, "WAREHOUSE_ADMIN"."ORS_REORDER_CODE_DIM_VIEW",
"WAREHOUSE_ADMIN"."ORS_ITEM_USAGE_TYPE_DIM_VIE W"
WHERE (("WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."LAST_DAY_I N_MONTH_FLAG" = - 1))
AND (("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_ V"."INV_LOC_WHID" =
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V". "INV_LOC_WHID")
AND ("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."VENDOR_WHID" =
"WAREHOUSE_ADMIN"."TBL_VENDOR_VIEW"."VENDOR_WHID")
AND ("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."TIME_KEY" =
"WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."TIME_KEY ")
AND ("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."ITEM_WHID" =
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."ITEM _WHID")
AND ("WAREHOUSE_ADMIN"."ORS_MANUFACTURER_DIM_VIEW"."MA NUFACTURER_WHID" =
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."MANU FACTURER_WHID")
AND ("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."USER_CODE" =
"WAREHOUSE_ADMIN"."ORS_ABC_CODE_DIM_VIEW"."USER_CO DE")
AND ("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."MATERIAL_TYPE_WHID" =
"WAREHOUSE_ADMIN"."ORS_MATERIAL_TYPE_DIM_VIEW"."MA TERIAL_TYPE_WHID")
AND ("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."REORDER_CODE_WHID" =
"WAREHOUSE_ADMIN"."ORS_REORDER_CODE_DIM_VIEW"."REO RDER_CODE_WHID")
AND ("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."ITEM_USAGE_WHID" =
"WAREHOUSE_ADMIN"."ORS_ITEM_USAGE_TYPE_DIM_VIEW"." ITEM_USAGE_WHID"))
AND ("WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V" ."WAREHOUSE_GROUP" = :
V00001)
AND ("WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."MONTH_NUMBE R_IN_YEAR" = :V00002)
AND ("WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."QUARTER" = :V00003)
AND ("WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."YEAR" = :V00004)

One time the query would be (this one doesn't works): (different cell, but
same level)
SELECT "WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."LAST_ISSUE_DATE",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."CYCLE_COUNT_CODE",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."INV_ON_HAND_QTY",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."INV_ON_HAND_AMT",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."INV_MIN_QTY",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."INV_MAX_QTY",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."TRAN_ISSUE_AMT",
"WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ."TRAN_ISSUE_QTY",
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V". "WAREHOUSE_CODE",
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V". "STOREROOM",
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V". "PRIMARY_BIN",
"WAREHOUSE_ADMIN"."TBL_VENDOR_VIEW"."VENDOR_SUFFIX ",
"WAREHOUSE_ADMIN"."TBL_VENDOR_VIEW"."VENDOR_NAME",
"WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."MONTH_NUMBER _IN_YEAR",
"WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."YEAR",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."PEAB ODY_NUMBER",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."ITEM _DESC",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."COMP ONENT_TYPE",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."APPL ICATION_CORP",
"WAREHOUSE_ADMIN"."ORS_MANUFACTURER_DIM_VIEW"."MAN UFACTURER_ABBR",
"WAREHOUSE_ADMIN"."ORS_ABC_CODE_DIM_VIEW"."ABC_COD E",
"WAREHOUSE_ADMIN"."ORS_MATERIAL_TYPE_DIM_VIEW"."MA TERIAL_TYPE_CODE",
"WAREHOUSE_ADMIN"."ORS_REORDER_CODE_DIM_VIEW"."REO RDER_CODE",
"WAREHOUSE_ADMIN"."ORS_ITEM_USAGE_TYPE_DIM_VIEW"." ITEM_USAGE_TYPE_CODE"
FROM "WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V" ,
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V",
"WAREHOUSE_ADMIN"."TBL_VENDOR_VIEW",
"WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW",
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW",
"WAREHOUSE_ADMIN"."ORS_MANUFACTURER_DIM_VIEW",
"WAREHOUSE_ADMIN"."ORS_ABC_CODE_DIM_VIEW",
"WAREHOUSE_ADMIN"."ORS_MATERIAL_TYPE_DIM_VIEW" ,
"WAREHOUSE_ADMIN"."ORS_REORDER_CODE_DIM_VIEW",
"WAREHOUSE_ADMIN"."ORS_ITEM_USAGE_TYPE_DIM_VIE W"
WHERE (("WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."LAST_DAY_I N_MONTH_FLAG" = -1))
AND (("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_ V"."INV_LOC_WHID" =
"WAREHOUSE_ADMIN"."ORS_WAREHOUSE_HIERARCHY_DIM_V". "INV_LOC_WHID") AND
("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."VENDOR_WHID" =
"WAREHOUSE_ADMIN"."TBL_VENDOR_VIEW"."VENDOR_WHID") AND
("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."TIME_KEY" =
"WAREHOUSE_ADMIN"."TBL_TIMEDIM_VIEW"."TIME_KEY ") AND
("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."ITEM_WHID" =
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."ITEM _WHID") AND
("WAREHOUSE_ADMIN"."ORS_MANUFACTURER_DIM_VIEW"."MA NUFACTURER_WHID" =
"WAREHOUSE_ADMIN"."ORS_ITEM_MASTER_DIM_VIEW"."MANU FACTURER_WHID") AND
("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."USER_CODE" =
"WAREHOUSE_ADMIN"."ORS_ABC_CODE_DIM_VIEW"."USER_CO DE") AND

("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."MATERIAL_TYPE_WHID" =
"WAREHOUSE_ADMIN"."ORS_MATERIAL_TYPE_DIM_VIEW"."MA TERIAL_TYPE_WHID")
AND

("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."REORDER_CODE_WHID" =
"WAREHOUSE_ADMIN"."ORS_REORDER_CODE_DIM_VIEW"."REO RDER_CODE_WHID") AND
("WAREHOUSE_ADMIN"."ORS_MMS_INVENTORY_FACTS_CUBE_V "."ITEM_USAGE_WHID" =
"WAREHOUSE_ADMIN"."ORS_ITEM_USAGE_TYPE_DIM_VIEW"." ITEM_USAGE_WHID"))
AND (1 = 0)


--
Sue

I don't know specifically about this bug / issue, but in general this is a
common trick that Analysis Services (and others) use to determine metadata.
We first issue a query with 1=0 in the WHERE clause. This then returns
metadata about the resultset, with little overhead since most modern query
optimizers would optimize away the WHERE clause comparing two constants and
not really even scan the table. Then once we have the metadata we can
re-issue the query. It sounds like we are issuing the first half but not the
second.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Susan De" <SusanDe (AT) discussions (DOT) microsoft.com> wrote