Replace Function in Webi?

building reports webintelligence
1

I have two queries hitting two different time points. I have many many custom formulas in this file. What I want to do is once my report is generated, I want to find a way to “Find and Replace” within my report. I want to replace my formulas in report two like so:

Example:
[Query1].[Object 1] xxxxxx
REPLACED with:
[Query2].[Object 1] xxxxxx

Any way to do that or do I have to customize each formula hand by hand? I did a forum search, and it looks like maybe the answer is no, but geewiz this would save me hours and hours of time…

Thanks,

2

No find/replace function like that within the app.

Is this a one time update or do you need to be able to switch between Query 1 and 2 all the time?

Can you do a union query to join the data sets instead of having separate queries?

1 Like