Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 238 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Correct syntax for and when used within a group
Summary
Correct syntax for <?split-column-header: ?> and <?split-column-data: ?> when used within a group
Content
Hello all,
Could you, please, advise on correct syntax for <?split-column-header: ?> and <?split-column-data: ?> when used within a group?
Consider the following XML data sample:
<G_1>
<Service>S1</Service>
<Market>AT</Market>
<Volume>1000</Volume>
</G_1>
<G_1>
<Service>S1</Service>
<Market>BE</Market>
<Volume>2000</Volume>
</G_1>
<G_1>
<Service>S1</Service>
<Market>FR</Market>
<Volume>3000</Volume>
</G_1>
<G_1>
<Service>S2</Service>
<Market>AT</Market>
<Volume>500</Volume>
</G_1>
<G_1>
<Service>S2</Service>
<Market>BE</Market>
<Volume>100</Volume>
</G_1>
...
I define a group as <?for-each-group:G_1;./Service?> ...<?end for-each-group?>
Within this group I need to build a table where each Market is rendered as a column. I have no problem with creating such a table outside the scope of the group, however, solutions like
<?split-column-header:current-group()?>
or
<?split-column-header://G_1[./Service=current-group()/Service]?>
are not workable.
Any ideas?