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.
Questions tagged [sap-bw]
139 questions
0
votes
0 answers
SSIS Data Flow Task Running Fine Separately But Not Running When Package is Run
My SSIS package has a Data flow task that is running fine and loads data from SAP BW source to SQL Server destination when only that task is run, but it is doing nothing when the package is run. The task, is not failing in the latter case. The…
Sindhur
- 1
- 2
0
votes
1 answer
Query Failure when Joining queries with LTRIM in SAP BW Eclipse Console
I am trying to run a simple query in Eclipse based SQL Console in BW/4HANA environment but the query fails with the following error:
"(" is not allowed here. "." is expected.
Query is as follows:
SELECT A2~BBP_PO_ID, A2~BBP_POITEM, A3~OI_EBELP,…
rightfit
- 1
- 2
0
votes
1 answer
Fetching SAP-BW reports via an API
I'd like to fetch some SAP-BW reports programatically, but unfortunately my SAP collegues have no idea about how to do it. I'm no SAP expert either, but as a software-engineer I'm pretty confident that there is some API I could use with python or C#…
t3chb0t
- 16,340
- 13
- 78
- 118
0
votes
1 answer
How to connect to sap bw (on linux server) from azure data factory or synapse analytics pipeline?
There are many posts and documents on connecting to the SAP BW system by installing the self-hosted integration runtime on a windows server. Still, my problem is the sap BW system is running on a Linux environment. Has anyone successfully created a…
deba prasad nayak
- 21
- 6
0
votes
0 answers
Pyrfc: MDX Queries Returning Fewer Fields than expected
Describe the bug
I am using PyRFC to pull data from SAP BW InfoCubes using BAPI_MDDATASET_CREATE_OBJECT, BAPI_MDDATASET_SELECT_DATA, and BAPI_MDDATASET_GET_FLAT_DATA. I pass in my MDX query, and the results are close to what I see in MDXTEST, but a…
C. Holt
- 101
- 1
0
votes
1 answer
SAP BW data integration with Snowflake
Is there anyway to get the data and connect directly to Snowflake without any third party or open source software?
Our current setup is getting the data from SAP BW into DATAMART and then it is used by PowerBI.
We have a client request to do…
shereen walid
- 1
- 1
0
votes
1 answer
Is there a method to convert SAP ABAP routines to SQL?
I need to replicate a provider in SAP BW system to GCP Bigquery. I have all the underlying data sources for provider copied in BigQuery. To create the provider, I need to understand the ABAP routine determining condition of joins and logic for all…
0
votes
0 answers
An error has occurred. See error log for more details. com/sap/mw/jco3/eclipse/Registry
Attempting to open SAP HANA BW in Eclipse IDE 09-21 application. The following error occurs: An error has occurred. See error log for more details.
com/sap/mw/jco3/eclipse/Registry
There are several unhandled loop exceptions in org.eclipse.ui. I…
Jack Crumbly
- 1
- 1
0
votes
1 answer
create 'artificial' step 1 variable values in SAP BW
start edit 2021.12.08
to be more specific: what is the logic/syntax to hardcode input choices for the variable prompt (second row).
WHEN 'z_step_1_variable'.
***MISSING KNOWLEDGE ABOUT ABAP***
CLEAR L_S_RANGE.
L_S_RANGE-OPT =…
potatoe
- 1
- 1
0
votes
1 answer
MDX filtering by member property on SAP BW
I'm trying to filter members on axis by their name or unique name and I cannot get MDX below working on SAP BW (over XMLA).
SELECT
{Filter([Z_PRODUCT].AllMembers, ([Z_PRODUCT].CurrentMember.Properties("MEMBER_NAME") = ""))}
DIMENSION PROPERTIES…
vrata
- 33
- 2
- 5
0
votes
0 answers
Automate refresh Power BI after SAP BW loads
Currently all business users schedule Power BI reports around 08:00 / 09:00 AM. 2 Problems... overload and the possibility that our SAP BW loads didn't finish yet.
I need some ideas how to automate the refresh of Power BI reports after our daily SAP…
Jeep
- 11
- 2
0
votes
1 answer
How Cloud Data Fusion connect to SAP NetWeaver Gateway and SAP BW/4HANA
I've been searching SAP NetWeaver Gateway and SAP BW/4HANA connector in Cloud Data Fusion "HUB" on the top right of console but I can't find any. How can I connect to those SAP NetWeaver Gateway and SAP BW/4HANA if it doesn't appear in the "HUB".
0
votes
1 answer
How to use file name prefix in Data Factory when importing data into Azure data lake from SAP BW Open Hub?
I have a source of SAP BW Open Hub in data factory and a sink of Azure data lake gen2 and am using a copy activity to move the data.
I am attempting to transfer the data to the lake and split into numerous files, with 200000 rows per file. I would…
the_james
- 65
- 1
- 6
0
votes
0 answers
Consuming REST API into BW/4HANA?
I am new to the world of APIs. I am trying to utilize a REST API to GET and POST from a certain website and persist those values once a day into a SAP HANA table via SDI replication. I was able to successfully test the API in Postman using a JSON…
user14874476
- 11
- 1
0
votes
0 answers
Delete from C_t_data for Bi Extractor
Trying to delete unwanted records from extractor Badi logic. Due to performance reasons, I want to run extractor for only one company code.
Can we use this below?
Delete c_t_data where bukrs NE t_cc.
t_cc is a variable that stores company code…
Rubane
- 67
- 1
- 8