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

SAP Vora dealing with decimal type

So I'm trying to create and load Vora table from an ORC file created by SAP BW archiving process on HDFS. The Hive table automatically generated on top of that file by BW has, among other things, this column: archreqtsn decimal(23,0) At attempt to…
Roman
  • 238
  • 1
  • 14
0
votes
2 answers

Forward slash (/) character in SAP Vora table columns

I've got data from a SAP BW InfoProvider written to HDFS. Now I'm trying to make that data available for reporting in Vora 1.3. I'm trying to run a statement in Vora Tools SQL console, starting with: CREATE TABLE F002_5_F (calyear string, …
Roman
  • 238
  • 1
  • 14
0
votes
1 answer

How to debug specific data package in RSA3

I'd like to know how one can debug a specific datapackage in RSA3 transaction. For example, the record in the data package 23 has errors, is there any way that I can put a breakpoint to the data package 23 and so I could observe just only the…
Czarinaaaaa29
  • 311
  • 2
  • 8
  • 23
0
votes
1 answer

How to skip xml attribute or element when generating xml in SAP BODS?

I am trying to figure out how I can skip an attribute or element writing on to XML. For ex: ... ... .. is enumerated and can only accept 'Y' and this needs…
SKB
  • 11
  • 3
0
votes
1 answer

SAP BW: Error deleting request

In SAP BW I can delete requests. However when I try to delete a request I see a red status. Mouseover shows "Fehler beim zurückrollen des requests DTP....; nur Rollback erlaubt" When I click on the status icon I get the message "Der Request ist…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

HANA Studio / BW Modelling Exception opening Info Object

I downloaded Eclipse and installed the SAP plug-ins. When opening a InfoObject I get the following Exception: java.lang.IllegalStateException: java.lang.NullPointerException at…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

DTP how to view status / log?

Envrionment: SAP BW In SAP BW I execute a DTP (Data Transfer Process). After executing the DTP a dialog pops up if I want to see the Request-Monitor. But how to open the request monitor to view the status of a DTP other than clicking on yes of the…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
1 answer

How do I wait for the end of BEx Analyzer refresh?

I am attempting to create a macro which opens up a file, refresh data from a SAP BW query and will then save and close. Currently the macro initiates the refresh however it moves on to the Save and close command before it has finished and therefore…
R. Patrick-White
  • 83
  • 1
  • 2
  • 12
0
votes
2 answers

How to create an INCLUDE program?

Working with SAP will eventually lead to use of includes (same as includes in PHP) When working e.g. with transformations (Transaction RSA1) you can use includes by using the include . You can create an INCLUDE with the same statement…
Thorsten Niehues
  • 13,712
  • 22
  • 78
  • 113
0
votes
0 answers

Access to SAP RSPCM_WEB transaction from outside

I'd like to write a mobile app for process chain monitoring. I know the RSPCM_WEB transaction, but we need some more functionality. Is it possible to access built-in SAP functions like activating a DSO by given name or start other process chains…
Sp0tlight
  • 409
  • 1
  • 4
  • 18
0
votes
2 answers

BAPI_MDDATASET_CREATE_OBJECT MDX Query

I would like to make a BAPI call from Java to the BAPI BAPI_MDDATASET_CREATE_OBJECT. Therefore I want to use the following MDX Query: SELECT [0DISTR_CHAN].Members ON COLUMNS, [0MATERIAL].Members ON ROWS FROM [$/PKG/AB_C01] Because the Parameter…
LStrike
  • 1,598
  • 4
  • 26
  • 58
0
votes
1 answer

Convert SAP BI hierarchy to flat table

I have the below "old" table where Level "1" is top level, "CC" is the smallest unit inside our company: What I want to do is convert this table into a flat table with additional column like level 1 / level 2 / Level 3, which show parent department…
Hai Anh Tran
  • 5
  • 1
  • 4
0
votes
1 answer

Why are dimension tables denormalized in an InfoCube?

I'm in the process of learning SAP BW at work. The SAP class material states that in InfoCubes, dimensions are denormalized. I understand the benefit of normalized tables, but don't understand why dimensions would be denormalized.
Jan K.
  • 1,607
  • 2
  • 13
  • 22
0
votes
1 answer

SAP BI RESTful services don't work with basic authentication

I'm trying to call the SAP BI/BO RESTful webservices using basic authentication. I enabled basic authentication in the WACS and tested with this service: http://host:6405/infostore/16422 This works! I can get the report metadata as either XML or…
user1884155
  • 3,616
  • 4
  • 55
  • 108
0
votes
1 answer

How to query SAP Bex using batch files

I'm wanting to automate and schedule some SAP queries. The queries themselves are fairly standard and the only variable will be the date, I want it to pull the latest 52 weeks, every Sunday. I think the best way to do this is to set up a batch file…
Boozmork
  • 31
  • 4
1 2 3
…
9 10