on 09-10-2009 8:03 PM
Hi All,
We have a scenario where we are developing and transporting a query from sandbox to production. If the same query with the same techincal name is developed and transported from another system to production will the query be duplicated.
Thanks in Advance.
If you have transported the query and you now have two queries with the same tecnical name run this program ANALYZE_RSZ_TABLES to fix the problem. Leaving both queries there will be problematic.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The query keys aren't the technical name, it is an internally assigned GUID. If you take a look at the RSZELTDIR table, the key is ELTID (Query Element ID) which is this internally assigned GUID. The MAPNAME column on this table is where the technical name of the query is stored.
So, if you create two queries with the same technical name, you can transport them both through your landscape and they will both coexist. If you're using the SAP BW Portal, updates to the published query will be affected. If you modify a query that has the same technical name, but isn't the query that was published (different Query Element ID), the query in the portal will not change.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes they will be duplicated as they have internally different id in system level as Dennis told.
If you want to have only the queries created and moved from dev-> quality -> production
Open the query which you dont want and copy them as another query and delete the existing thing which is duplicated so that it will help you in avoiding confiusion.
Thanks,
Arun
The transport will not happen. It will give error while transportting to P.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.