Mar 07, 2018 SAP BW 7.50 is the next cornerstone on the simplification road towards the BW/4HANA platform. With the full support of advanced DSO (aDSO) objects, the composite provider usage (CP) and further enhancements for the BW-MT in Eclipse, e.g. Query designer or InfoObjects maintenance, SAP BW 7.50 is the Release on the Road to BW/4HANA. I was very excited about the new futures in BW 7.0 when it was announced; release includes many features, such as BW Accelerator, DTP, Different types of DSO and many more.Now the turn come for BW 7.3, most of us would interested to know what’s new BW 7.3, now I am trying to describes the new functions/ future in SAP BW 7.3 in Part 1. Visible Benefits of SAP Netweaver BW 7.3: So, all in all, SAP BW 7.3 looks quite promising with all the below benefits. Wizard based system configuration - Supports copying data flows, process chains etc. Accelerated data loads - SAP has rewritten underlying code for data loads for optimized performance. This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required). Search for additional results. https://ubeiqt.weebly.com/voice-auto-tune-effect.html. Visit SAP Support Portal's SAP Notes and KBA Search. Guiding for SAP BW/BI Certification - Sample questions and documentation for HANA certification provided. Guiding Resume Preparation & Tracking Interviews. Flat File 7.3 +++> 5.Conversion Routines in SAP BW; SAP BW Extraction +++> 1.Sales & Distribution Overview +++> 2.SAP Finance Overview +++> 3.Extraction - Overview.
1. the issue
In 2009 Microsoft certified the Microsoft Connector 1.1 for extracting data from SAP BW 7.x via the
Open Hub Service API :
The SSIS connector for SAP BW is for free but has to be downloaded from the SQL Server “feature pack”.
Here is a link to the 2008 R2 feature pack : https://juqutoci.tistory.com/8.
You have to scroll down until you find
“Microsoft® Connector 1.1 for SAP BW for SQL Server® 2008 R2“. Additional documentation can be found here : http://msdn.microsoft.com/de-de/library/dd299430.aspx
Unfortunately the Open Hub Service API had a restriction regarding hierarchy information. It was possible
to extract InfoObject attributes as well as texts – but not hierarchies. The feature simply wasn’t there. 2. how the issue was handled in the past
As mentioned above the Open Hub Services API didn’t support hierarchy extraction in the past. Therefore
it was necessary to look for alternative ways in order to extract the data. I published a little paper here : http://www.microsoft.com/enterprise/partners/sap/technology.aspx You have to look in the “Technology->Interoperability” section under “Business Intelligence”. There you find a little paper with the title : “How to unload Hierarchies from SAP BI 7.0” : How to unload Hierarchies from SAP BI 7.0 This paper shows a few options how to solve the problem. 64 bit vlc player for windows 7. ![]() 3. how the issue was solved in BW 7.3One new feature in SAP BW 7.3 is the improvement of the Open Hub Service interface to allow extraction of hierarchies. The Open Hub Destination mechanism works the same way as with InfoObject attributes or texts. Therefore no change was necessary on the Microsoft Connector side. It works absolutely transparent for SSIS. https://skieytwisted.weebly.com/product-activation-key-for-assassins-creed-brotherhood-leonardo.html.
The following walk-through section shows some screenshots of a simple hierarchy extraction example.
This blog just focuses on the data extraction. How to use this data to map the hierarchy into SSAS is a different story and will be handled in a separate blog. While it’s easy to do this with a basic parent-child hierarchy there are some challenges when compound keys are involved or in case the BW hierarchy is time dependent. 4. walk-through section to show how the new SAP BW 7.3
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |