Posted on 2008-11-19 17:12
沙漠中的魚 閱讀(1756)
評論(0) 編輯 收藏 所屬分類:
Cognos開發(fā)
今天在修改Framework Manager中對Query Object時，發(fā)現(xiàn)了一個不解的問題，現(xiàn)在貼出現(xiàn)，希望有誰能幫忙解決一下
我雙擊新鍵的Query Object,彈出如下對話框
我修改SQL對話框中SQL，設(shè)置查詢其中某一個對象
點擊查詢,出現(xiàn)了如下錯誤
This query contains an error and can not be executed.
It is recommended that you view the query feedback on the "Query Information" tab.
RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-56'.
UDA-SQL-0115 Inappropriate SQL request.
UDA-SQL-0564 [Microsoft SQL Native Client]Deferred prepare could not be completed.
UDA-SQL-0564 [Microsoft SQL Native Client]Statement(s) could not be prepared. (SQLSTATE=42000, SQLERRORCODE=8180)
UDA-SQL-0564 [Microsoft SQL Native Client]The multi-part identifier "PRODUCT.PRODUCT_NUMBER" could not be bound. (SQLSTATE=42000, SQLERRORCODE=4104)
我手動修改一下SQL語句，給表加了一個別名,點擊test選項卡，沒有報錯，如下
點擊test選擇卡頁面中的Test Sample沒有出現(xiàn)問題,查詢出數(shù)據(jù)
附：我第一次這樣測試查詢數(shù)據(jù)時出現(xiàn)如下警告,說有沖突，但是不知道是什么原因
The following warning has been detected. Press OK to continue with the operation.
BMT-MD-0059 The removal of the following objects will impact the objects that directly use them or their children:
PRODUCT_NUMBER
BASE_PRODUCT_NUMBER
INTRODUCTION_DATE
DISCONTINUED_DATE
PRODUCT_TYPE_CODE
PRODUCT_COLOR_CODE
PRODUCT_SIZE_CODE
PRODUCT_BRAND_CODE
PRODUCTION_COST
GROSS_MARGIN
PRODUCT_IMAGE
These impacts are listed below. These impacts may also propagate to other objects that indirectly use the above objects.
BMT-MD-0060 determinant "PRODUCT_NUMBER" will be deleted.