最近发现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了。