145 questions
0
votes
1
answer
55
views
How to use validate schema in mapping data flow whose source is paramaterized SAP CDC dataset
I have a requirement that we don't want to change the schema of the dataset in our destination (which is ADLS) when there is a change in source (SAP BW).
I have created a mapping data flow with a ...
- 11
0
votes
0
answers
42
views
Querying Data From Salesforce to SAP BW/4HANA by SAP PI/PO as middleware?
I am new to SAP PI/PO. I want to know the steps to fetch the data from Salesforce to SAP BW/4HANA by SAP PI/PO as middleware. My case is that I have to pass a SOQL query to salesforce using rest API ...
0
votes
0
answers
56
views
How infopackage for extraction delta keeps track of what it did?
If you create an infopackage that extracts full but with date period condition, is it going to change something in what infopackage that extracts delta does?
I have missing data from a year ago and i ...
- 1
1
vote
0
answers
172
views
Extract BW/4HANA using Python vs exporting data directly
I am trying to explore the option of exporting data from BW/4HANA to AWS S3 in flat file format.
I have two options
Open Hub
Use Python
I checked with SAP BW consultant in my company. He said I can'...
- 207
1
vote
0
answers
308
views
How to connect to a SAP BW Cube from Python
I have a SAP BW cube and I can access it using power query with the "SAP Business Warehouse Message Server" Power BI connector,
The power M code is something like:
let
Source = ...
0
votes
0
answers
491
views
How to consume OData service on SAP BW from an external system?
I'm trying to call an OData service that executes a query on SAP BW (SAP NetWeaver 7.5 with HANA database) from a system external to SAP.
I followed the steps in this guide: https://help.sap.com/docs/...
- 21
2
votes
0
answers
208
views
How to connect SAP BW to Jupyter Notebook
I need to connect some procedures located on SAP BW (SAP HANA DB) with a data science platform containing Jupyter Notebooks. The goal is to exploit SAP BW data from Jupyter Notebooks for analysis.
I ...
- 21
0
votes
1
answer
426
views
How to include multiple items in "SAP VARIABLES"?
I'm new to developing queries in BW MDX. And I have a question that seems simple, but I can't find any documentation/solution anywhere.
I'd like to know how to add multiple "filters" for the ...
- 33
0
votes
1
answer
596
views
Get SAP BW infocube data with pyrfc RSDRI_INFOPROV_READ_RFC
I am trying to get data from an SAP BW infocube using Python with pyrfc. I am currently using the ABAP function RSDRI_INFOPROV_READ_RFC, but when I print the result I am unable to get something ...
- 11
1
vote
0
answers
198
views
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 ...
- 922
1
vote
1
answer
1k
views
How to use "dynamic content" as a filter in SAP CDC connector in Azure Data factory
I'm trying to use SAP CDC linked service in my ADF pipeline to import some data. And also there is an option to filter out some data on source side using "Selection" part of Copy activity ...
- 341
0
votes
1
answer
487
views
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.
...
- 1
2
votes
1
answer
1k
views
How to connect to SAP BO universe via Power BI?
Our enterprise management database is housed in Business Objects Universes. I'm looking for our Power BI analysts to create Power BI reports by connecting to universes.
This link says such a connector ...
- 9,536
0
votes
1
answer
1k
views
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 ...
- 18.5k
0
votes
1
answer
330
views
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 ...
0
votes
1
answer
769
views
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 ...
0
votes
1
answer
2k
views
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 ...
1
vote
2
answers
5k
views
How to pull Data into python from SAP ERP [duplicate]
I am a data scientist and do not have any prior background in SAP.
I need to pull data (query and Qube) from SAP ERP to python for some predictions and automate the process. but I am not able to find ...
- 126
0
votes
0
answers
4k
views
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 ...
0
votes
0
answers
686
views
Is there a way to connect SAP BW/4HANA to Snowflake? (data through Open hub need to push to Snowflake)
Open hub needs to push to Snowflake. I did not find any direct method to push data from SAP BW to Snowflake
1
vote
1
answer
655
views
Unable to access Rest URL using scalaj-Http client with SSL certificates(JKS File)
I am new to Scala. I am trying to access REST API URl and trying to get json data from there using Scalaj-Http with Spark framework in local vm(Intellij). But with the following Code I am always ...
- 41
0
votes
1
answer
337
views
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***
...
- 1
0
votes
0
answers
782
views
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 ...
- 11
0
votes
1
answer
239
views
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 ...
1
vote
1
answer
1k
views
2LIS_17_I3HDR data is not being pushed into ODQDATA
We are extracting SAP PM data to BO Data Services (BODS) using Operational Data Provisioning (ODP), and have successfully done this for notifications. We've gone through all the LBWE config for ...
- 41
0
votes
1
answer
2k
views
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 ...
- 85
1
vote
0
answers
221
views
Error while trying to obtain information from source and destination in table RSBASIDOC
There is a package which is used to extract data from SAP systems to SQL, but we are getting the below error while running the package.
Error while trying to obtain information from source and ...
1
vote
0
answers
429
views
Importing XML files to SAP BW
I have the great task of creating 300 Restricted Key Figures (RKF) in SAP BW. So far I've been doing it by hand but I found the option to Import XML files into SAP BW (in Eclipse Environment).
To get ...
-4
votes
1
answer
416
views
How to migrate huge data (50 TBs) from On-premise SAP Hana to GCP [closed]
Context:
The Data warehouse is built using SAP BW On HANA. It is operational for quite some time. It has over 50TBs of data. As a strategic decision the data has to be migrated on GCP to BigQuery (one ...
0
votes
0
answers
1k
views
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 ...
- 11
1
vote
0
answers
573
views
Issue to ingest data from SAP Cube or Calculated View in Azure Data Factory
I have SAP Hana connected in Azure Data Factory. I am ingesting data from SAP Cube or calculated view but in preview I get only columns(Schema) but no data. I have applied column filters but still it ...
- 171
-1
votes
2
answers
674
views
SAP BW and Dynamics 365 integration [closed]
What is the best practice to build an integration between Dynamics 365 and SAP BW (dynamics data should be imported to SAP BW on every update/change event).
Thanks.
0
votes
0
answers
119
views
Delete from C_t_data for Bi Extractor [duplicate]
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.
...
- 67
1
vote
1
answer
2k
views
Data not received in PSA Table (SAP BW)
I installed SAP Netweaver Application Server 7.52 SP04 on my virtual box, it's working fine.
I have created Z* master data table and populated it with 2 mock records.
I created datasource via ...
- 367
0
votes
2
answers
2k
views
What is the difference between SAP BW\4 HANA and SAP native Hana?
Is S/4 HANA and BW/4 HANA are same? Also what is the difference of this with BO? If it is just reporting then why still BO?
Appreciate your help.
- 158
0
votes
0
answers
432
views
SAP BW Incomplete data on reports after data loading
I'm a beginner in SAP BW and I have a problem with my SAP instance. Some of the data disappears on reports after loading.
My report uses the source table /BIC/TABX.
Loading data into this table looks ...
- 1
1
vote
1
answer
721
views
Change titles for the dimension properties of MDX Query
I want to rename the columns that I am querying from the MDX query but in the DIMENSION PROPERTIES, I have tried different approaches (WITH MEMBER / WITH SET ...) but they only work for the rows/...
- 1,141
-1
votes
1
answer
159
views
AWS DMS Service and S3
I have source system in SAP BW and want to migrate data into AWS S3 bucket using AWS DMS (Database migration service). All the source data are in flat file format (Either .CVS or .xls).
How to connect ...
- 19
1
vote
0
answers
1k
views
Can you connect to SAP Query with Python same way you do it with SBOP Analysis for Excel?
So currently I use MS Excel to explore and pull some data from a SAP Query I have access using SBOP Analysis tool in Excel.
Now I need to automate this process and what I have done is use a Macro to ...
- 121
1
vote
1
answer
194
views
import sap bw over hana via sqoop
Currently I am trying to import a sap hana table with sqoop. Here I encounter the problem that both the table names and the column names contain forward slashes "/".
For the table names I ...
- 1,576
0
votes
1
answer
189
views
Identifying Streaming Process chains
I want to check all the streaming Process chains we have in our system. I tried to check in ST13 BW tools but streaming column is not there to identify.
Is there any way to find Streaming Process ...
- 11
0
votes
0
answers
354
views
MDX query is reporting a unique row for each instance rather then rolling the data into one row where multiple column details apply
When I use the below MDX query on Azure Data factory Pipeline which is used to transfer data from SAP BW to Azure:
SELECT { [Measures].[00O2TN6100F25XV2PK2K7KLIP] } ON COLUMNS,
NON EMPTY { [...
- 1
0
votes
0
answers
1k
views
Connect to SAP BW via Open Hub with Azure Data Factory
I’m trying to load SAP BW data into Azure Data Lake with ADF, I have:
Installed Self-hosted IR (using my laptop for testing purpose)
Installed SAP Connector for Microsoft .NET 3.0
As per https://...
2
votes
0
answers
2k
views
Cannot see any data from Azure Data Factory connecting to SAP Open Hub
I'm trying to connect the SAP BW using SAP Open hub. The connection (Integration Runtime) is successful, however, when I create a dataset, I get the following error when I click on preview data. Even, ...
- 31
1
vote
3
answers
2k
views
Download scheduled Webi report from File Repository Server
Having launched a scheduled report in SAP BO, is it possible to somehow download from the file repository server?
I am working with the Web Intelligence RESTful API. While it is possible to export a ...
- 2,660
1
vote
1
answer
914
views
SAP BW Data Extraction using pyRFC fails with character limitation on Command text
Environment: Windows
Programming language: Python
Package: pyRFC
SAP: SAP RFC SDK
I am trying to call the following method BAPI_MDDATASET_CREATE_OBJECT after connecting to the BW through the object ...
- 1,362
0
votes
1
answer
805
views
Not able to start the SAP BOBJ server
I have installed SAP BOBJ server in Portable SSD(External Disk) with the help of SAP consultant. But, when I start the service(BI Agent Windows Service), showing status as "Running" for few seconds, ...
- 465
2
votes
1
answer
2k
views
Extract table from SAP BW to Azure Data Lake Gen2 using data factory
I would like to know the procedure to extract table from SAP BW installed on Azure cloud to Azure data lake gen2. I want to use ADF to copy data from SAP BW to Data lake.
Can we connect ADF to SAP ...
- 978
-1
votes
1
answer
2k
views
General replacing of NULL values in SQL Views
We have a fairly recent version of a SQL Server that we're using to extract data into a SAP BW Datawarehouse. We're using views to access data in tables on the SQL server. Some of the fields in these ...
- 1,608
0
votes
1
answer
267
views
Can I open multidimesional model in Visual studio from SAP BW Query?
I have installed Visual Studio 2017 with SSDT extension.
There is a Query (on OLAP) in SAP BW. I can connect to this query using Analysis for Office from Excel to see the data from this query. This ...
- 3