Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 44 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 278 Oracle Analytics and AI News
- 54 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 103 Oracle Analytics and AI Trainings
- 19 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Rowmark visible on export output of BI Publisher Report with excel template
Hi,
I created an excel template based bi publisher report using sql query.
Expected Output
Country | Region | State | County | Item | Sales |
|---|---|---|---|---|---|
Germany | North | W1 | C1 | Laptop | 20 |
|
|
|
| Mouse | 22 |
|
|
|
| Coffee | 100 |
|
|
| C2 | Laptop | 33 |
|
|
|
| Mouse | 31 |
|
|
|
| Coffee | 311 |
|
| W2 | C3 | Laptop | 87 |
|
|
|
| Mouse | 88 |
| South | W3 | C5 | Laptop | 11 |
|
|
|
| Mouse | 12 |
|
|
|
| Coffee | 12 |
|
| W4 | C6 | Laptop | 11 |
|
|
|
| Mouse | 12 |
|
|
|
| Coffee | 12 |
Spain | North | S2 | C9 | Laptop | 20 |
|
|
|
| Mouse | 22 |
|
|
|
| Coffee | 100 |
|
|
|
| Laptop | 33 |
|
| S3 | C12 | Mouse | 31 |
|
|
|
| Coffee | 311 |
|
|
|
| Laptop | 87 |
|
|
|
| Mouse | 88 |
|
| S5 | C14 | Laptop | 11 |
|
|
|
| Mouse | 12 |
|
|
|
| Coffee | 12 |
|
|
|
| Laptop | 11 |
UK | Central | L1 | C43 | Mouse | 12 |
|
|
|
| Coffee | 12 |
Actual output that I get
Country | Region | State | County | Item | Sales | |
|---|---|---|---|---|---|---|
Germany" xdoexcel:rowMark="2 | North" xdoexcel:rowMark="3 | W1" xdoexcel:rowMark="4 | C1" xdoexcel:rowMark="5 | Laptop | 20 | |
|
|
|
| Mouse | 22 | |
|
|
|
| Coffee | 100 | |
|
|
| C2" xdoexcel:rowMark="5 | Laptop | 33 | |
|
|
|
| Mouse | 31 | |
|
|
|
| Coffee | 311 | |
|
| W2" xdoexcel:rowMark="4 | C3" xdoexcel:rowMark="5 | Laptop | 87 | |
|
|
|
| Mouse | 88 | |
| South" xdoexcel:rowMark="3 | W3" xdoexcel:rowMark="4 | C5" xdoexcel:rowMark="5 | Laptop | 11 | |
|
|
|
| Mouse | 12 | |
|
|
|
| Coffee | 12 | |
|
| W4" xdoexcel:rowMark="4 | C6" xdoexcel:rowMark="5 | Laptop | 11 | |
|
|
|
| Mouse | 12 | |
|
|
|
| Coffee | 12 | |
Spain" xdoexcel:rowMark="2 | North" xdoexcel:rowMark="3 | S2" xdoexcel:rowMark="4 | C9" xdoexcel:rowMark="5 | Laptop | 20 | |
|
|
|
| Mouse | 22 | |
|
|
|
| Coffee | 100 | |
|
|
|
| Laptop | 33 | |
|
| S3" xdoexcel:rowMark="4 | C12" xdoexcel:rowMark="5 | Mouse | 31 | |
|
|
|
| Coffee | 311 | |
|
|
|
| Laptop | 87 | |
|
|
|
| Mouse | 88 | |
|
| S5" xdoexcel:rowMark="4 | C14" xdoexcel:rowMark="5 | Laptop | 11 | |
|
|
|
| Mouse | 12 | |
|
|
|
| Coffee | 12 | |
|
|
|
| Laptop | 11 | |
UK" xdoexcel:rowMark="2 | Central" xdoexcel:rowMark="3 | L1" xdoexcel:rowMark="4 | C43" xdoexcel:rowMark="5 | Mouse | 12 | |
|
|
|
| Coffee | 12 |
Loops applied:
For each Country
Subgroup: for each region
Subgroup: for each state
Subgroup: for each county
Subgroup: for each Item
Answers
-
If this tag is visible this can mean the BI Publisher engine failed to parse the template logic correctly, often due to a syntax error in the template's XDO_METADATA sheet or a version mismatch between the desktop template builder and the server.
You would typically need to verify that the grouping defined in the template matches the data model structure exactly and ensure no hidden characters are present in the Rowmark field.0 -
hi Brendan, its a simple grouping which works perfectly on rtf until microsoft word messes the whole table up. Is something wrong with excel oitput in publisher? When will this definite bug be resolved?
0 -
When will this definite bug be resolved?
Did you report it as a bug? You can do that by raising a SR on
Without a SR, you can probably wait a long time…0
