Transport Requirement

Hi all, I'm new to Transports and need some help. at my client, the guy who worked before me, tried to transport some stuff from Dev to Q but he screwed up. Now I've been given that task, but dont know where to start. I mean how to check which objects i need to transport? Difference between first and subsequent transports of objects and stuff....please someone guide me and I will reward heavily too. My job's future depends on this task....

Farhan

SAP Managed Tags:
BW (SAP Business Warehouse)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hi Farhan,

Firstly what "stuff" was the other guy trying to transport..Cubes, queries ...? And how many transports are we talking about?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

the main thing is a multicube. what exactly he screwed up, even i didnt understand but its my job to find that out. Another thing is that when i see data flow for the multicube in Q, I dont see the complete flow for most of the cubes. BUT the data is there in those cubes...dont understand why? Cant figure out which objects really wo work on...if u can guide me, i could play around and try to solve. thanks for the help.

Farhan

To be on the safe side of things I would suggest that you first look at the request to see what objects it contained, and check those objects in the Q system to see if they are present/active.

You can also see what failed and why from the transport logs. Were the base cubes of the multiprovider already in Q, and you wanted to transport the new multiprovider?

Hi Farhan,

you can try to locate the transport and analyse the logs in transaction SE10 if you know the USERID of the guy. Or try to find the last transport of the Multiprovider in transaction SE03 (Object type MPRO).

Hope that helped,

Michael

How do u look at the request?

Also, when i'm trying to look at the log, I see nothing.

In SE10. Put in the user ID of the other person and you should see a list of requests. I suppose the one on the top in the Released section would be the one that you have to resolve. Select it and click on the Transport Logs icone (page with spectacles, next to Truck). Open up the request by clicking on the + next to it, and you will see the objects that were included in it.

Guys, i appreciate for your help..i have to leave office now and will resume work on this one tomorrow morning. Thanks alot again,

Farhan

Thanks for the help, I have a couple of small questions though. First of all, when i see the data flow of a multicube in Q, i dont see the entire data flow. But i see data in the basic cubes. why is that? Second, since my job is to transport a multi-cube, Can i just transport all the relevant objects (including the ones that might already have been transported)??

Hi Farhan,

If you need to transport the multiprovider, and the base cubes are already in Q, then just transport the Multiprovider...no need to transport everything under it if there has been no chnage to these objects.

Hope this helps...

Hi Farhan,

you have to go in RSA1, Transport Connection...

here you can select your multiprovider, select 'only necessary object' as collect mode and move the object on the right side...

That's all !

If you need some more detail about this tool, let me know ! (give me your mail address...)

Bye,

Roberto

ok i understand that the basic cubes are there, but then why dont I see everything under the basic cubes (data flow) in Q ? Dont u think they should be there just like everything looks in Dev ?

Can you see the data flow for the base cubes only (I mean not MultiProvider > data Flow, but Cube > Data Flow)?

when i see the data flow for the multicube, it should show the data flow for all of the basic cubes associated with it. Just like it shows in Dev. MultiCube is made upon 4 cubes. I see data for only one of the cubes. Moreover, when i expand the tree for basic cubes in INFOPROVIDER section, the updates rules signal is white...it should be green. wht do u think is going on

Hi Farhan,

I don't know about the objects that were contained in the failed request, but it seems that certain objects in the data flow (InfoSource and rules) have been removed. Looks like you will have to include all these in a fresh request and transport that. As you can see the entire data flow in Dev, just start carefully collecting all the objects. Sorry to be repeating this, but can you find our what the developer was trying to transport across? Or at least what changes did he/she put in place...

As for my knowledge, he biult the multicube and was trying to transport it into Q along with a query and workbook i think. But in the process, apparantly he messed up somethings and now these objects look incomplete in Q. Does this information help??

Transports are simple, yet tricky at times. If teh data flow to the base cubes in incomplete (confirm this by looking up update rules, Comm Str, Transfer Rules in Q), the you would have to transport this across. It would be wise to break up the process: First complete the base cubes and check data flow with a simple load on each. Then collect the MP, and then finally collect the queries.

Hope this helps...

I see updates rules, comm struct, trans rules for all the basic cubes. BUT out of the 4 b.cubes, only one has updates rules that are green...for others, they appear white even though comm struct and trans rules are there. what do u suggest to do?

For the cube where you see that the UR are not green, may be the cube definition was also chnaged (this is usually what causes the update rules to become inactive). So check the cube definition in D and Q system. If it is same, then you would need to transport just these update rules, else if the cube definition is different, then include the cube in the transport too.

I checked the cube definitions, they are the same. Could i just click on the activate button in Q to activate the update rules? and i still dont understand why everything is not shown in the data flow.

Is your Q system "open" i.e. are you allowed to make changes directly in Q??

well actually i dont think i am allowed...cuz i saw that message while checking the definition of a cube, "non-modifiable" but i havent tried to activate yet...let me try

well no i cant change that also.

well, that is what I was hoping for, else it would mean more complications. So in this case you would need to include the active UR in a transport and send it across.

ok so now along with the multicube, should i do all the object in dataflow BEFORE ? and then all the ones AFTER? or how should i go about it. Again, basically my task is to transport the multicube.

Simply add the multiprovider to your request with necessary objects first. No need to go infor BEFORE. After the MP has been added, recollect with AFTER, and then check to see that the queries have also been added to the request.

i just collected the multi with necassary objects. But i did not see the update rules. Also, should check the TRANSPORT checkbox ? Bhanu, i really appreciate your help; if i can do this it will strengthen my position here

For the objects that you want to Transport ( i guess only the MP in this case) ensure that the check mark is there is in the transport box/column. Then when you click on the Truck (left of Package), select / create a new request. After this go to SE10, and check the request number that you just added to the MP to. When you open it up by clicking the +, it should list the MP.

For update rules, go back to Transport Connection (RSA1), and just select the Update Rules form the Object type and choose the rules that were inactive and need to be transported. Another way to do this is go directly into the Update rules, make a dummy chnage and Save, it will prompt you for a request.

should i click on the truck after doing all the objects AFTER also? or should i just do it with Necassary objects and then make a new request with all the objects after?

Also, If i check all the objects, is it not safe? I mean is it not safe to transport everything??

Bhanu, after I do all the necassary objects, will i be able to see the complete data flow for the MultiCube ?

Ask a Question

Top Q&A Solution Author

User

Count