PSA, ALE IDoc, ODS/DSO的区别
摘要:What is difference between PSA and ALE IDoc? And how data is transferd using each one of them?The following update types are available in SAP BW: 1. PSA 2. ALE (data IDoc)You determine the PSA or IDoc transfer method in the transfer rule maintenance screen. The process for loading the data for both
阅读全文
posted @
2011-12-16 14:32
沧海-重庆
阅读(1051)
推荐(0) 编辑
BW Delta Queue 研究--Update Method
摘要:目前BW Delta Queue支持的三种常见Update Method有:1. "direct delta" update method2. "queued delta" update method3. "unserialized V3 update" update methodMethod 1:"direct delta"当每一单据存入数据库的同时也被作为单独的一个LUW写入BW Delta Queue,这种更新模式优势: a.不需要在OLTP后台设定Job定期来拉取数据写入Delta Queue; b. De
阅读全文
posted @
2011-09-23 12:03
沧海-重庆
阅读(645)
推荐(0) 编辑
SAP BW ODS无效字符自动处理程序
摘要:之前的程序在后面的使用过程中发现了一些Bug,更重要的是ODS激活一遇到错误就自动退出,导致异常只会显示第一条,而实际情况可能会有好几笔类似数据,所以最近做了一些更新。 与之前相比,修正了值存在空格无法更新的Bug外,另外变成对所有的行都进行扫描并找出异常字符进行更新。*&---------------------------------------------------------------------**& Report Z1RD0017*&*&-------------------------------------------------------
阅读全文
posted @
2011-09-23 11:51
沧海-重庆
阅读(1287)
推荐(0) 编辑
BW Delta (增量)更新方法 .
摘要:我们都知道,对于BW来说,很多ECC的标准数据源自带了增量更新功能,每天各种凭证产生的增量数据会自动堆积到增量队列里,然后BW端做一个增量信息包按天把这些增量抽取到数据仓库里,非常轻松自然,对于客户和顾问,都是透明的自动的容易实施的,这也是上过ECC的企业数据仓库采用SAP BW的一个优势所在。但是对于非ECC的一般数据库或者ECC的自定义数据源,做增量更新就苦了。对于ECC的自定义数据源,SAP给了一种标准方案,我们看看这种方法:用一个时间字段或数字字段标记增量,当这个字段在表里的数值变化时,就认为是增量,把这条记录作为增量记录,增量信息包会挑出这些记录传送上去。这种方法的问题是显而易见的,
阅读全文
posted @
2011-09-23 11:49
沧海-重庆
阅读(1158)
推荐(0) 编辑
BW:数据源抽取机制 .
摘要:大部分知识源于TBW350和SAP SDN。对数据源抽取机制的深入探讨一、什么数据源需要初始化,为什么要进行初始化有增量机制的数据源就需要初始化,初始化的目的是为了给系统一个时间点,来生成Delta队列。 怎样进行初始化:其实当我们跑I包的时候,Delta队列就建立了,这个和Setup table没有关系 Setup table是怎么回事儿:在LO(Logistic,后勤)的抽取中,Extractor不允许直接操作应用表,也许是为了方式读写的冲突,也许是为了保证凭证的安全,也许是为了减轻负载…反正就是不行,所以就得在initialization的时候Delete然后Fill Setup tab
阅读全文
posted @
2011-09-23 11:48
沧海-重庆
阅读(3180)
推荐(0) 编辑
BW Delta Management 学习 .
摘要:Delta ProcessABR:Forming deltas with after, before and reverse images that are updated directly in the delta queue, 采用前镜像、后镜像和反转镜像的更新模式,既支持覆盖又支持累加,所以数据源可以更新到DSO或者CUBEAIM/AIMD:Forming deltas with after image, which are updated directly in the delta queue. 采用后镜像模式,只支持覆盖,不支持累加,所以该类型数据源不能直接加载到CUBE,一般会先加
阅读全文
posted @
2011-09-23 11:45
沧海-重庆
阅读(679)
推荐(0) 编辑
How to load and generate a custom hierarchy in SAP Business Warehouse (SAP BW) without using flat files
摘要:IntroductionOften reports need to show data in a tree-like structure. This is enabled via characteristic hierarchies in SAP BW. High level data is displayed using the top nodes of the hierarchy. More detailed data can be visualized by drilling down to the lower nodes of the hierarchy.Consider an exa
阅读全文
posted @
2011-09-23 10:04
沧海-重庆
阅读(2045)
推荐(0) 编辑
What is BI Content?
摘要:BI Content is delivered as an add-on to SAP BI. The full name for this is SAPNetWeaver 7.0 BI Content Add-On 5 – SP04. From here on, it will be referred to as BI Content.PurposeBI Content is a preconfigured set of role and task-related information models that are based on consistent metadata in SAPB
阅读全文
posted @
2011-09-19 17:09
沧海-重庆
阅读(807)
推荐(0) 编辑
Note 888687 - BEx Web Java: Analysis of communication/logon problems
摘要:SummarySymptomThis note describes how to analyze logon problems and communication problems in the area of BEx Web Java. It illustrates ways of analyzing the most common errors and also describes the information that SAP Support require to process messages in this area efficiently.Other termsBEx Web,
阅读全文
posted @
2011-09-15 10:21
沧海-重庆
阅读(7258)
推荐(0) 编辑
BW知识点总结及面试要点
摘要:1. 如何理解数据仓库?数据仓库 是 一个面向主题的,集成的,相对稳定的,反应历史变化的数据集合,用于支持管理决策。2. OLAP 和 OLTP的基本概念 和 区别?Oltp 联机事务处理,就是我们通常所说的关系型数据库,记录了实时的增删改查数据。Olap 联机分析处理,是数据仓库的核心,是对oltp的历史数据进行加工,分析处理,用于处理商业智能,决策支持等重要的决策信息。区别:1.oltp 是明细的数据,olap 是汇总数据2.oltp 记录实时的数据,olap 包含2-3年历史数据3.oltp 可以进行增删改查操作,olap 只支持查询。3. Bw中数据存储的最小单位是什么?他分为哪几种。
阅读全文
posted @
2011-09-09 09:35
沧海-重庆
阅读(8380)
推荐(0) 编辑
BW T-Code List for BWer
摘要:1 RSA1 Administrator Work Bench2 RSA11 Calling up AWB with the IC tree3 RSA12 Calling up AWB with the IS tree4 RSA13 Calling up AWB with the LG tree5 RSA14 Calling up AWB with the IO tree6 RSA15 Calling up AWB with the ODS tree7 RSA2 OLTP Metadata Repository8 RSA3 Extractor Checker9 RSA5 Install Bus
阅读全文
posted @
2011-09-09 09:17
沧海-重庆
阅读(1203)
推荐(1) 编辑
Differences Between a BI/Data Warehouse System and an OLTP System
摘要:. Level of detail: The OLTP layer stores data with a very high level of detail, whereas data in the Data Warehouse is compressed for high-performance access (aggregation).. History: Archiving data in the OLTP area means it is stored with minimal history. The Data Warehouse area requires comprehensiv
阅读全文
posted @
2011-09-06 23:45
沧海-重庆
阅读(272)
推荐(0) 编辑
Definitio of Business Intelligence
摘要:In a Google search for business intelligence, http://whatis.techtarget.com/ attributed the term business intelligence to a September, 1996 Gartner Group report: Business intelligence (BI) is a broad category of applications and technologies for gathering, storing, analyzing, and providing access to
阅读全文
posted @
2011-09-06 23:43
沧海-重庆
阅读(286)
推荐(0) 编辑
Definition of warehouse
摘要:A warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process. Also can define as : the subset of a Business Intelligence tool set responsible for modeling, structuring, storing as well as extraction translation
阅读全文
posted @
2011-09-06 23:43
沧海-重庆
阅读(246)
推荐(0) 编辑