今天遇到一個很奇怪的問題,激活DSO時數據丟失:我有3個欄位的值是通過End Routine獲得的數據,在DSO的new data表查看,數據沒有問題,那3個欄位的值是正常的,但是激活之後,那3個欄位的值就變成了初始值。現在數據流是:DSO1-->DSO2。之前我也做過,將DSO1的數據導入Cube,那3個欄位的值也是通過End Routine計算得到,數據完全沒有問題。
如下信息是從SDN上獲得的解決方法:
Is the key figure populated using the end routine in the transformation? If yes then plz do the below steps:
1. Define the rule type of the KF either as initial or constant. Dont leave it without any rule type.(This is just work around to solve the problem)
2. The end routine will pass the value to the KF based on the logic which you have written irrespective of the rule type you defined.
3. Activate the transformation and then load the data to the DSO.
參照上面的方法,在Transfermation中將那3個欄位初始化之後,再激活重新導入數據即可。
現在還有一點不明白的地方:數據流在BW是datasource-->PSA-->Tranfermation-->DSO New Data -->DSO Active data,爲什麽Tranfermation的設置會影響到後面new data table寫入數據到Active data table?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23947343/viewspace-680815/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23947343/viewspace-680815/