Oracle Analytics Cloud and Server

Big edit

Received Response
15
Views
3
Comments

Hi,

is there anyway to edit a massive union report where I am changing the same formula on numerous columns on a union report that is 20 unions and 10 columns for each use of the function, without it being a totally manual effort, 1 at a slow time??

thanks!

Answers

  • Robert Angel
    Robert Angel ✭✭✭✭✭

    Hi,

    if you go to the advanced tab the XML represents the entire report content.

    You can do a copy and replace in your notepad of choice and then paste it back, the only gotcha to watch out for is line wrapping in the wrong place which can make the XML invalid, but I have done this previously for a similar problem and provided you get the syntax totally correct and do not introduce any other corruptions in edit then it will work.

    Back up what you have first and good luck!

  • Wow, 5 minute job instead of 5 x 20 x 10 minute job, thank you Robert Angel

  • Robert Angel
    Robert Angel ✭✭✭✭✭

    For future reference you can also create a single union (presuming they are all variations on a theme) and then alter the sql directly to make the creation of the mass union less labour intensive, note you need to do this BEFORE applying any formatting because the minute you apply the sql you will destroy any work you have done on the formatting.