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
