6 Replies Latest reply: Sep 10, 2010 6:18 AM by Noribeth Bajenting RSS

Overwrite existing query

François Gyöngyösi
Currently Being Moderated



We would like to be able to handle modification of BW query directly in Production. However, we would like to control this process. We imagined the following process:


- Copy the query to modify

- Make change to this copy and test it

- If test are successful, overwrite the original query with the modified copy


We would like to keep the original query because it may be embedded in workbook or web template.



However, this process doesn't work because it is not possible to overwrite an existing query. Has anybody imagined another process to handle this situation ?


Many thanks.



  • Re: Overwrite existing query
    vamsi talluri
    Currently Being Moderated



       I guess overwriting of query is not possible only the steps one and two which u do will work....i.e copy the query and change it according to your wish but u cant overwrite this changed one on the original...

    because the changed one may not have all the things in the original... the technical  name can be twice...



    only thing to recover technical name also is to delete the original ...copy the changed one with the technical name of the original now( it allows as original is deleted.)





  • Re: Overwrite existing query
    François Gyöngyösi
    Currently Being Moderated



    Please note that you cannot delete query if it is embedded in an Excel workbook because the workbook contains the internal ID of the query and not its technical name. That's why we want (if possible) to keep the original query.


    What I am looking for are some examples of a formal process for modifying queries directly in production (a process that also handles associated workbooks or/and web templates).





    • Re: Overwrite existing query
      Rahul Bharij
      Currently Being Moderated



      Were you ever able to get a solution for your issue of overwriting a query. I have the same requirement - keep the name of the query same so that none of the workbooks are impacted.



      • Re: Overwrite existing query
        Arun Varadarajan
        Currently Being Moderated

        Changing queries directly in production is usually fine - but then you might run into issues when you try and transport the same query across the landscape...




        might be of help....

        • Re: Overwrite existing query
          magge kris
          Currently Being Moderated

          Hi Arun,


          hi  Arun.


          I have very complex Query in Quality .. Production.


          1) I have created one RKF directly in Quality with out techical name

          2) I have created one formula directly in Quality with out techical name

          3) Hidden some RKF in Query Properties in Quality Directly.



          I know what changes i made . Next when i am transporting Do i face any issue.



          Since it is very very complex Query, i do not want to take a chance.



          1) shall i delete the RKF & Formula, unhide the RKF  that i created in Quality

          and recreate it in Dev and transport it to Quality then to Production.


          2) Or Can i create the same RKF ,Formula , hide the RKF which is presently

          hidden in Quality and transport it with out deleting the above in Quality.


          ( assuming that ,i will overwrite .. I saw your blog , it does not overwrite)



          What is the best way to make the next transport successful.





          Advance thanks


  • Re: Overwrite existing query
    Noribeth Bajenting
    Currently Being Moderated



    is the original query available in your test system and is it exactly the same as the one in production?

    if yes, then i guess you have kept the original copy in place (only that it is in the test system and when your query in production

    screws up, you need to retransport the query from the test system).


    You may also want to copy the query to another query name and edit the original copy. that way you can revert back to the original design based on the copied query. just make sure you properly document the changes you will be making.


    i don't think the changes you will be doing will be that complicated if you only touch the query designer and if you are only changing one query.