Questions tagged [sap-bw]

SAP Business Warehouse (SAP BW) is SAP’s Enterprise Data Warehouse product. SAP BW is part of the NetWeaver.

SAP Business Warehouse (SAP BW) is SAP’s Enterprise Data Warehouse product. SAP BW is part of the NetWeaver.

139 questions
1
vote
2 answers

Copying Data from SAP BW to Azure Data Lake Store using Azure Data Factory

I've been trying to copy some data from an on-premises SAP BW to a cloud Azure Data Lake Store. I've already configured the sink as the Data Lake Store but i'm having trouble to configure the source. Already downloaded the netweaver library and put…
1
vote
0 answers

Export SAP BW data to SQL SERVER 2012

I am trying to bring data from SAP NetWeaver BW cube to SQL SERVER. I'm following this document TO ACHIEVE THIS https://msdn.microsoft.com/en-us/library/cc185161(v=bts.10).aspx But I am unable to get .NET Framework Data Provider for mySAP Business…
keloth k
  • 35
  • 10
1
vote
2 answers

How to create a SAP Variable that must be specified by user like prompts do?

I am trying to build reports using RESTful API for Business Objects 4.2. In the "SAP BusinessObjects RESTful Web Service SDK User Guide for Web Intelligence and the BI Semantic Layer", section "6.5.1 Parameter Response Body Schemas" mentioned that…
1
vote
1 answer

Initialization of query failed - BW_REPORTING_FPM001 error

I am implementing Trial Balance(Version 2) FPM/WebDynpro App from Fiori Apps Library following App Implementation : Trial Balance guide for S/4 Hana 1610. When I launch the Trial Balance App. It says Search: Null object exception Initialization of…
Razz
  • 87
  • 3
  • 21
1
vote
0 answers

Loading Data into SAP BW via SSIS

I am trying to get the Microsoft Connector for SAP BW ver 1.1 working in our environment. This is to push data into BW only not extract it. I have put the LibRFC.dll in place on the SQL server and can create a connection to BW. When I test the…
1
vote
0 answers

Connecting SAP HANA BW with Microsoft PowerBI

So for the past couple of days, I've been trying to establish a connection between SAP BW and Microsoft PowerBI. I'm establishing the connection between the two systems using the driver (HDBODBC) provided in the HANA Suit. Using the connection…
Isuru
  • 3,044
  • 6
  • 30
  • 39
1
vote
1 answer

SAP BW Info Providers and SSIS

Is there a way to extract data directly from SAP BW Info Providers (Info Cubes, Multi Providers, Info Objects, Query's) using SSIS without having to use Open Hub or Infospokes. Using SQL Server 2012.
1
vote
1 answer

How to create SAP BW as a data source for cognos?

I am new to IBM Cognos and I am using Cognos 10 trail version. I did some of reports using DB2 as a data source. Now I trying to use SAP BW as a data source and I surfed the web and have seen the IBM Cognos guide and in that I went through the steps…
Pavan Kumar
  • 205
  • 1
  • 14
1
vote
1 answer

Header in Transformation File (SAP BPC) getting evaluated even when not desired

I am facing an issue with my flat file. The BAdI is processing the header data as the body of the flat file. Due to this, the TIMEID, which is conditioned to be an year belonging to 'Q1', is giving the error. If I replace the TIME label with 2014.Q1…
1
vote
6 answers

What is MDX and what is its use in SAP BPC

I would like to know more about "MDX" (Multidimensional Expressions). What is it? What is it used for? Why would you use it? Is it better than SQL? What is its use in SAP BPS (I haven't seen BPC, just heard that MDX is in it and want to know…
Kryten
  • 3,843
  • 5
  • 37
  • 42
1
vote
1 answer

Data Provider for SAP BW

I am trying to create SSIS package for loading the data from SAP BW to SQL Server. But after read through many books people are saying we need Data Provider to load the data from SAP BW to SQL Server. Can someone suggest me where can I get these…
Sandeep Pulikonda
  • 774
  • 3
  • 13
  • 26
1
vote
1 answer

How to load data from SQL Server to SAP BW using SSIS

I would like to load data from SQL server to SAP BW using SSIS. Could someone help me on it, how can I do it? Currently I am using SQL Server 2005.
Sandeep Pulikonda
  • 774
  • 3
  • 13
  • 26
1
vote
1 answer

Restart my delta loading after delete the infopackage in PSA by mistake

I have got one issue. Can some one please help me to resolve this? I was trying to extract some data to data source 0FI_AP_6... then in InfoPackage Monitor I can see like.. -->Requests (messages): Everything OK -->Extraction (messages): Everything…
hank511
  • 117
  • 3
  • 14
1
vote
1 answer

pull the data from SAP BW system and process in Java

We have a requirement to develop an application that pulls the data from SAP BW system and display it on a Flex chart. The Flex guy wants the data in the XML format. I am the middleWare guy who sits in between the SAP BW and the Flex. I need to pull…
jai
  • 21,519
  • 31
  • 89
  • 120
0
votes
0 answers

Power BI is unable to parse OData response result from SAP Commerce

I am trying to connect from Power BI Desktop to SAP Commerce, through an OData interface that exposes orders: https://my-sap-commerce.com/odata2webservices/oDataTest/Orders By default, the query retrieves 10 records but I get the following error on…
aloplop85
  • 892
  • 3
  • 16
  • 40