
SAP BW/BI/BO
you_tube
BEGIN 上网; EXCEPTION WHEN mm THEN 逮住; WHEN OTEHRS THEN NULL;END;
展开
-
获利分析的两种方式比较
.基于成本核算和基于帐户的获利分析比较CO-PA模块有两种获利分析,基于帐户和基于成本的获利分析,两者联系与区别、利弊如何?a.costing-base采用value field,可对应到cost/Revenue成本要素、MM|SD的条件类型或产品成本部件等,而accou转载 2011-09-05 13:37:20 · 384 阅读 · 0 评论 -
week 53 issue in 0calweek
It wont as the occurence of a 53rd week is internationally standardized. The check in BW follows these international conventions which count原创 2011-09-07 11:02:42 · 416 阅读 · 0 评论 -
Useful functions for Data Transformation
Functions for Data TransformationRSAU_READ_MASTER_DATAVery often you need to read a characteristic's [attribute] during a data transform原创 2011-08-14 12:38:10 · 239 阅读 · 0 评论 -
Intermediate Process Stuck in a Process chain?
SummaryThis WIKI provides solution to finish jobs which are stuck in an intermediate process within a process chain.Scenario(s):-1转载 2011-08-14 21:29:14 · 238 阅读 · 0 评论 -
Write Optimized DSO
Write Optimized DSO The concept of Write Optimized DSO was introduced in BI-7.0. Write Optimized DSO unlike Standard DSO has only one rela转载 2011-08-14 21:46:40 · 341 阅读 · 0 评论 -
To delete the Data load request except the latest data load in SAP BW
I would like to share a interesting scenario where we are having full data loads (Planning Data) in the infocube on daily basis and our requ转载 2011-08-14 22:27:12 · 2127 阅读 · 0 评论 -
BEx: How to delete workbook?
In Bex Analyzer, first, you don't see the technical name of a workbook, you also can't delete them.In our system, several workbooks are cr原创 2011-08-22 15:37:58 · 284 阅读 · 0 评论 -
BW:关于初始化结构
首先,LBWQ或者SMQ1,这是Outbound Queue,必须要删的,如果提取结构没改还好,如果改了,LIS的抽取JOB一定会报错的。因为新的业务数据会先保存在Outbound Queue,然后抽取到Delta Queue里面,周期为1H(可以在LBWE里面计划的)转载 2011-08-22 15:51:38 · 646 阅读 · 1 评论 -
SAP Notes
855383 - Installation of SAP SEM Release 6.0848462 - DB2-z/OS: BW: Aggregate setup after physical partitioning834343 - Oracle 9.2 Plat转载 2011-08-22 16:22:53 · 433 阅读 · 0 评论 -
SDN上收集到的SAP BI的极好文章的链接
1)Overviewhttps://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60981d00-ca87-2910-fdb8-d4a2640d69d4Volume Testing for SAP转载 2011-08-22 16:19:45 · 586 阅读 · 0 评论 -
Pseudo Delta
Pseudo DeltaWhy to go for the Function Module based Extractor using Pseudo Delta?• If there is no Standard Extractors which satisfy the原创 2011-08-28 10:29:00 · 237 阅读 · 0 评论 -
数据源增量管理DELTA
SAP中的增量机制,可以有助系统提高数据抽取效率,在初始化执行后,每天只更新新增和修改了的记录。在我们正常的使用或开发中,这些东西并不需要知道,只要数据正常上载,就好了,此处所介绍的内容之为大家参考用。在介绍DELTA机制之前,先介绍下DSO和CUBE:DSO:一般DSO原创 2011-08-28 10:53:19 · 474 阅读 · 0 评论 -
idoc 和 bapi 和 rfc 之间的区别
se37写出来的叫function,其中可以远程调用的叫rfc,remote-enabled function,abap语法和输入输出参数就会有一些限制。bapi是sap做好的实现特定业务操作的rfc。idoc是基于sap自己的类似xml格式的文档数据交换的方式。rfc必须在线的转载 2011-08-29 09:48:32 · 390 阅读 · 0 评论 -
What are the steps to create RFC connection on Business Warehouse?
Step1 :- On the BW side :- 1. Create a logical System. SPRO->ALE-> Sending &Receiving Systems -> Logical System-> New Entries (E.g 800 BW原创 2011-08-29 10:04:01 · 283 阅读 · 0 评论 -
承诺行项目抽不到订单更改的数据
用户反映WBS项目执行报表有issue,报表中的未使用的承诺金额有负数,经过核实数据源0CO_OM_WBS_7中的数据会比较晚一点到达数据源,,,相关Notes:SAP Note 1279672 - Commitment deletion records not extrac原创 2011-10-14 09:42:23 · 199 阅读 · 0 评论 -
如何删除BW中的workbook
To delete a workbook, use function moduleRRMX_WORKBOOKS_DELETE (execute using Transaction SE37 and Test).Give the parameters workbook ID (原创 2011-10-11 13:57:01 · 904 阅读 · 0 评论 -
BW--BW访问接口列表(摘自sap library)
InterfaceService:ReadWriteDisplay *Programming LanguageMass Data SupportBackground/DialogTypePrerequisitesDB ConnectWABAPX原创 2011-11-16 09:32:03 · 297 阅读 · 0 评论 -
SAP BI Related Notes
Index related notes:402469 Addtional indexes on master data tables356333 ORA Fragmentation178275 ORA bitmap indexes157918 Missing indexes323090 Generated i原创 2011-11-20 11:29:42 · 338 阅读 · 0 评论 -
BW之数据源增量管理DELTA
SAP中的增量机制,可以有助系统提高数据抽取效率,在初始化执行后,每天只更新新增和修改了的记录。在我们正常的使用或开发中,这些东西并不需要知道,只要数据正常上载,就好了,此处所介绍的内容之为大家参考用。在介绍DELTA机制之前,先介绍下DSO和CUBE:DSO:一般DSO用来存储明细数据,其结构比较简单。对于值的转换(决定了可用的DELTA类型),既可以使用合计,也可以使用覆盖的方式。激活转载 2011-11-04 10:53:38 · 278 阅读 · 0 评论 -
BI暴力激活函数或程序
RSAOS RSAOS_TRANSTRUCTURE_ACTIVATE RSTRAN_GUI RSTRAN_BACK_TO_ACTIVE_VERSION 暴力激活MultiProviderRSDG_MPRO_ACTIVATE 暴力激活DSO(这个有风险!!会导致相关的转换,DTP,以及上层模型变灰)RSDG_ODSO_ACTIVA原创 2011-11-04 10:45:44 · 281 阅读 · 0 评论 -
数据源初始化
初始化数据源包括以下步骤:1.数据源的Delta初始化结构保存2.在信息包中检查包的所有数据3.请求变绿,delta队列已经生成在很多应用中,当Delta正在初始化业务处理必须停止 Situation A: The delta process must be initialized successfully (including generating the delta qu翻译 2011-11-04 16:14:20 · 602 阅读 · 0 评论 -
SAP总账主数据及会计科目组
总账主数据主数据介绍是描述那些运用在会计、物料、供应商、客户等业务过程中的对象,在一段期间内,信息往往保持不变每个主数据有单一的名字或者数字编号--总账主数据:S--供应商主数据:K--客户主数据:D--资产主数据:A--物料主数据:M科目表清单科目表指所有会计科目的结构表会计科目表能分给几个公司代码,但一个公司代码只能有一个会计科目表你可以通过原创 2011-12-18 22:31:27 · 1880 阅读 · 0 评论 -
Bi/Bw面试题
1.Promotion detail information如何在BW中取得? 2.如何取得weekly stock,monthly stock by article(quantity,inventory value)?(已经在使用BI content infocube:0IC_C03) 3.对于trasaction data,在r3做过enhancement的时候,加上原创 2011-12-12 14:04:30 · 1878 阅读 · 0 评论 -
BW Delta Queue 研究--Update Method
目前BW Delta Queue支持的三种常见Update Method有:1. "direct delta" update method2. "queued delta" update method3. "unserialized V3 update" update method Method 1:"direct delta" 当每一单据存入数据库的同时也被作为单独的原创 2011-12-12 14:25:22 · 326 阅读 · 0 评论 -
Variable Types
DefinitionThe type of variable being used. This determines the object that the variable represents as a placeholder for a concrete value.StructureThere are different types of variables depending原创 2012-01-16 10:29:36 · 363 阅读 · 0 评论 -
BW Glossary, Definitions and Explanations
AAggregateAn aggregate is a subset of an InfoCube. The objective when using aggregates is to reduce I/O volume.The BW OLAP processor selects an appropriate aggregate during a query run or a naviga转载 2012-01-30 17:08:07 · 471 阅读 · 0 评论 -
WBS年终预算结转问题
期未用户在R3系统中通过COCJ将项目预算结转,结果发现预算没有在数据源0co_om_wbs_8中出现,经过一番查实,原来是Notes没有打上,得需要增加相关BPXX_VTYPE的配置,使用ZCOSP_VTYPE_ADD、ZFILL_BPXX_VTYPE程序执行就OK了..Ref content:https://websmp230.sap-ag.de/sap(bD16aCZjPTAwMQ=原创 2012-01-30 14:37:45 · 804 阅读 · 0 评论 -
提高激活DSO数据的性能
在激活DSO数据的过程中,有可能会遇到一些系统性能瓶颈,以下是一些提高激活速度的实用技巧:1.清理后台不必要的系统进程tcode:RSBTCDEL2, SM65 ==2.更新统计信息更新统计信息主要是更新数据库表的statistics,为啥要更新这statistics?因为数据库查询引擎是根据statistics来做查询执行计划的,这是数据库高水位(high-waterle原创 2012-01-30 15:53:33 · 506 阅读 · 0 评论 -
How to Restore Query into Older Version
PurposeTo outline the procedure to restore queries that have been migrated to 7.0 back to 3.x.OverviewOnce older verion (3.x) queries are migrated into latest version (7.0), Query can be restore转载 2012-01-31 09:45:07 · 262 阅读 · 0 评论 -
BSEG与BSIS、BSAS、BSID、BSAD、BSIK、BSAK之间的关系
BSEG和BSIS、BSAS、BSID、BSAD、BSIK、BSAK六个表的关系BSAS+BSIS+BSAK+BSIK+BSAD+BSID = BSEGcleared │ opened -------------------------------- BSAS │ BSIS ==>all GL documents BSAK │原创 2012-01-31 10:44:06 · 264 阅读 · 0 评论 -
Where-used Search for Queries, Views, Workbooks, Webtemplates, Cubes
Introduction. This program is based on idea from ABAP published by Rajiv Deshpande November 5, 2006 on SDN.Program has been extended to include Query Views, Webtemplates and their connections to C转载 2012-01-31 11:07:40 · 522 阅读 · 0 评论 -
SID generation during DSO request activation
PurposeThe purpose of this page is to clarify the understanding of SID generation during activation of DataStore (DSO) requests.OverviewThe topics covered here include what happens during the转载 2012-01-31 09:51:55 · 366 阅读 · 0 评论 -
Process chain error with error message no RSM3012
Solution for Process chain error with error message no RSM3012.Company: ERP and ERPSCENARIO:Having the requirement, to load the data from the data source in ECC 6.0 to BI 7.0 System. According t转载 2012-01-31 09:59:58 · 295 阅读 · 0 评论 -
BI Statistics Tables
These are some of the BI Statistics tables . You can find the runtimes and other necessary details of the BI objects in these tables . These tables are part of the BI Admincockpit .For BW 3.5 :1转载 2012-01-31 10:03:37 · 339 阅读 · 0 评论 -
SAP各模块字段与表的对应关系
Customer MasterKNA1 Customer Basic DataKNB1 Customer Company Level Data客户的公司数据KNVV Customer Sales Level Data 客户的销售数据转载 2012-01-31 22:33:38 · 1148 阅读 · 0 评论 -
0ACCOUNT&0GL_ACCOUNT
In BW,a compound attribute differentiates a characteristic to make the characteristic uniquely identifiable. the infoobject for GL Account is 0GL_ACCOUNT. However, in both 0ACCOUNT and 0GL_ACCOUN原创 2012-02-10 13:12:04 · 341 阅读 · 0 评论 -
Entries in Transaction SM58 are in status "Transaction recorded"
Known problems:857126 Incorrect tRFCs from BW are not processed in SM58784414 Transaction recorded in SM58 in a BW application527481 tRFC or qRFC calls are not processedA screen similar to t转载 2012-02-12 11:40:58 · 859 阅读 · 0 评论 -
SAP Query应用指南
SAP Query操作手册QUERY是SAP提供的方便无编程基础用户的报表工具,使用图形化的界面,让用户托托拽拽就能轻松完成报表编写。Query的操作简单,包括建立用户组、建立信息集和建立查询报表,分别对应Tcode:SQ01/SQ02/SQ03,下面以资产全息查询报表的建立介绍Query操作的完整理步骤。一.建立Query用户组(Tcode:SQ03)如上图,你可能为各个模块建立转载 2012-02-24 13:50:35 · 814 阅读 · 0 评论 -
获利能力分析的超级应用
序号字段说明 获利能力分析的超级用1大区代码2大区名称3公司代码4公司名称5销售组织代码6销售组织名称7渠道代号8渠道名称9系统编号10系统名称11业务区代码12业务区名称13区块转载 2012-02-24 15:56:23 · 959 阅读 · 0 评论 -
Change point cause Datasource 0CUSTOMER_ATTR data extraction error
When i execute an extraction through a master data datasource(e.g. 0CUSTOMER_ATTR)I'm getting issues as beblowJob cancelled in source system(RSM078)SAP中实现分布式的一个机制就是ALE/IDoc,而在具体一点就是change point。原创 2012-02-28 14:18:36 · 426 阅读 · 0 评论