Categories
- All Categories
- 101 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Need help in building the Excel based BI Publisher Report

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
Answers
-
Hi,
Are you able to build the query first? You can then build the xml data and a report using one of the below techniques. Click the below link or google for "xml publisher report using query".
Hope this helps.
0 -
@ItsSaurabh - Were you able to achieve the output?
0 -
@User_LS5AK : Nope, I am still waiting for the direction.
0