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
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!

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • 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!

  • Rank 5 - Community Champion

    Wow, 5 minute job instead of 5 x 20 x 10 minute job, thank you 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.

Welcome!

It looks like you're new here. Sign in or register to get started.