SAP BLOG--Jack Wu

 This list of transactions is designed to guide a Basis Admin team member through the process of keeping tabs on major systems issues and root cause issues and trends for each system in the landscap

SAP Business Information Warehouse (SAP BW) is the name of the Business Intelligence, Analytical, Reporting and Data Warehousing (DW) solution which is one of the major enterprise software applicati

一、ERP系统(R3)1) In Source System, go to SE11 and create the view, then go to RSO2 to create datasource.  2) Specify the name of the datasource in the field of RSO2 and hit Create.  3) Give the Applica

一、sapBI的用户分类There are different types of users in SAP BW. Most of your users will be the users who execute queries and workbooks. These people could be considered "reporting users" or "end users."

1. In Infosets now you can include Infocubes as well. 2. The Remodeling transaction helps you add new key figure and characteristics and handles historical data as well without much hassle. This is on

1) Start Process2) Load Process for textsLoad the text data for all the master data. For each of the master data info-object include thier text load infopackages3) And process4) load process for hie

什么是信息立方体压缩 :For this we need to go into specifics of how data gets updated into the cube.A cube has two fact tables..The F Fact table or the uncompressed fact table - this table is partitioned based o

1)Overviewhttps://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60981d00-ca87-2910-fdb8-d4a2640d69d4Volume Testing for SAP BWERP: Note 821148 - Installing/upgrading Basis Plug-in (PI_B

  1)Hierarchy Type  Hierarchy Type Description Hierarchy definition for characteristics Characteristic hierarchyCharacteristic values of a characteristic in a tre

一、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;2)THen transport BW objects to QA

一、BEx 3.X可用API函数列表1. Function SAPBEXinitConnection(Optional newConnectionObj As Object) As BooleanSet up a connection to BW Server2. Function SAPBEXgetConnection(Optional what As Integer) As Varia

Why Currency translation in BexDepending upon various business scenario we need to do currency translation for BI Reports according to exchange rate of varying time ref.  For Ad-hoc reporting an

 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+Extraction  Fiv

Functions DescriptionBW objects such as InfoCubes, ODS objects, MultiProviders and MultiProviders and InfoObjects (attributes or texts) can function as open hub data sources. If you use an InfoCube

BI--两个不错的BI文档链接

BI-Cube to Cube Load

BI-About BEx Web Application Web Item : Chart

最近在sap的SDN上发现了一篇详细讲叙如何创建BI的新Client，该文章讲得非常详细，对BI安装的新手非常有用，特贴出链接供大家参考：https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/007af9a7-e48e-2a10-5c85-fcac22d58e82

In COPA you have often a data model consisting of similar cubes but with different data.You can have e.g. a cube for data of the current year, another cube with data of the previous year and a last on

在SAP NetWeaver 2004s, 一些术语和工具发生了改变，新旧对照表如下：  旧术语 新术语 ODS object DataStore object

 Quiz: SAP BI/BW -- beginner level1. The following transactions are relevant to the data sources in an SAP BW source system.a. RSA3b. RSA4c. RSA5d. RSA6 2. True or False? A reference character

  ContentBuilding Block – BW Connectivity. 61     Prerequisites. 61.1     User Roles. 62     Local Settings. 62.1     SAP R/3. 62.1.1       Define Client Administration (SAP R/3)62.1

一: 安装环境介绍:硬件环境:笔记本IBM X60 A33CPU: T2300 1.86 1.5GRAM 60G HDISK外挂:3.5寸 320G移动硬盘.网卡正常工作,接网线,配置固定IP,不需要虚拟网卡,安装的过程中家里和办公室 来回换了几次IP,无影响.OS: WIN2003+SP1 没有打其余的任何补丁.Norton client 10.1.5.5000 老是在安装盘中发现病毒,最后删除

855383 - Installation of SAP SEM Release 6.0848462 - DB2-z/OS: BW: Aggregate setup after physical partitioning834343 - Oracle 9.2 Platform Support for Async IO724418 - Installing SAP SEM Release 4.063

1. Size of the table for new data (techn. M-table)               The size of the table for new data of the ODS object should not exceed 1 million data records. The system stores up to 1 million d

There are DB objects like tables, views, triggers and so on with the /BI0/0 name prefix. You cannot find these objects in the ABAP/4 Data Dictionary.Other termsBusiness Information Warehouse, temp

Description : This code snippet gives the list of logged on users in the portal using Webdynpro for JAVARequired jar files for this code snippet-> webdynpro_services.jar located at /com.sap.tc.webdy

1 Requirement DescriptionWe had a requirement to load data from a Spread sheet directly onto a Cube through an ABAP Program using the BAPI s in SAP BW. We required a dialog screen to give location o

Go to transaction code RSA3 and see if any data is available related to your DataSource. If data is there in RSA3 then go to transaction code LBWG (Delete Setup data) and delete the data by ente

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cccad390-0201-0010-5093-fd9ec8157802https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cbd2d390-0201-00

  Data Warehousing: Step by StepPurposeTo build a data warehouse, you have to execute certain process steps. Process Flow        1.      Data modeling ○     Creating InfoObjects: Character

  Interface Service: Read Write Display *

S.No Tcode Description 1 RSA1 Administrator Work Bench

Transfer Structure   RSTS Transfer Structure List RSTSFIELD T

The goal of this blog is to bundle the information related to the Data Transfer Process (DTP). The documents listed below are describing the different DTP features and "data flow" capabilities in deta

 In BI 7.0 environment, transformation (formerly called Update/Transfer rules) requires object oriented ABAP and here are some difference worth noting down between Object oriented ABAP and ABAP whic

BI--BI对象的后台表的命名规则