Steps to Transport SAP BI Queries from Development to Quality Server


In this post I present basic steps to transport SAP BI queries from development to quality server. The steps are performed in source and target system, so you need authorizations to release and import objects.

Source system
 
Start with transaction RSOR (Transport Connection), insert initial and target source system names using Conversion button (2) and choose grouping type (3). Select queries you would like to transport to target system and press Execute and than Transport objects (truck) button.


Release the change request to transport using SE10 transaction. Press Display, choose tasks and requests you would like to release and press the button with single truck (or F9). When both task and request have been released successfully, start transport in target system.
Target system
 
To import queries to quality system start STMS transaction > Import Overview (F5) > Display Import Queue. On the Import Queue screen select the request and press Import (truck with a small loading). Choose target client's number and press enter. The queries will be written to the target system.

Standard BEx Transport Request
 
When the request, you have released, was set as Standard BEx Transport Request, you need  to created a new standard request. If there is no standard request, nobody is able to process queries or workbooks on the system. When you try to do so, you will receive the error: The query could not be saved due to a problem in transport. BEx transport request is not available or not suitable.
To create a new request you need to press BEx and than Assign / Delete button, add the request and save the choice.



Now all new objects and modifications will be written to the chosen BEx transport request. For more information on the standard transport request see this note:194051.

Additional resource:
Transporting: role and objects.
Authorizations for change and transport: S_TRANSPRT and S_CTS_ADMI.

7 comments:

  1. This article discusses the problems of Fly Tipping in the UK, and the dangers of waste dumping, and the removal of waste. Whilst, Fly Tipping is a gradually decreasing crime, it is still heavily important to reduce it in order to reduce costs for residents, businesses and construction sites. TCTippers

    ReplyDelete
  2. How would you like to book your next trip from the comfort of your laptop or desktop computer, searching and booking flights, hotels, rent a car, buy travel insurance and even tickets for amusement parks, theaters, shows, and games, all over the world? Take a look at this article. website

    ReplyDelete
  3. I am glad that I saw this post. It is informative blog for us and we need this type of blog thanks for share this blog, Keep posting such instructional blogs and I am looking forward for your future posts.
    Cyber Security Projects for CSE

    JavaScript Training in Chennai

    Project Centers in Chennai for CSE

    JavaScript Training in Chennai


    ReplyDelete
  4. I have been meaning to read this and just never obtained a chance. It’s an issue that I’m really interested in, I just started reading and I’m glad I did. You’re a fantastic blogger, one of the best that I’ve seen. This weblog undoubtedly has some facts on topic that I just wasn’t aware of. Thanks for bringing this stuff to light. where the three rivers meet

    ReplyDelete
  5. Every question related to solo female travel safety will never receive a full, encompassing and concrete answer; there are just too many variables. These ever changing factors are also what make traveling so exciting. You never know what to expect. Therefore it is important to prepare for aspects we can control, especially as a female traveling alone ronaldo nazario

    ReplyDelete
  6. Are you seeking information on a Home Business, or possibly you've read a whole lot and now you are trying to sort out what might be the BEST home based business? This is a long article, but stick with it all the way and we're very confident you'll have your answer(s). 부달

    ReplyDelete
  7. Are you seeking information on a Home Business, or possibly you've read a whole lot and now you are trying to sort out what might be the BEST home based business? This is a long article, but stick with it all the way and we're very confident you'll have your answer(s). 야맵

    ReplyDelete