How to create BI Publisher report with parameters? Passing parameter to BIP report | Oracle SaaS

Поділитися
Вставка
  • Опубліковано 31 жов 2024

КОМЕНТАРІ • 10

  • @irfannajeebparvez1674
    @irfannajeebparvez1674 Рік тому

    very well explained

  • @VibeTribe786
    @VibeTribe786 Рік тому

    In that query i have to view selected data
    And then i want to add Parameter as a filter on the data which i can view.
    What's the query will be like??

    • @BEENUMLEARNING
      @BEENUMLEARNING  Рік тому

      Your query is explained in detail in this video. We hope you have not watched this video completely

    • @VibeTribe786
      @VibeTribe786 Рік тому

      @@BEENUMLEARNING yeah but in this query i must have to enter some parameter value otherwise I can't view data. I want to view selected data before entering parameter value.

    • @BEENUMLEARNING
      @BEENUMLEARNING  Рік тому

      Make your bind parameter as optional using NVL clause or any other clause supported by SQL

  • @sanjayc302
    @sanjayc302 2 роки тому

    Hello brother! Please help me .
    I am using for loop in BIP report, the loop is working but i want comma and end full stop.
    for loop-F Name E
    I got - Sam Ajay Raja
    I want - Sam,Ajay, Raja.
    What should I change in the for loop?

    • @BEENUMLEARNING
      @BEENUMLEARNING  2 роки тому

      Please check below video if this works
      ua-cam.com/video/IYo3oB5qvPE/v-deo.html

  • @BEENUMLEARNING
    @BEENUMLEARNING  2 роки тому

    Have you liked any of our content and thinking about Thanking us? Then you can thank us / donate us with below links
    buymeacoffee: www.buymeacoffee.com/beenumlearning
    PayPal: paypal.me/beenumlearning
    Below are the links for the courses created by us
    Learn Integration in Oracle Integration:
    www.udemy.com/course/learn-integration-in-oracle-integration-oic-from-scratch/?referralCode=A378D1F90CFDA29998D4
    Learn B2B for Oracle Integration:
    www.udemy.com/course/b2b-for-oracle-integration-training-for-beginners/?referralCode=A046790B230F8E7B2648
    Learn Insight in Oracle Integration:
    www.udemy.com/course/insight-in-oracle-integration-oic/?referralCode=6E554C8689FC329746A0

  • @maheedharatmakuru3120
    @maheedharatmakuru3120 2 роки тому

    Very informative video for Integration developers who are willing to add BI Reports to their skillset.........thankyou Beenum........Keep going.
    Recently I encountered a BI report where the columns are missing if no data is available in that column, how to resolve this issue?

    • @BEENUMLEARNING
      @BEENUMLEARNING  2 роки тому +1

      You have to check mark the box "Include Empty Tags for Null Elements" in "XML Output Options" section under Data model properties