How to remove ‘*’ from Bex Report.

Go to SPRO-->SAP Netweaver-->Business Intelligence-->Settings for Reporting and Anlysis-->General settings-->Presenting the numeric value in the Business Explorer-->For mixed values, remove * and keep it blank and save it Or Tcode RSCUSTV4.

 

Early delta Intailization

With this option data can be written to the delta queue during an initialization request.   It avoids the downtime required when you initialize your LO extractors - it creates a delta queue for taking in new records while the init is being carried out instead of creating the delta queue after the init is successful. This option is not able with all the DataSources. 

Go to SE16 --> table name as ROOSOURCE

In the next screen give the data source name and execute.  If field ZDD_ABLE in the result has value X, then data supports for early delta initialization.  If it has space, then it doesn't support.

Steps for Early delta Initialization

1.Initialize Early delta in the BI system.

2. Go and fill setup tables

3. Do a full load to BI

4. Run delta job in R/3 (LBWE)

5. Run delta job in BI Info package

How to find a record in the PSA

·         1. Go to manage of DSO >> Contents Tab

2. Click on Change log table

3. Give the value of Purchase order number/ Sales Document # as applicable and execute

4. Request IDs >> ODSR* will be the output

5. Go to manage of DSO >> Requests tab

6. Check the request number against this ODSR* request (obtained from change log )

7. Open corresponding request in PSA (Right click of data source -> Manage)

§  Also try this

1. Call T-Code RSRQ and give the Req ID if you know

2. Request monitor screen will be opened

3. From there also you can go to PSA by clicking the PSA symbol on the top

Data for that request will be displayed in PSA. If data is deleted in PSA for that request, a pop-up will be displayed.

Unable to select the transformation in a transport request

Solution

Most probably it will be because transformation is already contained in a TR, happens mostly when we give collection mode as automatic.

1. Double click on your transformation.

2. Go to Extras - Object Directory Entry

3. Then click on "Lock Overview"

4. It will display message saying "the object is not locked" or it will show you the transport in which it is already collected.  This helps in finding to which transport request its contained.

SAP BI Runtime error: MESSAGE_TYPE_X

Solution:

1. Go to SE38 in your BW system2. Enter program name - RSSM_OLTP_INIT_DELTA_UPDATE3. Execute
4. Just enter your datasource name (is it 0FI_AA_11 ?) and logical source system name
5. Execute the program

Nothing will appear. Now execute your process chain, it will be a success.

How to download data from InfoCube to Excel

You can directly download the data of infocube to excel.

Display the data of the infocube. ON the menu bar click on LIST - - > EXPORT -- > LOCAL FILE . Choose spreadsheet. Specify the path and name of the file and click on generate. This would load the data from cube to excel on to your machine.

 Alternatively you can download the contents of your Cube into a CSV file using Open Hub destination.

 For OHD see the below steps.

1. Select Open Hub Destination from RSA1.

2. Right Click on the info area Select Create Open Hub Destination.

3. provide Name, Description for the Open Hub.

4. In template, Select Object type as "Infocube" and give the name in Name field. Press Enter.

5. In Destination tab, Select Destination type as File. Give all other details like Filename, Directory etc. select type as FILE and give SEPARATOR as comma(,)

6. In Field Def tab, you will see all the Fields that can be transferred from Source infocube to File. Click Save.

7. Right click on created open hub, Create transformation. Give Source as the infocube. Make transformation as needed.

8. Now similarly Create DTP. Then Save and Activate the DTP.

9. you can schedule your extract.

Transporting Bex Queries

·         

Create a BEx request - through RSA1 - Transport Connection and on the Transport Connection menu you need to hit on 'BEx' logo with the TR vehicle and then you will get the below screen, click on Assign/Delete, and create the TR for BEx first. All the changes you do to the transported Queries are then captured in this TR.

Go to RSA1, then transport connection in here, find the Query Elements, expanding it, you can find your query.. then transfer it to the right pane and capture the neccessary objects in requests.  A new task will be created.  You need to ensure that all the calculated key figures/ restricted key figures/ variables/ are captured in the transport request.   Once you have the request, you can release it and then import in the quality box