Oracle Fusion #12: Use of Aggregate Functions (Count, Min, Max, Avg, Sum, First, Last) in BIP Report

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

КОМЕНТАРІ • 16

  • @obuleshkumar4866
    @obuleshkumar4866 3 роки тому +1

    HI Naresh,
    These are good videos.
    Data model -Can we connect this to subject area

    • @TechTalkwithNaresh
      @TechTalkwithNaresh  3 роки тому

      @Obulesh kumar we can connect two subject areas. In data model we can write the query with joins for any fusion table so in that we can achive that if there is any join condition.

  • @abhishek-bb6vg
    @abhishek-bb6vg 2 роки тому +1

    Hi Naresh, can we create aggregation function at G_1 group level instead at Global function level? if yes then in which scenario will go for that?

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

      @Abhishek you can create the aggregation function at group G_1 level in the data model query.

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

    Hi Naresh
    Is there any way to count records in etext template

  • @abhishek-bb6vg
    @abhishek-bb6vg 2 роки тому +1

    Hi Naresh, we have print invoice report which is displaying the one invoice multiple times because of the multiple due dates available in AR Payment schedules. My team suggested to use variables inside rtf templated to get rid of this. Any idea how can we use variables to fulfill this requirement

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

      @Abhishek You can use the invoice id as condition to print the unique data. Use condition tag for it.

    • @abhishek-bb6vg
      @abhishek-bb6vg 2 роки тому +1

      @@TechTalkwithNaresh after using condition tag duplicate rows are not coming but for thos duplicate rows still we are getting blank pages in the output. How to remove blank pages

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

      @Abhishek Download the xml. Run the template on local and check why the blank pages are coming.

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

    Hi Naresh
    Is there any way to count records in e text template

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

      @Siva count the records means number of line you are saying?

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

      Yes in EDI template I want each segment count

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

      @Siva you can use This tag to print the number/count.

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

      @@TechTalkwithNaresh Thanks Naresh I need to apply this tag each segment?

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

      @@sivanerusu4416 You can try for both conditions