Owner: FreeSAP Business Warehouse(BW) Books,Faqs,Material URL:http://freesapbwlive.blogspot.com Join Date: Sat, 07 Jun 2008 09:33:52 -0500 Rating:0 Site Description: BI InfoObject,Master Data,Modeling,Business Warehouse, Errors,Reporting,Tables,Conversion Routine,Data Uploading,DataStore Objects,Infocube,InfoSets,Interview Questions,Modeling,MultiProvider,TCodes,Upgrade BI,VirtualProviders Site statistics:Click here
Example for Activating and Updating Data in SAP BW 2008-05-19 08:58:23 The graphic below shows how data is updated in a DataStore object and the effect of the activation step. ... 1. Request 1 with amount 10 and request 2 with amount 30 are loaded parallel into the DataStore object. This takes you to the activation queue. You are given a unique request ID there. 2. When you carry out the activation step, the requests are sorted by key, t Read more:Example
SAP BI InfoObject 2008-07-09 22:46:39 Definition Business evaluation objects are known in BI as InfoObjects. They are divide into characteristics (for example, customers), key figures (for example, revenue), units (for example, currency, amount unit), time characteristics (for example, fiscal year) and technical characteristics (for example, request number). Use InfoObjects are the smallest units of BI. Using InfoObjects, informati
SAP BI InfoObject Catalog 2008-07-09 22:45:57 Definition An InfoObject catalog is a collection of InfoObjects grouped according to application-specific criteria. There are two types of InfoObject catalogs: Characteristic and Key figure. Use An InfoObject catalog is assigned to an InfoArea. An InfoObject catalog is an organizational aid and is not for intended for data analysis purposes. For example, all the InfoObjects that are used for
SAP BI Creating InfoObject Catalogs 2008-07-09 22:45:11 Prerequisites Ensure that all the InfoObjects that you want to transfer into the InfoObject catalog are active. If you want to define an InfoObject catalog in the same way as an InfoSource, then the InfoSource has to be available and active. Procedure ... 1. Create an InfoArea, to which you want to assign the new InfoObject catalog. This function is on the first level of the hiera Read more:Creating
, Catalogs
SAP BI Additional InfoObject Catalog Functions 2008-07-09 22:44:27 Documents This function allows you to display, create or change documents for your InfoObject catalog. See: Documents. Info Functions
There are various info-functions on the status of the InfoCube Catalog: · the log display for activation and deletion runs of the InfoObject Catalog, · the current system settings, the object catalog entry. Display in Tree You can use
SAP BI InfoObject Naming Conventions 2008-07-09 22:43:40 Use As is the case for other objects in BI, the customer namespace A-Z is also reserved for InfoObjects. When you create an InfoObject, the name you give it has to begin with a letter. BI Content InfoObjects start with 0. For more information about namespaces, see Namespaces for BI Objects. Integration If you change an InfoObject in the SAP namespace, your modified InfoObject is not overwritt Read more:Naming
SAP BI Creating InfoObjects: Characteristics 2008-07-09 22:42:48 Procedure ... 1. In the context menu of your InfoObject catalog for characteristics, select Create InfoObject. 2. Enter a name and a description 3. Specify a reference characteristic or a template InfoObject. If you choose a template InfoObject, you copy its properties and use them for the new characteristic. You can edit the properties as required. For mor Read more:Creating
Tab Page: General BI InfoObject 2008-07-09 22:41:48 Use On this tab page, you specify the basic properties of the characteristic. Structure Dictionary Specify the data type and the data length. The system provides you with selection options using F4 Help. The following data types are supported for characteristics: Char: Numbers and letters Character length 1 - 60 Numc: Numbers only Character length 1 - 60 Dats: Date Charact Read more:General
Tab Page: Business Explorer BI InfoObject 2008-07-09 22:40:51 Use On this tab page you determine the properties that are required in the BusinessExplorer
for reporting on or analyzing characteristics. Structure General Settings You can make the following settings for the InfoObjects contained in the InfoProvider on an InfoProvider by InfoProvider basis. The settings are only valid in the relevant InfoProvider. See also Additional Functions in InfoCube M
Mapping Geo-Relevant Characteristics SAP BI InfoObject 2008-07-09 22:39:52 Definition To display BI data geographically, a link between this data and the respective geographical characteristic must be created. This process is called Mapping
Geo-Relevant
Characteristics. Structure The geographical information about geographical boundaries of areas that are displayed using static geo-characteristics is stored in Shapefiles. In the Shapefile, a BI-specific attribute call
Static and Dynamic Geo-Characteristics SAP BI INFOOBJECT 2008-07-09 22:39:00 Definition Static and dynamic characteristics describe data with a geographical reference (for example, characteristics such as customer, sales region, country). Maps are used to display and evaluate this geo-relevant data. Structure There are four different types of geo-characteristic: ... 1. Static geo-characteristics A static geo-characteristic is a characteristic that descri Read more:Dynamic
Shapefiles Static and Dynamic Geo-Characteristics SAP BI Info Object 2008-07-09 22:38:09 Definition ArcView GIS software files from ESRI that contain digital map material of areas or polygons (shapes). Shapefiles define the geometry and attributes of static geo-characteristics. Note that shapefiles have to be available in the format of the World Geodetic System 1984 (WGS 84). For more information on the World Geodetic System WGS 84, see www.wgs84.com. Use Shapefiles serve as a basi Read more:Dynamic
, Object
Delivered Geo-Characteristics BI InfoObject 2008-07-09 22:37:28 Definition With Business Content, SAP NetWeaver BI delivers a range of geo-characteristics. Structure The following are the most important delivered geo-characteristics: Static geo-characteristics Technical Name Description 0COUNTRY Country key 0DATE_ZONE Time zone 0REGION Region (federal state, province) Dynamic geo-characteristics Technical Name Description 0A Read more:Delivered
SAPBWKEY Maintenance for Static Geo-Characteristics 2008-07-09 22:36:29 Purpose During run time, BI data is combined with a corresponding Shapefile. This enables the BI data to be displayed in geographical form (country, region, and so on) using color shading, bar charts, or pie charts. The SAPBWKEY makes sure that the BI data is assigned to the appropriate Shapefile. In the standard Shapefiles delivered with the ESRI BI map CD, the SAPBWKEY column is already fi Read more:Maintenance
Creating a Local Copy of the Shape File BI InfoObject 2008-07-09 22:35:31 Use You need a local copy of the shape file before you are able to maintain the SAPBWKEY column in the attributes table of the shape file. Procedure ... 1. Use your file manager (Windows Explorer, for example) to localize the three files cntry200.shp, cntry200.shx and cntry200.dbf on the ESRI BI map data CD, and copy the files to the C:\SAPWorkDir directory, for example. Read more:Creating
, Local
, Shape
Downloading BI Master Data into a dBase File BI InfoObject 2008-07-09 22:34:46 Use To maintain the SAPBWKEY column in the shapefile attribute table, you have to specify the corresponding BI country key for every row in the attribute table. As this information is contained in the BI master data table, you have to download it into a local dBase file to compare it with the entries in the attribute table and maintain the SAPBWKEY. Prerequisites You have created a local workin Read more:Master
, Downloading
Maintaining the SAPBWKEY Column BI InfoObject 2008-07-09 22:34:13 Prerequisites You have completed the following steps: Created a local copy of the shapefile Downloading BI master data into a dBase file Integration The SAPBWKEY is maintained in the dBase file with the suffix .dbf. This file contains the attributes table. Procedure ... 1. Launch Microsoft Excel and choose File ® Open. 2. From the dropdown box in the Files of Typ Read more:Maintaining
, Column
Uploading Edited Shapefiles into BI Systems 2008-07-09 22:33:29 Prerequisites You have completed the following steps: Created a local copy of the shapefile Downloaded BI master data into a dBase file Maintained the SAPBWKEY column Procedure The last step is to attach the shapefile set (.shp, .shx, .dbf) to the InfoObject, by uploading it into the Business Document Service (BDS) on the BI server. ... 1. Log on to the BI system and go to the Read more:Systems
, Uploading
, Edited
BI Geocoding 2008-07-09 22:32:46 Purpose To display dynamic geo-characteristics as points on a map, you have to determine the geographic co-ordinates for every master data object. The master data table for dynamic geo-characteristics is, therefore, extended with a number of standard geo-attributes such as LONGITUDE and LATITUDE (see Static and Dynamic Geo-Characteristics ). Prerequisites You have marked the geo-relevant ch
Downloading BI Master Data into a dBase File Geocoding 2008-07-09 22:32:02 Use The first step in SAPBWKEY maintenance for dynamic geo-characteristics and their geocoding is to download the BI master data table into a dBase file. Procedure ... 1. Log on to the BI system and go to the InfoObject maintenance screen (transaction RSD1). The Edit InfoObjects: Start dialog box appears. 2. In the InfoObject field, enter the name of the dynamic geo-c Read more:Master
, Downloading
Geocoding Using ArcView GIS BI InfoObject 2008-07-09 22:31:15 Prerequisites · You have installed the ESRI ArcView software on your system and requested the geographical data you need from ESRI, if this is not already on the data CD delivered with the software. · You have completed the following step: Downloading BI master data into a dBase file Use Using geocoding, you enhance dynamic geo-characteristics from BI master data with the geog
Converting dBase Files into CSV Files BI Geocoding 2008-07-09 22:30:01 Prerequisites You have completed the following steps: Downloading BI master data into a dBase file Geocoded using ArcView GIS Integration The result of the geocoding is the dBase file Geocodierung_Result.dbf. This file contains the BI master data enhanced with columns X and Y. Since the attribute table is stored in dBase file format, you must convert it into CSV (comma separate value) format,
Tab Page: Master Data/Texts BI InfoObject 2008-07-09 22:29:05 Use On this tab page you specify whether the characteristic can have master data and/or texts. Structure With Master
Data Here you specify whether the characteristic has master data. You have to create a master data table for a characteristic if you want the characteristic to have attributes. When you select this option, the system generates a master data table. You branch to the relevant ma
Tab Page: Hierarchy BI InfoObject 2008-07-09 22:28:20 Use If you want to create a hierarchy, or upload an existing hierarchy from a source system, you have to set the with hierarchy indicator. The system generates a hierarchy table with hierarchical relationships for the characteristic. You are able to determine the following properties for the hierarchy: · Whether or not you want to create hierarchy versions for a hierarchy. · Read more:Hierarchy
Tab Page: Attributes BI InfoObject 2008-07-09 09:25:02 Use On this tab page, you determine whether or not the characteristic has attributes or navigation attributes, and if so, which properties they have. This tab page is only available if you have set the With Master Data indicator on the Master Data/Texts tab page. Structure Attributes
are InfoObjects that exist already, and that are assigned logically to the new characteristic. There are the
Tab Page: Compounding BI InfoObject 2008-07-09 09:23:58 Use In this tab page, you determine whether you want to compound the characteristic to other InfoObjects. You sometimes need to compound InfoObjects in order to map the data model. Some InfoObjects cannot be defined uniquely without compounding. For example, if storage location A for plant B is not the same as storage location A for plant C, you can only evaluate the characteristic Storage Lo
The benefits of SAP BW 2008-08-09 02:17:36 SAP Business Warehouse is ships with "Business Content". It comes with ready-made extraction routines, meta-data, InfoCubes, information models, reports and channels that guarantee analysis and reporting capabilities out of the box. It closes the loop as it provide a seamless links to planning and execution applications that allow you to act instantly on the insight you gain to improve the perfor
SAP BW Cookbook 2008-08-09 02:17:16 Extract from the BW Cookbook
Volume 1: "The SAP Business Information Warehouse enables Online Analytical Processing (OLAP) to format the information of large amounts of operative and historical data. OLAP technologyenables multi-dimensional analyses according to various business perspectives. The preconfigured Business Information Warehouse Server for core areas and processes ensures information v
Responsibilities of BW Data Architect 2008-08-09 02:16:32 Responsibilities of an implementation project...For ex, Lets say If its a fresh implementation of BI or for that matter you are implementing SAP... First and foremost will be your requirements gathering from the client. Depending upon the requirements you will creat a business blueprint of the project which is the entire process from the start to the end of an implementation... After the blue prin Read more:Architect
Recommend Site To A Friend
