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
3
votes
1 answer

How do I configure my Microsoft Access database to pull source data directly from SAP BW?

I use several Microsoft Access databases on a regular basis to create reports. To get the source data, I currently have to log in to SAP BW (via SAP NetWeaver), run the source data report, export the results as a .csv file (but actually saving it as…
triple_helix
  • 81
  • 2
  • 8
2
votes
1 answer

Exporting Excel files from SAP BEx with pivot tables

I currently have a report which will be emailed to business users weekly. The data output can only be CSV/XML and I do not have the ability to automatically add the requested pivot tables. Therefore, I am attempting to pull the data with a…
Robbie Guilfoyle
  • 3,363
  • 1
  • 18
  • 18
2
votes
7 answers

Is there a better way to convert SQL datetime from hh:mm:ss to hhmmss?

I have to write an SQL view that returns the time part of a datetime column as a string in the format hhmmss (apparently SAP BW doesn't understand hh:mm:ss). This code is the SAP recommended way to do this, but I think there must be a better, more…
Johann J.
  • 309
  • 1
  • 4
  • 11
2
votes
2 answers

SAP .Net Connector 3.0 - Get Data from BEx Queries

I now have to work on a new project extracting financial data from SAP R/3 into Excel and some other datamart. Our SAP guys says, the best way to get the financial data is from BW using BEx and they build couple queries in BEx and I was able to get…
Bhuvan
  • 1,523
  • 4
  • 23
  • 49
2
votes
1 answer

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 directly with SAP connector? Do I have to install…
Lilly
  • 910
  • 17
  • 38
2
votes
2 answers

How to use MDX query to specify date range

I'm recently trying out using MDX query in Power BI to query information directly from SAP Business warehouse cube. I encountered an error message that I can't figure out how to solve. The error message is: "SAP Business Warehouse: Specify a value…
Lambo
  • 857
  • 3
  • 14
  • 39
2
votes
1 answer

SSIS 2014 integrate SAP BW, MS Connector 1.1

I'm trying to setup the integration between SQL Server 2014 and SAP BW 7.3. I read a white paper but it was talking about SQL 2008 and MS Connector 1.0. I'm using SSIS 2014 on VS 2012 with MS Connector 1.1 librfc32.dll is in system 32 folder. When…
Ml Ck
  • 37
  • 7
2
votes
0 answers

Pentaho reports with OLAP data source and SAP BW - poor performance

I have few BEx queries (OLAP cubes for third-party client) and .prpt reports in Pentaho that uses these BEx via OLAP data source (OLAP4J, MDX). When I execute these BEx in SAP BW or even directly as SOAP service (XML/A execute command via SoapUI),…
semenchikus
  • 730
  • 8
  • 17
2
votes
0 answers

Calling OLAP BAPI from C++

I am trying to use SAP OLAP BAPI for a very simple task. I want to connect to a SAP BW server, send an MDX query, get the result and disconnect. While I seem to have no problems connecting and disconnecting from the server, sending a query and…
Valeri Kim
  • 21
  • 1
2
votes
2 answers

Programmatically retrieve BAdI from BW. How?

I would like to retrieve programmatically the source code of the ABAP programs generated using BW. I would like to have an ABAP program that can retrieve BADIs source using their name as parameter and then save on local disk the source saving each…
bidi
  • 150
  • 1
  • 14
2
votes
1 answer

Programmatically retrieve SAP BPC Dynamic Script source code

I would like to know how to retrieve the source code of a SAP BPC package Dynamic Script. I'll try to explain: in SAP BPC I can write a component called Dynamic Script, I can save the source using the Excel Addin. The Dynamic Script is associated to…
bidi
  • 150
  • 1
  • 14
2
votes
1 answer

DTP routine to find timestamp range

I am working on a DTP filter routine for a timestamp field in the format of YYYYMMDDhhmmss. I am trying to declare the range as ({timestamp 3 months ago} to {current timestamp}). I am very new to ABAP and basically have the code set up right now so…
Jared
  • 2,904
  • 6
  • 33
  • 37
1
vote
1 answer

how to load sapbex.xla when the workbook opens

I open a query from SAP BW... I make all the changes I need and I even check the box that says Refresh query every time you open the workbook. The problem is that when I reopen the workbook it's just like a regular Excel, because the SAPBEX.xla file…
Andrei Ion
  • 1,777
  • 15
  • 34
  • 54
1
vote
2 answers

SQL Server 2008 R2: Import table from text file when column names have a / in them

How do you import a table into a database from a text file when that table has /'s in the column names? I have a SQL Server 2008 R2 table with columns that have /'s in their name. (SAP Database) For example: /BIC/FIC_SD001 has a column named…
Neil Hoff
  • 2,025
  • 4
  • 29
  • 53
1
vote
0 answers

SAP BPC get content of AppPublication folder

Are there anyone that have tried to get the content of the folder called AppPublication in SAP BPC? I have some files that I have published using SAP BPC ePublish -> Web Ready File Now I want to create a list using XHTML that contains all the files…
Yao Bo Lu
  • 174
  • 11
1
2 3
…
9 10