Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

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

Excel Template Not generating Out properly for Nested Table Joins

Received Response
22
Views
2
Comments
Simi_SS
Simi_SS Rank 1 - Community Starter
in Oracle Analytics Publisher

Table is joined in Data model as given below :

Parent Table HRC_TXN_HEADER is joined to other tables.

image.png

The full row is repeated under Parent group: Txnh and the highlighted 2 columns : Base Name and Amount, repeated for group : Xmlcache Detals

image.png

But receiving output as shown below. But we need the columns from A to M also repeat, instead of showing blank.

image.png

Please suggest some solutions

Regards,

Simi

Answers