墨西鸽

墨西鸽的SAP BW SPACE

  博客中心 :: 首页 :: 新随笔 :: 联系 :: 聚合  :: 登录 ::
  1 随笔 :: 9 文章 :: 3 评论 :: 0 Trackbacks
Cached @ 2025/4/26 7:53:58Control ASP.skins_cogitation_controls_blogstats_ascx
<2008年10月>
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678

留言簿(0)

随笔档案

文章档案

SAP BLOG

搜索

最新评论

阅读排行榜

评论排行榜

Cached @ 2025/4/26 7:53:58Control ASP.skins_cogitation_controls_singlecolumn_ascx
SAP provides business contents, which are used in BW for reporting and analysis.
Steps involved in using the business content and generating reports:
      1. Log on to the SAP R/3 server.
      2. Install the Business content. The Transaction code (Tcode) is RSA5.

3. Checking if the Business content is ready for use. Tcode RSA6.
4. Enhancing the structure. Here I am using BOM (Bill of Materials)
from the table VBAP from Sales and Distribution(SD).

4. Activate the enhanced structure.
5. Enhance the field BOM in to the structure, Hence it should be mapped to 0_FI_GL_4 from VBAP when the condition is satisfied. User exit is written for this purpose.

6. Include the following code in the user exit.
TABLES: AUFK. "Table inserted by Vijay
TABLES: VBAP. "Table inserted by vijay
DATA: Temp_sorder like DTFIGL_4.
DATA: Temp_ZZSEQUENCNUMBER like DTFIGL_4-ZZSEQUENCENUMBER.
DATA: Temp_KDAUF like DTFIGL_4-KDAUF.
DATA: Temp_ZZORDERCAT like DTFIGL_4-ZZORDERCAT.
DATA: Temp_ZZBOM like DTFIGL_4-ZZBOM.
Case i_datasource.
When '0FI_GL_4'.
Loop at C_t_data into Temp_sorder.
Select single SEQNR from AUFK into Temp_ZZSEQUENCENUMBER
        Where AUFNR = Temp_sorder-AUFNR and BUKRS = Temp_sorder-BUKRS.
        Select single KDAUF from AUFK into Temp_KDAUF where AUFNR =
Temp_sorder-AUFNR and BUKRS = Temp_sorder-BUKRS.
Select single AUTYP from AUFK into Temp_ZZORDERCAT where AUFNR =
Temp_sorder-AUFNR and BUKRS = Temp_sorder-BUKRS.
Temp_sorder-ZZSEQUENCENUMBER = Temp_ZZSEQUENCNUMBER.
Temp_sorder-KDAUF = Temp_KDAUF.
Temp_sorder-ZZORDERCAT = Temp_ZZORDERCAT.
Select single STLNR from VBAP into Temp_ZZBOM where GSBER =
Temp_sorder-GSBER and AUFNR = Temp_sorder-AUFNR.
Temp_sorder-ZZBOM = Temp_ZZBOM.
Modify C_t_data from Temp_sorder.
End loop.
      7. Activate the user exit.
8. Business content has been installed and activated. A field Bill of Material (ZBOM) from VBAP (SD) has been enhanced to FI_GL_4 structure.

9. Log on to BW server.
10. Create an InfoObject for the enhanced field ZZBOM.

11. Replicate the data from SAP R/3 to the BW server.

12.    Assign Data source. Map the fields manually since ZZBOM is an enhancement, it should be mapped to the InfoObject created by us.
13.    Create ODS.

14.    Assign the objects corresponding to the Key fields and Data fields.

15. Create Update rules for the ODS.

15.    Create InfoSource and InfoPackage.The data is extracted form the SAP R/3 while we schedule the load from Info Package.The Data is then loaded into the ODS which is the data target for the InfoPackage.

16.    Schedule the load.

17.    The data is loaded in to the ODS which could be monitored. The data load is successful.
18.    Create InfoCube.

19. Assign the corresponding characteristics, Time Characteristics and Key figures.
20.    Create relevant Dimensions to the cube.
21.    Activate the InfoCube and create update rule in order to load the data from the ODS.

22.    Update ODS and the InfoCube is successfully loaded. Manage the InfoCube to view the available data.

23.    Data available in the InfoCube.

24.    As per the requirement the General Ledger InfoCube is created and ready for Reporting. Create a new query using a query designer.
25.    Query designer for 0_FI_GL_4.
26. General Ledger Balance Sheet for the period 1995, 1996 and 1997.

The SAP Business Information Warehouse allows you to analyze data from operative SAP applications as well as all other business applications and external data sources such as databases, online services and the Internet.
The SAP Business Information Warehouse enables Online Analytical Processing (OLAP), which processes information from large amounts of operative and historical data. OLAP technology enables multi-dimensional analyses from various business perspectives. The Business Information Warehouse Server for core areas and processes, pre-configured with Business Content, ensures you to look at information within the entire enterprise. In selected roles in a company, Business Content offers the information that employees need to carry out their tasks. As well as roles, Business Content contains other pre-configured objects such as InfoCubes, queries, key figures, and characteristics, which make BW implementation easier.
分享按钮发布于: 2008-10-24 09:28 墨西鸽 阅读(658) 评论(1)  编辑 收藏

评论

# re: 标准数据源增强 STEP BY STEP 2008-10-30 15:25 Uranus
我在增强方面作的还不多,谢谢这个!~

标题
姓名
主页
内容 
  登录  使用高级评论  Top 订阅回复  取消订阅
[使用Ctrl+Enter键可以直接提交]