Oracle Analytics Cloud and Server

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

Correct syntax for and when used within a group

Question
21
Views
0
Comments

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?