You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

BIP report parameter is not working as expected

in Reporting & Analytics for Fusion Service 1 comment

Summary:

Hi All,

For BIP report parameters, I have used the below part and it is not working as expected. When a period, CO, and Account parameter is given that time it is giving the expected data. But when I just give period and CO. One line is missing. Any help would be appreciated. Thanks

       AND (  (gjh.period_name) IN ( :P_Period)

           OR 'ALL' IN ( :P_Period || 'ALL'))

        AND ((gcc.segment1) IN ( :P_CO) OR 'ALL' IN ( :P_CO || 'ALL'))

        AND ((gcc.segment2) IN ( :P_PL) OR 'ALL' IN ( :P_PL || 'ALL'))

        AND ((gcc.segment3) IN ( :P_LB) OR 'ALL' IN ( :P_LB || 'ALL'))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!