SAP BI - 随笔分类 - 沧海-重庆

安装BI_CONT时遇到Open Data Extraction Requests的问题

摘要：Note 1081287 - Data extraction orders block the upgrade process Summary Symptom SPAM or SAINT: In phase CHECK_REQUIREMENTS, open data extraction orders are reported. Other terms CHECK_REQUIREM... 阅读全文

posted @ 2013-04-07 19:08 沧海-重庆阅读(722) 评论(0) 推荐(0) 编辑

自定义数据源(ECC->BW)

摘要：ECC中创建数据源：(1)T-code: rso2,在Maintain Generic Datasource界面里,选择datasource类型，输入datasource名后，点击“create”按钮(2)在create datasource forXXXX界面里，填入组件名，长、中、短描述及视力/表名称，直接点击菜单栏的保存图标(3)在Datasource: Customer Version Edit界面里，在此可以不做任何改动，直接点击菜单栏的保存图标，datasource就建立完成了。BWRSDS replicate数据源(1)T-code: rsds(2)填入刚才建好的datasour 阅读全文

posted @ 2012-12-15 22:45 沧海-重庆阅读(2323) 评论(0) 推荐(1) 编辑

BW BEx的VBA开发接口介绍

摘要：详细信息参考：http://help.sap.com/saphelp_bw21c/helpdata/en/f1/0a55f9e09411d2acb90000e829fbfe/content.htm 阅读全文

posted @ 2012-11-24 00:17 沧海-重庆阅读(639) 评论(0) 推荐(0) 编辑

货币转换

摘要：RSUOM设置，然后到Query里这是Conversions Unit Conversion：Conversion Type和Target Unit选上阅读全文

posted @ 2012-10-24 12:49 沧海-重庆阅读(384) 评论(0) 推荐(0) 编辑

DSO参数调整的t-code

摘要：RSODSO_SETTINGS 阅读全文

posted @ 2012-05-15 11:47 沧海-重庆阅读(543) 评论(0) 推荐(0) 编辑

提高cube性能的一些方法（一）

摘要：1. 尽量不要在Cube里放太detail的数据，这种需求首先考虑R3用ABAP解决，如果非要在BW，可以考虑在DSO出明细报表，在Cube出汇总报表，通过RRI接口调用明细报表。关于RRI，请看： http://help.sap.com/saphelp_sm32/helpdata/en/99/08629bd3e41d418530c6849df303c9/content.htm 2. 当Cube的数据量很大时，可以拆分成多个Cube, 再用MultiProvider拼起来，这样query会在N个Cube中并行，提高效率。这就是所谓的逻辑分区。常见的分区方式有按年月，按国家，按BU，按类型等. 阅读全文

posted @ 2012-05-15 10:42 沧海-重庆阅读(1079) 评论(0) 推荐(0) 编辑

Process Chain\DTP\Infopackage相关的几个table和function module

摘要：1、统计生产系统的PCTable：RSPCCHAINTRSPCCHAINATTRPC 日志表：RSPCPROCESSLOG FM：RSPC_CHAIN_DELETE_REMOTEunfreeze的FM：RSPC_PROCESS_FINISH 2、统计P系统中PC包含的VariantTable：RSPCVARIANTATTRRSPCVARIANTRSPCVARIANTTRSPCTRIGGERFM：RSPC_TRIGGER_DELETERSPC_VARIANT_DELETE 3、InfopackageTable：RSLDPIOFM：RSSM_SDL_INFOPACKAGE_DELETE4、DTPT 阅读全文

posted @ 2012-05-15 10:05 沧海-重庆阅读(772) 评论(0) 推荐(0) 编辑

Note 741478 - FAQ: Materialized views

摘要：SAP Link741478Version7Release StatusReleased for CustomerReleased on2010-11-30 12:05:35PriorityRecommendations/additional infoCategoryFAQPrimary ComponentBC-DB-ORASecondary ComponentsBC-DB-ORA-DBASummarySymptom1. What are materialized views?2. What are the differences between views and materialized 阅读全文

posted @ 2012-01-19 00:50 沧海-重庆阅读(1490) 评论(0) 推荐(0) 编辑

SAP BW Query常见的性能问题

摘要：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 沧海-重庆阅读(3667) 评论(0) 推荐(0) 编辑

SAP BW维护项目中的常见问题

摘要：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 沧海-重庆阅读(1791) 评论(0) 推荐(0) 编辑

SAP BW实施项目包含哪些内容,需要跟R/3系统进行交互

摘要：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 沧海-重庆阅读(913) 评论(0) 推荐(0) 编辑

SAP BW 系统管理员是一个什么样的角色,日常工作是什么,具体该掌握一些什么知识

摘要：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 沧海-重庆阅读(843) 评论(0) 推荐(0) 编辑

BW Technical and Functional 的区别是什么

摘要：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 沧海-重庆阅读(642) 评论(0) 推荐(0) 编辑

SAP BW中采购的业务报表有哪些

摘要：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 沧海-重庆阅读(1051) 评论(0) 推荐(0) 编辑

标准的RSMO事务代码能实现什么样的功能

摘要：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 沧海-重庆阅读(676) 评论(0) 推荐(0) 编辑

是否能够在BW系统中拷贝一个Process Chain

摘要：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 沧海-重庆阅读(430) 评论(0) 推荐(0) 编辑

怎样在BW系统之间进行transport

摘要：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 沧海-重庆阅读(494) 评论(0) 推荐(0) 编辑

传输一个特定的InfoObject

摘要：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 沧海-重庆阅读(390) 评论(0) 推荐(0) 编辑

将Process Chain传输到测试系统

摘要：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) 编辑

SAP BW系统日常维护日常工作及常见的Infopackage错误

摘要：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 沧海-重庆阅读(1501) 评论(0) 推荐(0) 编辑

随笔分类 - SAP BI