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