Hello.
We are using Webi 4.3. I have two questions concerning the "page browser".
* Is it possible to pin the page browser in reading mode (as it is in design mode, pop-up is not fine)?
* Is it possible to show the max number of pages in pag...
Hello,
see the (simplified) sql query below:
with t1 as (
select create_month, cust_id
, max(case when age <= 50 then 1 else 2 end) as age_group
, sum(amount) cust_amt
from bla.revenue
where create_date between '2022-01-01' and '2022-...
Hello all,
we are using BO/Webi 4.3:
I am building a query based on a universe. Query filter contains a subquery, the subquery has where clause on a column with an optional parameter/prompt.
Is it possibble to achive, that the subquery disappea...
Thank you Amit.First point: What do you mean by " Either you can set the print layout mode set in the design mode and save it.. so no need to change it all the time."Second: As workaround I set the =numberofpages() in the report header, it works well...
Hello Noel,thanks for the example.However, I would like to make sure that the subquery is not built into the main query at all and executed if the parameter is not populated.In my use case, a value should be delivered with the input of the optional p...
