Query通過APD載入資料到DSO出錯

   最近發現Query作為資料來源，通過APD來將資料載入到DSO時，資料有誤，原來以為這個Query是不是我通過其它Query另存過來導致的。重建了一個Query還是不行，而且發現Query有一部分值是對的有些是不對的。
   在網上搜了一下，發現有以下一段話
Symptom

The data in the Analysis Process Designer is incorrect if you are using a query as the data source. Some key figures are always zero, or the system displays the correct results in incorrect columns. In the Business Explorer and in Transaction RSCRM_BAPI the data is still correct.

Other terms

RSANWB, Analysis Process Designer

Reason and Prerequisites

The error occurs if you are using a query as the data source in the analysis process and if the query contains hidden key figures. The system assigns the key figures of the query to the columns in the analysis process in the incorrect order.
To analyze other data inconsistencies, also see Note 751577 (APD-FAQ: Data source query)

Solution

As a workaround, display the hidden key figures again. The system then fills the results columns correctly.

說是Query是隱藏的關鍵值就會出錯。
我試著修改Query，再修改APD，結果真的OK了。