Oracle Analytics Cloud and Server

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

Strange report behavior... multiple rows without for each or group statements??

Received Response
62
Views
5
Comments

Summary

Strange report behavior... multiple rows without for each or group statements??

Content

Hi All,

I have 1 report where I have a table with 1 field and NO GROUPS. When I load the sample data and run the report I get just 1 row of results.

table2.PNG

I get 1 row of results:
image

I have a second report file with similar data, 1 field and no groups. However, when I load this sample data and run the report I get all of the results as expected.

table1.PNG

here are multiple rows:
image

I don't understand why my second report is able to generate a full list of results without any groups or for each statements? Now, on the second report, I do get this prompt about xslt 2.0 when I first open the report. Would this make a difference? How can I compare the underlying code between these BIP reports??

xsl2.PNG

Also, both of these reports are pre-existing that I am just editing -  well, trying to edit. I need to understand why the first one is behaving differently from the second. I'm still very new to BIP so the answer here may be obvious to you.

Thanks for your help!

John

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 6 - Analytics Lead

    Thanks. I do understand that we need to use for each statements... My confusion is that the 1 report seems to be displaying many rows of data without these for each statements.

    I've attached an rtf example with a pdf of the output to the original post. The sample data has 5 rows.  I expect to see only 1 row because there are no for each statements... but instead all of the data returns. why?

  • Rank 7 - Analytics Coach

    You have to use  <?for-each:root element?> in order to display each record one by one ,and <?for-each-group:root element?> is different and you are giving condition to group data based on specific element (like group by in sql).

    if possible upload xml and rtf files. Thanks

    Follow this doc Oracle BI Publisher Consulting: XML Basic You Need to Know

  • Rank 7 - Analytics Coach

    It can be corrupted rtf. It happens sometime. Request you to export your rtf to xsl-fo then search for for-each if its not present it means we are not looping it  through rtf and we can conclude that rtf it corrupted. In this can you can copy the content to new rtf and check. or if its not very big report then can create from scratch

  • Rank 6 - Analytics Lead

    Thanks Guys, This is what we expected but wanted to confirm with you all.  Thanks for all of your help.

  • Rank 7 - Analytics Coach

    something went wrong with your file(might be corrupted), please recreate it and test. Thanks

    In order to test this just remove whatever in template and create same without for-each , it will display only one record.

Welcome!

It looks like you're new here. Sign in or register to get started.