Excel Template Not generating Out properly for Nested Table Joins

Question

Table is joined in Data model as given below :

Parent Table HRC_TXN_HEADER is joined to other tables.

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

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

Please suggest some solutions

Regards,

Simi

Simi_SS · Answer

Hi @Mandeep,

This section "Check section 6.4.4 " displays the department separately and not with the other details.

PFA the catalog files.

ICP Approval Details_1.xls

REIMBURSEMENT_DM (7).xml

Regards,

Simi

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/27242/excel-template-not-generating-out-properly-for-nested-table-joins

Hi Simi,

Is this a BIP report? And are you using excel template?

If possible, please upload the catalog files to review?

Check section 6.4.4 of below document:

6 Creating Excel Templates

Thanks,

Mandeep.