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

QVConnect.exe causes out-of-memory error in QlikView using SAP OLAP Connector

I often have to extract months and months of data from SAP Business Warehouse (BW) in one go in QlikView and to do this I use QlikView’s own SAP OLAP Connector. Rather than have endless repeats of the same SAP Connector Script that changes only by…
i_saw_drones
  • 3,486
  • 1
  • 31
  • 50
0
votes
2 answers

Get objects / functions from SAP BEx (Business Explorer) Analyzer Excel add-in

I work with an Excel add-in called SAP BEx Analyzer (BExAnalyzer.xla). Unfortunately, the documentation of this add-in seems very incomplete and it's a pain to work with it. I would like to know if there is a way to inspect such an add-in to see…
user2345998
  • 649
  • 13
  • 31
0
votes
2 answers

TIMS domain in SAP BW

I am currently retrofitting several custom code review Packages developed in an ECC environment for use in BW. I used a TOC to bring them from ECC into a BW Sandbox outside of STMS and as expected got a few RC8's. As I am going through and…
apesa
  • 12,163
  • 6
  • 38
  • 43
0
votes
1 answer

Drill Through Issue in Cognos using SAP BW Data Source

We created 2 reports, Parent and Child, using a package created out of BEX query of SAP BW. This BEX query consist of mandatory variables and these are prompted in the reports. Problem what we are facing is, when we drill through from parent report…
Prasun Velayudhan
  • 537
  • 1
  • 7
  • 19
0
votes
2 answers

populating 0LOGSYS from transformation rule

I am trying to populate the infoobject 0LOGSYS in a DSO when a load from a datasource occurs. The idea being that you could tell what sourcesystem the data was loaded from that is needed for a certain requirement. As of now I have a routine set up…
Jared
  • 2,904
  • 6
  • 33
  • 37
0
votes
1 answer

Replicate Metadata gives system configured incorrectly Error in SAP BI 7.0

I am using a brand new IDES system to test create a generic extractor from ECC6.0 (EHP4 FOR SAP ERP 6.0 / NW7.01) , but my BW and R/3 system is in the same instance. I have configured this option: the global setting "BW User ALE" - BWREMOTE the…
hank511
  • 117
  • 3
  • 14
0
votes
1 answer

SAP BI 7.0 Analysis Process Desinger vs. Routine in Transformation

A1: I am confused by the usage of Analysis Process Designer (APD). What is it used for? A2: It seems that the Routine in Transformation is an alternative to APD, is it true? What is the difference between the APD and the Routine?
hank511
  • 117
  • 3
  • 14
-1
votes
2 answers

Can I have Text or Date/Time as input in SAP BPC Input Schedule

I have a SAP BPC application where I have an Input Schedule. Is it possible to make some of the inputs to accept text or date/time? For example I have a member called "Details" where the user can enter details about an operation. is it possible to…
Yao Bo Lu
  • 174
  • 11
-1
votes
1 answer

Updating cube (writeback) via MDX on SAP BW

Does anybody know if SAP BW supports UPDATE CUBE statement in MDX query? (connection to server established via XMLA) It returns some generic error and I cannot find any documentation... Same syntax works well for other providers. Or is there any…
vrata
  • 33
  • 2
  • 5
-1
votes
2 answers

SAP BW and Dynamics 365 integration

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.
magicalKhachapuri
  • 563
  • 5
  • 19
-1
votes
1 answer

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 to SAP BW from AWS DMS service and extract data…
Suvo
  • 19
  • 1
-1
votes
1 answer

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 tables contain NULL values. These are transferred…
Jan K.
  • 1,607
  • 2
  • 13
  • 22
-1
votes
1 answer

How to use OBIEE over SAP BW?

I have a requirement where I need to use OBIEE for reporting using SAP BW CUBES/MULTIPROVIDERS. How can we do it? Is the BW cube itself is implemented in the OBIEE or the reports those are developed on the BW CUBES can imported into the…
Gaurav Navgire
  • 780
  • 5
  • 17
  • 29
-1
votes
2 answers

Where-used list of inactive objects

I am trying to find out where table RS3RDFLDNEW in BW is used. But it is giving me an error. In the error documentation, it is explaining about inactive objects. Can anyone tell me how to display inactive objects for where used list. Basically, I…
AKS
  • 39
  • 1
  • 8
-1
votes
2 answers

Does SAP HANA gradually phase out SAP BI

Can HANA store all the data carried by SAP BI in HANA "in-memory"? Are there certain BI tools that are available only in SAP BI and not possible in SAP HANA due to architectural differences in nature of Data warehouse and Database tools now and in…
gram77
  • 361
  • 1
  • 12
  • 30
1 2 3
…
9
10