SAP BW学习方法总结(8)

SAP培训：http://www.51sap.cn 29. 无法在formula中使用keyfigure的result

http://help.sap.com/saphelp_nw04/helpdata/en/4d/af1dc766d5df44bfdb76f7e54d16e2/content.htm

Interpretation of the Results Rows In the results rows for a query, the basic results and not the necessary totals are displayed. For example, results rows might not include totals in the following cases:

? Conditions are active

See Conditions.

? Exception aggregations (such as with the first value, minimum, or average) are used

See Tab Page: Aggregation (in the InfoObject maintenance) or Properties of the Calculated Key Figure under Aggregational Behavior (in the BEx Query Designer). ? Calculations are made

See Defining Formulas, Defining Calculated Key Figures.

If you want to keep the totals in the results row, use the function Calculate Results As... ? Summation (or you could also use other aggregation forms).

Note that these local calculations only change the display of the values. With subsequent calculations, the system does not use this for the display of the changed value, but rather the original value specified by the OLAP processor. The functions Cumulation and Normalization act similarly with key figures. The original value specified by the OLAP processor is summed and cumulated or is displayed as standardized. With subsequent calculations, the system does not use this cumulated or standardized value displayed, but rather the original value. You can set the functions Cumulation and Normalization in the Query Designer (Properties of the Selection/Formula), in the Ad-hoc Query Designer on the Web (Properties of the Selection/Formula), with the Web analysis (Local Properties of a Key Figure) and in the BEx Analyzer (OLAP Functions for Active Cells).

It is not possible to use the values changed for the display in other calculations.

If you use two structures in the query, then you can execute calculations for individual cells in these two structures. See Defining Exception Cells (in the Query Designer).

（试试看在数据模型级别创建calculated kf，然后设置“aggregation”）

SAP培训：http://www.51sap.cn 30. 对采购收货，会产生2条delta。已收货数量等字段会被更新

31. 对发票出具会计凭证时，能够产生delta 32. Exception TYPELOAD_NEW_VERSION

在激活ODS中的请求时abap dump。需要重新激活ODS。

33. 为BI CONTENT数据源添加key figure字段时，一般数量、金额字段取反，单价字段不取反。

34. 在角色里隐藏文件夹按钮：设置S_RS_FOLD为X

SAP培训：http://www.51sap.cn 35. Update rule激活时报错，Empty or invalid formula

可以把用公式的各个key figure设置为不更新，看看能不能激活。如果可以，逐一将这些key figure设置为覆盖或更新，然后检查出是哪个key figure出错。最后对导致报错的key figure重新建一下公式即可。

36. Workbook里几个query用到相同的输入条件

可以用“客户出口”类型的变量。

37. 开发机的query传输到生产机之后，可以在RSA1的传输连接里点“BEX请求”。之后修改query将不在报错 38. 对导航属性设置权限

SAP培训：http://www.51sap.cn

39. 执行Infopackage用户的权限

40. 打上“小写字母”，激活有主数据的信息对象时，去掉alpha.

SAP培训：http://www.51sap.cn 41. 系统自动生成的信息包：自建ODS更新到新的ODS时，要复制源数据（以8开头）

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库SAP BW学习方法总结(8)在线全文阅读。