How can I configure "All" prompts in BI Publisher
Summary:
Content (please ensure you mask any confidential information):
I have a report with some parameters, I would like them to come with the default value "All" and, if necessary, this search to be refined.
My SQL code is as follows for the parameters:
-- PARAMETROS
AND (:P_LIVRO IS NULL OR GL.NAME IN :P_LIVRO)
AND (:P_CONTA IS NULL OR GCC.SEGMENT6 IN :P_CONTA)
AND (:P_FILIAL IS NULL OR GCC.SEGMENT2 IN :P_FILIAL)
AND (:P_DIVISAO IS NULL OR GCC.SEGMENT3 IN :P_DIVISAO)
AND (:P_NEGOCIO IS NULL OR GCC.SEGMENT4 IN :P_NEGOCIO)
0