Oracle Business Intelligence Applications

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

Need help in building the Excel based BI Publisher Report

Received Response
33
Views
3
Comments

Hi,

I am trying to build an excel based BI Publisher report in the below format

SKU and Description Comes from Table T1

In this table for every SKU there will be 1 record and Item Id is the Primary Key.

Between Table 1 and Table 2 it is 1:M relationship. Table 2 Store the Code Information and Item Id is the Foreign Key in Table 2.

Similarly between Table 1 and Table 3 it is 1:M relationship. Table 3 stores the Color Information and Item Id is the Foreign Key in Table 3.

I am not sure how to use the Grouping logic in the Template. My Data model has separate Queries on Table 1 , Table 2 and Table 3

Table 1 Query is joined to Table 2 query using Item Id link

Table 1 Query is joined to Table 3 query using Item Id link

Please guide me how the grouping has to be done to get the output in the desired format. Also, if the query structure is incorrect, please advise how to correct that.


Thanks

Tagged:

Answers