BW--关于Open Hub Service的一些连接
来源:互联网 发布:spyder python 3.5 编辑:程序博客网 时间:2024/05/16 18:08
Functions Description
BW 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 with non-cumulative key figures as a data source.
With open hub service , infospoke are used to transfer data out of BW data provider (like infocube, ODS) to a flat file on local station or application server or to some database table.
Here you can give selections as to fields to be loaded from infocube and also mark the data load as full or delta.You can check the same by going at rsa1(adm workbench)->Tools->open hub service.
There is a table where all customers information was stored, we have to filter those customers who have access.This table was clubed with all the customer irrespective of those who have the access and those who dont have the access to BI.
Here we implemented Openhub.We get the data to BW there we implemented Infospoke and wrote code in BADI, the filtered records sent to Openhub and from open hub to The same table UPS through Ascential Stage tool.
Two separate options to extract data from SAP BW to TPS (third party servers) & other SAP Systems.
1)Flat Files in CSV (comma separated values) format only
Create Flat Files to BW Directory and use FTP to move to third party servers- FREE
2)DB Tables
Connect to third party server and use DB Connect tool to directly update to that server- MAY REQUIRE LICENSE
Data can be extracted from the following types of InfoProviders:
1)CUBE
2)ODS
3)InfoObject Master Data (if it's a Data Target)
Open Hub supports both Full & Delta extractions.
1)Full extraction
2)Delta extraction
How to Use BADI In Open Hub Service
The definition for the BAdI is called OPENHUB_TRANSFORM.
1. Goto RSBOH1.
2. Create your InfoSpoke with default options.
3. Activate you InfoSpoke.
4. Change it and go to the tab "Transformations" and check the box "InfoSpke with ... BAdI".
5. This will take you to the BAdI.
6. Implementing the BAdI
6.1 You are in the BAdI builder. Enter a short text for the implementation. The implementation name is always the same as the technical name of the InfoSpoke.
6.2. The implementation of this BAdI is always filter-dependent. Enter your InfoSpoke on the Properties tab page under Filter Specifications. You can only have one implementation for each InfoSpoke.
If you do not specify an InfoSpoke under Filter Specifications, then this implementation is valid for all InfoSpokes. This means that this is called up for all InfoSpokes during the extraction.
6.3. Activate your class.
6. 4. From the Interface tab page, you arrive at the TRANSFORM method in the class builder by double-clicking. There you can enter your code:
method IF_EX_OPENHUB_TRANSFORM~TRANSFORM .
your code
endmethod.
6.5. Activate your method. Return to the BAdI builder. Return to your InfoSpoke.
Relation Link
SAP Help
http://help.sap.com/saphelp_nw04/helpdata/en/1e/c4463c6796e61ce10000000a114084/frameset.htm
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/eb462104-0701-0010-07ae-d866630e0989
http://help.sap.com/saphelp_nw04/helpdata/en/a8/a6eae34c9e9b4cbd8fbc7acd2845d0/frameset.htm
Frequently Asked Questions - Open Hub
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/e830a690-0201-0010-ac86-9689620a8bc9
Dynamic selection for InfoSpoke & Use InfoSpoke Badi to correct KYF format
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/01d3a090-0201-0010-9783-bc33ab690e70
InfoSpoke Creation and Loading the File Generated via FTP
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70cc1083-f6c1-2b10-12ad-ed718ddc3d73
Extraction to Non-SAP Systems
http://help.sap.com/saphelp_nw04/helpdata/en/a8/a6eae34c9e9b4cbd8fbc7acd2845d0/frameset.htm
Open Hub Service
https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5f12a03d-0401-0010-d9a7-a55552cbe9da
Loading data from SAP BW into Microsoft Analysis Services using Open Hub Service
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/7d63ec90-0201-0010-a2a7-898c08c589f8
- BW--关于Open Hub Service的一些连接
- BW:传输到Open Hub的DTP,怎么删除?
- BW:传输到Open Hub的DTP,怎么删除?
- BW--一些关于DTP的一些链接
- BW--一些关于DTP的一些链接
- 关于BW Query Performance 的一些问答
- BW:BW与第三方BI接口设计与实现:APD、Open Hub、RFM
- SAP BW: 系统连接遇到的一些问题
- BW的一些问答
- BW--收集到BW的一些问答
- BW--收集到BW的一些问答
- BW与第三方BI接口设计与实现:APD、Open Hub、RFM
- 关于Service的一些理解
- 关于Service的一些总结
- 关于Service的一些疑惑。
- 关于Service的一些理解
- 关于window.open的一些介绍
- 关于QA的一些Open Question
- IT职业病
- .NET的那些事儿(1)——NUnit快速入门经典
- Passed Sun Certified Network Administrator for Solaris 10 OS (CX-310-302) just now!
- 讲述如何成为一名合格的DBA
- 200句脱口而出的英语日常交际用语
- BW--关于Open Hub Service的一些连接
- 使用MyEclipse 6.0连接SQL 2000和2005数据库(JDBC) 遇到的问题,急需解决
- 海拔8848
- 英语学习网站
- 电源——如何考虑
- 霍华德:二呆青年勤修苦练终成一代大侠记
- 弹出窗口总结
- Java ClassLoader深入讲解
- 注册热键,调出隐藏的窗体