摘要: BW Query PerformanceQuestion: 1. What kind of tools are available to monitor the overall Query Performance?Answers: o BW Statistics o BW Workload Analysis in ST03N (Use Export Mode!) o Content of Table RSDDSTATQuestion: 2. Do I have to do something to enable such tools?Answer: o Yes, you need to tur
阅读全文posted @ 2011-12-16 15:26 SAP 沧海 阅读(60) 评论(0)
编辑摘要: Below are some of the errors in a support project which will be a great help for new learners:1) RFC connection lost. A) We can check out in the SM59 t-code RFC Destination + R/3 connection CRD client (our r/3 client) double click..test connection in menu2) Invalid characters while loading. A) Chang
阅读全文posted @ 2011-12-16 15:15 SAP 沧海 阅读(32) 评论(0)
编辑摘要: What type of activities we perform in IMPLEMENTATION project? Will we start from modeling stage or interact with R/3?Responsibilities of an implementation projectFor ex, Lets say If its a fresh implementation of BI or for that matter you are implementing SAP.First and foremost will be your requireme
阅读全文posted @ 2011-12-16 15:05 SAP 沧海 阅读(30) 评论(0)
编辑摘要: What is the role of consultant has to play if the title is BW administrator? What is his day to day activity and which will be the main focus area for him in which he should be proficient?BW Administartor - is the person who provides Authorization access to different Roles, Profiles depending upon t
阅读全文posted @ 2011-12-16 14:54 SAP 沧海 阅读(32) 评论(0)
编辑摘要: Difference Between BW Technical and FunctionalIn general Functional means, derive the funtional specification from the business requirement document. This job normally is done either by the business analyst or system analyst who has a very good knowledge of the business. In some large organizations
阅读全文posted @ 2011-12-16 14:52 SAP 沧海 阅读(21) 评论(0)
编辑摘要: Give details of any standard BI report that are relevant to Purchasing?Answer: For any Reports you just go to RSRREPDIR table and execute it and see the cube wise/module wise reports. Eg: Give cube = 0PUR* then execute it will display all reports. Then take COMPUID goto RSZELTTXT table and give th..
阅读全文posted @ 2011-12-16 14:46 SAP 沧海 阅读(29) 评论(0)
编辑摘要: In RSMO, We have to check the successful, running and failed objects.When you select Successful one it shows how many records are there in the source system and how many records will be added to BW.RSMO Transaction is same like Monitor Screen when you schedule any Info Package and monitor.Only diffe
阅读全文posted @ 2011-12-16 14:44 SAP 沧海 阅读(16) 评论(0)
编辑摘要: Is it possible to copy a process chain in BW 3.1? If so, how?In RSPC, double click the process chain so that you can see it in the left hand pane. In the box where you type in the transaction code, type COPY and hit Enter.
阅读全文posted @ 2011-12-16 14:41 SAP 沧海 阅读(18) 评论(0)
编辑摘要: Step by step procedure for transporting in BW:1. In RSA1 go to Transport Connection 2. Select Object Types Your Object that you want to transfer. 3. Choose grouping method (in data flow before and after) 4. Drag and drop your object. 5. Click the Truck button to transfer 6. In Source System (e.g Dev
阅读全文posted @ 2011-12-16 14:40 SAP 沧海 阅读(18) 评论(0)
编辑摘要: How to transport a specific info object? I tried to change it and then save but the transport request won't appear. How to manually transport that object?1. Administrator Workbench (RSA1), then Transport Connection 2. Object Types, then from the list of objects put the requested one on the right
阅读全文posted @ 2011-12-16 14:38 SAP 沧海 阅读(17) 评论(0)
编辑摘要: What is the best way to transport process chains to test system? I got many other additional and unwanted objects got collected when I tried for collection of process chains from transport connection.To transport a process chain the best is to transport only objects created for the process chain. On
阅读全文posted @ 2011-12-16 14:36 SAP 沧海 阅读(16) 评论(0)
编辑摘要: 1. Why there is frequent load failures during extractions? and how they are going to analyse them?If these failures are related to Data,, there might be data inconsistency in source system..though you are handling properly in transfer rules. You can monitor these issues in T-code -> RSMO and PSA
阅读全文posted @ 2011-12-16 14:35 SAP 沧海 阅读(33) 评论(0)
编辑摘要: 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 SAP 沧海 阅读(30) 评论(0)
编辑
摘要: 目前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 SAP 沧海 阅读(90) 评论(0)
编辑摘要: 之前的程序在后面的使用过程中发现了一些Bug，更重要的是ODS激活一遇到错误就自动退出，导致异常只会显示第一条，而实际情况可能会有好几笔类似数据，所以最近做了一些更新。 与之前相比，修正了值存在空格无法更新的Bug外，另外变成对所有的行都进行扫描并找出异常字符进行更新。*&---------------------------------------------------------------------**& Report Z1RD0017*&*&-------------------------------------------------------
阅读全文posted @ 2011-09-23 11:51 SAP 沧海 阅读(88) 评论(0)
编辑摘要: 我们都知道，对于BW来说，很多ECC的标准数据源自带了增量更新功能，每天各种凭证产生的增量数据会自动堆积到增量队列里，然后BW端做一个增量信息包按天把这些增量抽取到数据仓库里，非常轻松自然，对于客户和顾问，都是透明的自动的容易实施的，这也是上过ECC的企业数据仓库采用SAP BW的一个优势所在。但是对于非ECC的一般数据库或者ECC的自定义数据源，做增量更新就苦了。对于ECC的自定义数据源，SAP给了一种标准方案，我们看看这种方法：用一个时间字段或数字字段标记增量，当这个字段在表里的数值变化时，就认为是增量，把这条记录作为增量记录，增量信息包会挑出这些记录传送上去。这种方法的问题是显而易见的，
阅读全文posted @ 2011-09-23 11:49 SAP 沧海 阅读(157) 评论(0)
编辑摘要: 大部分知识源于TBW350和SAP SDN。对数据源抽取机制的深入探讨一、什么数据源需要初始化，为什么要进行初始化有增量机制的数据源就需要初始化，初始化的目的是为了给系统一个时间点，来生成Delta队列。 怎样进行初始化：其实当我们跑I包的时候，Delta队列就建立了，这个和Setup table没有关系 Setup table是怎么回事儿：在LO（Logistic，后勤）的抽取中，Extractor不允许直接操作应用表，也许是为了方式读写的冲突，也许是为了保证凭证的安全，也许是为了减轻负载…反正就是不行，所以就得在initialization的时候Delete然后Fill Setup tab
阅读全文posted @ 2011-09-23 11:48 SAP 沧海 阅读(222) 评论(0)
编辑摘要: 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 SAP 沧海 阅读(72) 评论(0)
编辑摘要: 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 SAP 沧海 阅读(91) 评论(0)
编辑
摘要: 在前面的帖子中，提到印度人讲英语，发音很不标准，我们中国人几乎听不懂。事实上，这种现象在某些前英国殖民地国家很普遍。比如在巴布亚新几内亚，当地人的英语发音也是很不标准，他们将color(颜色)念成kala，将country(国家)念成kantri，将power(力量)念成pawa，等等，久而久之，当地人干脆不再使用英语了(不再说了，不再写了)，转而使用他们自己创造的这种新语言，也就是kala、kantri、pawa等，而且这种新语言，也不再叫English了，当地人起了一个新名字，叫做Tok Pisin(托克皮辛语)。 在语言学上，以某种语言为基础，夹杂当地土著语言的词汇，派生出来的新语言，.
阅读全文posted @ 2011-09-12 11:26 SAP 沧海 阅读(43) 评论(0)
编辑摘要: 最近一段时间，国内就英语普及的问题争论颇为激烈。赞成全民学英语者认为，英语是适应全球化浪潮的一个重要交流工具，可以让中国不再失去追赶世界潮流的机会，及早跨进发达国家的行列；而反对者则认为，现在不管从事什么职业和专业，只要是职称晋升或择业考试，英语都是必考科目，让国人花大量时间精力甚至金钱去学英语，而相当一部分人根本就用不上英语，学了白学。甚至有人指责英语已经成为扼杀中国人才的毒瘤。这种争论自然是公说公有理，婆说婆有理。孰是孰非，一时难有定论。 一、 这不禁让我联想到印度。和中国一样，印度也是世界四大文明古国之一，有着5000年的文明史。1947年挣脱英国殖民统治的枷锁获得独立时，印度本土的语言
阅读全文posted @ 2011-09-12 11:15 SAP 沧海 阅读(53) 评论(0)
编辑摘要: 是先用英语，再用印地语致词。西方肥皂剧的笑料但印度人英语发音古怪也是事实，他们之间用英语聊得很热闹，外人竟难听懂。他们不仅t和d音分不清，talk让人听成dog，把car说成gar，音调也是极其本土化。我跟一位印度人聊天，他说他曾在军队干过，“啊米”（army）的啊发成了阳平（第二声），米是第四声，直到写出来才让我恍然大悟，这样的尴尬比比皆是。因此印度英语常成为欧美人的笑料，西方肥皂剧中常拿裹着头巾、摇头晃脑、含糊不清地说着英语的印度人开玩笑。网上也流传着不少模仿印度人说英语的段子。但印度人如何看待自己的口音呢？他们似乎并不因嘲笑而心存芥蒂。印度人认为，既然有英式英语、美式英语，还有澳洲英语之
阅读全文posted @ 2011-09-12 11:09 SAP 沧海 阅读(86) 评论(0)
编辑