Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Big edit

Received Response
11
Views
3
Comments
Teresa Modesta
Teresa Modesta Rank 5 - Community Champion

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 Rank 8 - Analytics Strategist

    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!

  • Teresa Modesta
    Teresa Modesta Rank 5 - Community Champion

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

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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.