Stack Overflow
Stack Overflow

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
3 answers

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 report synchronously using the GET…
Dani
  • 2,602
  • 2
  • 23
  • 27
1
vote
1 answer

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 bwConn bwConn.call('BAPI_MDDATASET_CREATE_OBJECT',…
Ranjith Venkatesh
  • 1,322
  • 3
  • 20
  • 57
1
vote
2 answers

How to compute 'Mode' as in Mean, Median Mode using BEX?

Have any one explored how to perform Mode (one of the 3 challenges.. Mean, Median & Mode) using SAP BEx Query Designer/WAD (no BO tools). Any inputs to compute Mode for a data set would be very helpful.
closebrace
  • 333
  • 1
  • 4
1
vote
1 answer

How to fetch tables and columns from SAP BO universe Data Source?

I am able to get folders of a particular universe by using REST API of SAP BO Universe semantic layer. Now I need to get the main tables from underneath data source of the universe. I've found out that COM SDK of SAP should be used for this, however…
Kranthi.Gogikar
  • 31
  • 5
1
vote
1 answer

How to use MDX Functions in SAP dreamweaver's MDXTEST

This is more or less the query I'm after: WITH [Measures].[rowcount] AS COUNT([SomeDimension].Members) SELECT [Measures].[rowcount] ON ROWS FROM [FOO/BAR] Ultimately I'm after a row count of the fields after some 20 dimensions are applied -…
Ryan B.
  • 3,575
  • 2
  • 20
  • 26
1
vote
4 answers

Select row from table where column value has "highest priority"

I've got a database table with the columns DOC1, DOC2 and CLIENT. I'm trying to select one row per CLIENT, whose DOC1 column has the highest priority based on the following order, from highest to lowest priority: ITCI > ITPP > ITPS > ITPT. Here is…
Wafa El Maizi
  • 33
  • 5
1
vote
1 answer

Is there a way to suppress a prompt asking for query parameters when updating a data source (SAP) from an excel macro?

I am updating a data source from an Excel macro by running this: Application.Run("SAPExecuteCommand", "RefreshData", "DS_1") That generates a prompt asking for the user to input query parameters. However, I just want to go with the already set…
soft_weaver
  • 23
  • 2
1
vote
1 answer

SAP BW to PowerBI data loading taking huge time?

We have a cube that contains 1.6 years of data and it is taking a long time to load. Previously we got a memory issue error, but we have increased the SAP Memory size. Can anyone explain me any ways to troubleshoot, or any best practices that we…
vikaskumawat80
  • 109
  • 2
  • 4
1
vote
0 answers

Data type conversion from SQL Server to SAP BW

We want to use a "db connect" data source to load data into BW. We have a CHAR field that is not being recognize by the "db extractor" as CUKY data type in SAP. We've changed the data type to multiple different formats and types but there is no…
AdemusPrime
  • 23
  • 5
1
vote
1 answer

Running from CMD and having problems to use SaveAs

I am able to connect to our SAP BW (Business Warehouse) which is on a server, to open specific queries but I am unable to Save it in the end. I tried to search on various forums, but they all use the same logic as I do. I am using CMD to run this…
Pavol Palinovic
  • 31
  • 5
1
vote
3 answers

Move SQL Server Database data to SAP BW

I have read a few articles about moving data out of SAP BW and into SQL Server. I cant find any articles on moving the data from SQL Server to SAP BW, is it even possible and if so what would be the best way to handle this?
Etienne
  • 7,141
  • 42
  • 108
  • 160
1
vote
2 answers

Data factory SAP BW

I'm trying to use the Data Factory in Azure to export data from a SAP BW. The connection is working, and I'm able to get data. The problem is how I'm getting the data. The picture describes the issue pretty well. Has anyone encountered something…
Spoe
  • 21
  • 2
1
vote
3 answers

How to create a custom extractor in SAP R/3 system?

I have to create a custom extractor in SAP R/3 system. What are the ways to extract the data from required tables like COVP, COEP, EKKN, etc.?
Gaurav Navgire
  • 780
  • 5
  • 17
  • 29
1
vote
2 answers

Azure Data Factory V2: MDX Query on SAP BW exception Microsoft.DataTransfer.Common.Shared.HybridDeliveryException

I am trying to fetch data from SAP BW system into Azure Data Lake using MDX Query in SAP BW connector. But I am getting exception message in Azure is following : { "errorCode": "2200", "message": "Failure happened on 'Source' side.…
PSM
  • 21
  • 4
1
vote
1 answer

Silent logon to SAP BW server via Excel VBA script and bexanalyzer

We are running SAP BW with BExAnalyzer 7.5. I've been trying for days to establish a connection to the SAP BW server, but unfortunately I am not even receiving an error message. So it seems the logon has succeeded, but no data from BW is fetched, so…
RWatermelon
  • 63
  • 1
  • 1
  • 11
1 2
3
…
9 10