Oracle Analytics Publisher

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

Missing data in Bursting BIP report

Received Response
12
Views
2
Comments

I have 2 data models which are independent of eachother

1st data model has details

2nd data model has summary that shows a count of records

in bursting, my 1st data model table shows data as expected but my 2nd data model table shows column headers with no data.

However, when i run the report from back end it shows both tables with data

also, when i republish from scheduled process for bursting it again shows correct data.

But when i download the output file it shows missing data for summary table.

and output received over mail also shows missing data for summary table.

Does anyone know what might be the issue?

Thanks,

Ninad

Answers

  • Ninad Joshi
    Ninad Joshi Rank 1 - Community Starter

    Please check the word file for screenshots for further clarification

    burst.docx
  • Kevin M-Oracle
    Kevin M-Oracle Rank 6 - Analytics Lead

    You need to organize the data so that there is a shared level for each group.
    Then split-by and deliver-by elements in G_1.

    Ex. DATA_DS

    G_1 (parent)
    G_2
    G_3
    G_1 is your new group and G_2 and G_3 are the original groups.

    Rgds,

    Kevin