摘要: 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 沧海-重庆 阅读(3638) 评论(0) 推荐(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 沧海-重庆 阅读(1753) 评论(0) 推荐(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 沧海-重庆 阅读(909) 评论(0) 推荐(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 沧海-重庆 阅读(841) 评论(0) 推荐(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 沧海-重庆 阅读(640) 评论(0) 推荐(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 沧海-重庆 阅读(1049) 评论(0) 推荐(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 沧海-重庆 阅读(673) 评论(0) 推荐(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 沧海-重庆 阅读(428) 评论(0) 推荐(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 沧海-重庆 阅读(491) 评论(0) 推荐(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 沧海-重庆 阅读(387) 评论(0) 推荐(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 沧海-重庆 阅读(472) 评论(0) 推荐(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 沧海-重庆 阅读(1496) 评论(0) 推荐(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 沧海-重庆 阅读(1051) 评论(0) 推荐(0) 编辑