All Column Values in BI Publisher - Page 2 — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

All Column Values in BI Publisher

Received Response
363
Views
15
Comments
2»

Answers

  • Deepthi Suravaram
    Deepthi Suravaram Rank 5 - Community Champion

    Hi Sherry,

    where model

    in (:P_MODEL) or '*)nqgtac(*' IN (:P_MODEL || '*)nqgtac(*')

    I have put the following condition, but still doesn't work. I am getting the same error.

  • Ajaysmyle
    Ajaysmyle Rank 1 - Community Starter

    Any luck on this issue. I am facing the same issue when 'All column values' are passed from Dashboard prompt to BI Publisher report.

    Appreciate any inputs.

    Regards,

    SG

  • Youssef_B_82
    Youssef_B_82 Rank 5 - Community Champion

    Hi,

    Maybe you have null values being passed? how's your query handling the nulls?

    Try something like:

    ...

    WHERE LEAST(:P_MODEL) is null or '*)nqgtac(*' IN ((:P_MODEL || '*)nqgtac(*'))

    ...

    Regards,

    Youssef

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    You have to handle data model query to accept "all values"  and "multiple values"  ,

    Also what is your source for bip data model ?

  • Yogen
    Yogen Rank 5 - Community Champion

    'All' is equivalent to '*' for BI Publisher parameters.