BW
文章平均质量分 83
SINOEC
Study Hard
展开
-
BW Clinet 配置
IDES提供的client800作为BW客户端,则需要创建新的client,同时调整表RSADMINA的BWMANDT字段,使bw工作台与client匹配。原创 2014-05-23 00:47:15 · 444 阅读 · 0 评论 -
转载: 如何处理BW抽数中invalid_characteristcs 错误?
(一)BW运行“非法字符”抽取 分类: SAP2011-09-20 17:43115人阅读评论(0)收藏举报BW默认对“非常字符”从R/3抽取到BW中,做了设置,如“#”符号不能抽取,一旦出现这些字符抽取就会报错。但在实际业务中,有时候有些字符代表有实际意思,所以如何让BW允许这些字符出现?设置如下:1:T-CODE转载 2012-10-16 13:32:18 · 554 阅读 · 0 评论 -
如何用PL/SQL Developer 查询BW后台Oracle 中以/BI0/*、/BIC/*开头的数据表数据
如何用PL/SQL Developer 查询BW后台Oracle 中以/BI0/*、/BIC/*开头的数据表数据1、BW 中的数据表: BW中的对象对应后台自动生成的数据表是以 /BI0/* 、/BIC/* 开头: 详见以下: These are the tables which are available bw including F & E Tab原创 2012-07-10 12:05:37 · 883 阅读 · 0 评论 -
BW 版本(截止 2012 )
BW VersionRelease DateEnd of mainstream maintenance1.0EDec-98Jan-991.2AFeb-99Jun-991.2BJun-99Jun-042.0AFeb原创 2012-04-13 11:23:28 · 2485 阅读 · 0 评论 -
Example for Determining Selection Intervals with a Generic Delta
Example for Determining Selection Intervals with a Generic Delta:1. For every delta extraction, there is a selection criteria generated: last extraction status (RSA7)” 2. Offsets for upper and low原创 2012-04-09 09:37:58 · 262 阅读 · 0 评论 -
BW中常用数据源整理(补充整理)
重新review一下标准数据源的信息:1. CS:Service Orders and Service Notifications 2LIS_18_I3HDR Service Notifications 2LIS_18_I0ITEM Service Notifications - Items 2LIS_17_I3HDR Plan转载 2012-03-19 18:19:10 · 870 阅读 · 0 评论 -
BW Important Tables
Listed below are some of the tables commonly used inSAP BI ( NW 2004) - however the same has not been tested in NW2004s and please make corrections if required. Some of this material has gone thro原创 2012-03-19 18:04:51 · 1778 阅读 · 0 评论 -
(转)关于repair full request
在多个地方看到过关于repair full request的面试问题,之前因为BW全程没学完一直搞不懂是什么。今早再次看到,所以一上午都在SDN上查看相关信息。算是摸了个大概出来。先上NOTE。(原来SAP OSS NOTE是需要有授权的人才能看得到的,幸好SDN上有人把它贴了出来。)OSS Note 739863 'Repairing data in BW'"Symptom So转载 2012-03-17 21:59:09 · 297 阅读 · 0 评论 -
Delta Transfer into BW
转自: http://help.sap.com/saphelp_nw04/helpdata/en/37/4f3ca8b672a34082ab3085d3c22145/content.htm Delta Transfer into BW The following update modes are at your disposal in the BW Scheduler:Full U转载 2012-03-25 01:02:55 · 429 阅读 · 0 评论 -
【转】SAP 历史概要以及BW-BI的演化
SAP 历史概要以及BW-BI的演化 转自:http://space.itpub.net/554557/viewspace-694125 作为SAP系统的全职用户或全职开发人员,我们花了大量的时间去了解SAP的组件以及其特性等,但是,在这个充满竞争的时转载 2011-09-21 11:06:19 · 708 阅读 · 0 评论 -
BW:监控 TCODE
BW:监控 TCODE 转自:http://blog.csdn.net/asdfak/article/details/6115764SM21: 检查系统日誌 ST22: abap DUMP 日誌 SM13: 检查更新错误 SM12: 检查锁定的Item DB13: 备份并检查数据库 DB02: 监视数据库增长 ST04: 检查数据库运行情况 DB12: 检查存档转载 2013-01-30 11:47:33 · 254 阅读 · 0 评论 -
BW中跳转报表参数传递
BW中跳转报表参数传递转自:http://blog.sina.com.cn/s/blog_9154db5301013i6y.html在BW设计Query时,一般从CUBE中出的都是汇总性质的报表,数据的粒度比较粗。若需要看明细数据,一般我们可以采用报表下钻技术。但是,当需要查看数据粒度非常明细,下钻技术在性能上的限制便会凸显出来。SAP BW专门提供了报表跳转技术,来解决这一难题。转载 2013-01-17 16:53:06 · 401 阅读 · 0 评论 -
【转】LO后勤抽取的三种更新方法的操作
今天的学习内容是LO后勤抽取,有3种更新模式:直接增量(update mo)V1 1.order(VA01)-delta queue(rsa7)队列化增量V2 1.order(va01)-extractor queue(LBWO) 2.job contral(LBWE)-delta queue(rsa7)未序列化的V3更新 1.order(VA01)-update tabl转载 2013-08-23 12:07:40 · 398 阅读 · 0 评论 -
BW的SD MM FI DataSource(整理转帖)
MM Data Sources TablesPurchasing 2LIS_02_SCL EKKO, EKBE, T001, T001W, EKET, EKPA.2LIS_02_HDR EKKO, EKBE, T001, EKPA.2LIS_02_ITM EKKO, EKBE, T001, T001W, EKPO, TMCLVBW, T027C, ESSR, T14转载 2013-07-24 11:31:09 · 461 阅读 · 0 评论 -
Useful ABAP Programs and Function Modules in SAP BI
Get Details About an InfoObject:BAPI_IOBJ_GETDETAIL RSD_IOBJ_GETGet all variable of a query :RSDFPS_GET_QUERY_FULL Useful ABAP Programs and原创 2013-03-13 13:53:20 · 602 阅读 · 0 评论 -
清除buffer: t-code: /$sync
清除buffer: t-code: /$sync清除buffer: t-code: /$sync转载 2013-03-08 12:02:56 · 387 阅读 · 0 评论 -
Steps to Change BI variable parameters
http://wiki.sdn.sap.com/wiki/display/bpxproj/Steps+to+Change+BI+variable+parameters Steps to Change BI variable parametersHere i want to describe how to change the variable parameters once转载 2013-03-06 19:22:59 · 290 阅读 · 0 评论 -
Note 846839 - Types of Authorizations in BW
Note 846839 - Types of Authorizations in BW HeaderVersion / Date1 / 2007-02-07PriorityRecommendations/additional infoPrimary Component BW-BEX-OT-OLAP-AUT AuthorizationsSecondary Componen原创 2013-03-04 09:13:27 · 261 阅读 · 0 评论 -
新建特殊目的分类账 FI-SL 数据源(Delta ADDD提取)
新建特殊目的分类账 FI-SL 数据源 Delta ADDD提取原创 2011-04-22 15:21:00 · 791 阅读 · 0 评论 -
【转】DSO ---> Cube Delta 加载的一个问题 (一问一答)
<br />Delta load from DSO to InfoCube only with 0RECORDMODE: <br />After-image (blank) <br /> <br />Ask:<br /> <br />Hi Gurus,<br />I have been searching for a simple explanation about how to make a delta load from data source-> DSO -> InfoCube over inter原创 2011-04-14 17:43:00 · 634 阅读 · 0 评论 -
Compression E-Table vs F-Table
<br />Compression E-Table vs F-Table<br /><br />Difference between 'F' fact table & an 'E' Fact table?<br /><br />A cube has 2 fact tables - E and F. When the requests in the cube are not compressed the data exists in the F fact table and when the requests原创 2011-04-14 13:54:00 · 554 阅读 · 0 评论 -
Important Tables in SAP BI ( NW2004)
Important Tables in SAP BI ( NW2004)Listing of commonly used tables in SAP BI and to understand the way data is stored in the backend of SAP BIListed below are some of the tables commonly used in SAP BI ( NW 2004) - however the same has not been tested in原创 2011-03-25 10:09:00 · 372 阅读 · 0 评论 -
【转】BI--SDN上收集到的SAP BI的极好文章的链接
本文转自:http://silverw0396.javaeye.com/blog/229272BI--SDN上收集到的SAP BI的极好文章的链接<br />1)Overview<br /> https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60981d00-ca87-2910-fdb8-d4a2640d69d4<br />Volume Testing for SAP BW<br />ERP: Note 821148 -原创 2011-02-25 16:09:00 · 660 阅读 · 0 评论 -
Differences Between a BI/Data Warehouse System and an OLTP System
Differences Between a BI/Data Warehouse System and an OLTP System 1. Level of detail: The OLTP layer stores data with a very high level of detail,whereas data in the Data Warehouse is compressed原创 2010-03-24 10:41:00 · 377 阅读 · 0 评论 -
【转】SAP Study Notes: BW Queriy-Variables(变量)
SAP Study Notes: BW Queriy-Variables(变量)转自:http://chenweiqin1981.spaces.live.com/blog/cns!1675D48BEA05A462!1634.trak About Variable:1.Variable 是和InfoObject绑定的,可用于任何含有该IO的query中。2.Variabl转载 2010-01-08 16:03:00 · 1042 阅读 · 0 评论 -
【转】COPA Extraction Steps
COPA Extraction StepsThe below are the command steps and explanation. COPA Extraction -steps R/3 System 1. KEB0 2. Select Datasource 1_CO_PA_CCA 3. Select Field Name for Partitioning (Eg, Ccode) 4转载 2010-01-08 17:07:00 · 330 阅读 · 0 评论 -
【转】BW-- BW项目的对象传输(稍作修改)
【转】BW-- BW项目的对象传输(稍作修改)一、BW项目的对象传输分两部分:1)Transport all relation BW Object in R/3 system;2)Transport BW Object in BI system; 二、传输步骤1)first you have to transport R/3 objects to QA,then to PR转载 2010-03-11 17:46:00 · 838 阅读 · 0 评论 -
【转】BEx : Characteristic Variable with Replacement Path
转自:http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5408官方:http://help.sap.com/saphelp_nw04s/helpdata/en/2c/78a03c1178ad2ce10000000a114084/content.htm We often create Text/Formula Variables原创 2009-12-30 16:23:00 · 860 阅读 · 0 评论 -
处理链查看 ST13
Step1 :ST13 Step2 : BW-TOOLS Step3 : ProcessChain AnalysisStep4 : choose data period Step5 : Chain原创 2010-03-08 10:04:00 · 315 阅读 · 0 评论 -
SAP算号器生成 Developer Access Key
1. 问题描述: SE38 建立程序,系统提示: You are not registered as a developer. Please register in the Online Service System(OSS). In the OSS you will receive an access key. 2. 运行 zapgui原创 2009-12-17 18:26:00 · 2622 阅读 · 0 评论 -
【转】SAP算号器 license key Developer Access Key 完美解决方案
本文转自:http://www.cnblogs.com/Evan/articles/1139584.html 本文遵从 GNU GPL 版权协议,任何组织或个人在引用、转载或修改此文档时,敬请保留版权信息及注明出处。警告:仅限IDES学习、研究使用。严禁商业使用。后果自负。 关健字:SAP license key SAP Developer Access Key转载 2009-12-17 10:49:00 · 1456 阅读 · 1 评论 -
【转】BW Beginner Section
Getting started with SAP BIHow do you get started on SAP BI - this wiki section offers you pages updated by SCN members on how and where you can get started with SAP BI Being quite a lucrative and interesting domain, SAP BI attract many newcomers. Many p转载 2011-03-25 11:00:00 · 252 阅读 · 0 评论 -
【转】BW--在BW项目中涉及ABAP的增强连接收集
转自 http://blog.csdn.net/CompassButton/archive/2009/07/23/4374455.aspx1、Five Ways to Enhance BI Functionality Using ABAP-- Part I--Data Extraction https://wiki.sdn.sap.com/wiki/display/BI/Five+Ways+to+Enhance+BI+Functionality+Using+ABAP--+Part+I--Data+Extra转载 2011-03-24 17:08:00 · 353 阅读 · 0 评论 -
【转】SAP学习手册
SAP学习手册发表人:sunxufeng | 发表时间: 2006年三月27日, 17:20有没有调整IDES4.6的中文包参数的步骤呢?在导入中文包后直接手工修改有关参数,不要用CZ10去修改 假定为D盘,路径为D:usrsapC11sysprofileC11_DVEBMGS00_cpa (后面CPA为我的计算机名),用NOTEPAD手动编辑该文件 SAPSYSTEMNAME = C11 INSTANCE_NAME = DVEBMGS00 SAPSYSTEM = 00转载 2011-05-26 16:58:00 · 4624 阅读 · 0 评论 -
The BW - HANA Relationship
<br /> <br />The BW - HANA Relationship<br /> <br />转自:http://weblogs.sdn.sap.com/cs/blank/view/wlg/21575<br /><br />Thomas Zurek <br />Business Card<br />Company: SAP AG<br />Posted on Oct. 15, 2010 01:11 AM in In-Memory Business Data Management, ERP,转载 2011-04-02 15:03:00 · 1524 阅读 · 0 评论 -
BWA & BOEA & HANA
BWA & BOEA & HANA一、 BWA- Increases BW query ,supports only SAP Data. BWA accelerates data sourced from BWA which maybe from have been loaded from any data source. BWA 7.2 with BW 7.3 has a lot of additional options including being a primary persis原创 2011-04-01 18:30:00 · 571 阅读 · 0 评论 -
BWA 归结
<br /> BWA 归结<br />转自:http://scnblogs.techweb.com.cn/amperson/<br /><br />初识BWA <br />看到Vince在办小讲坛,感觉这个形式作为基本知识的介绍挺不错的。然后联想到和自己关系颇深的一个产品--SAP BWA--在国内还相当陌生,何不也用这种方式介绍一下呢?由于论坛帖子的一些限制所以无法很详细,这个小讲坛就当作一个入口吧。比较详细的内容我都会写在我在SCN新建的blog上(http://s转载 2011-04-01 18:32:00 · 1084 阅读 · 1 评论 -
【转】SAP内存计算给力企业商务智能
SAP内存计算给力企业商务智能转自:益和观点http://www.yh0571.com/?p=21912010年12月1日—2日,SAP在主题为“抓住即刻价值,创造成功未来”的2010年SAP全球技术研发者大会上,SAP正式对外发布了其明确的未来技术发展战略,云计算、移动应用、基于内存的计算成为SAP瞄准的三大主要技术发展方向,SAP未来将在三大技术的基础上推出一系列企业管理应用解决方案。内存计算,顾名思义,读取内存的数据来进行分析、计算,由于内存数据是列式的,所以读取数据非常快,随着内存的成本逐渐下降,不转载 2011-04-01 18:31:00 · 432 阅读 · 0 评论 -
BW T-Codes (alphabetic order)
BW T-Codes (alphabetic order) Tcode DescriptionBDLS Converting logical system names (System Copy) BWCCMS SAP BI Monitors CHANGERUNMONI Monitor for Changeruns DB02 Tables and Indexes Monitor DB14 Display DBA Operation Logs DB16 Display DB Check Results原创 2011-03-25 09:56:00 · 642 阅读 · 0 评论 -
【转】BI Statistics Tables
BI Statistics Tables <br />转自:http://wiki.sdn.sap.com/wiki/display/BI/BI+Statistics+Tables<br /> <br />These are some of the BI Statistics tables . You can find the runtimes and other necessary details of the BI objects in these tables . <br />These table转载 2011-03-25 09:35:00 · 358 阅读 · 0 评论