Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Merge 2 column heading

72
Views
4
Comments
Moo+
Moo+ Rank 1 - Community Starter
edited Aug 13, 2024 5:12PM in Oracle Analytics Cloud and Server

Hi,

please suggest to me about rtf template with matrix report.

I have data this below i want to merge heading when duplicate column. how can i do?

row-1 Cat1 Cat1 Cat2 Cat2 Cat2

row-2 item-a item-b item-c item-d item-e

row-3 (qty) 1 2 1 1 1

I use this command on bi publisher property => <?for-each-group@column:G1;ITEM?>

help me please.


Regards,

Moo

Comments

  • EdStevens
    EdStevens Rank 1 - Community Starter

    Please show a minimal reproducible test case. Post (as text, not screen shots) the DDL to create your tables, INSERT statements to create sample, representative data. Show the output you expect from that data, and a description of the logic by which that output is derived.

  • mathguy
    mathguy Rank 1 - Community Starter

    Wrong forum (space, whatever they call it).

    This is the SQL and PL/SQL forum. It's for questions about programming in these languages.

    Instead, you are using BI Publisher, and its specialized scripting language. The command you showed us (even if it doesn't work for your problem) has absolutely noting to do with SQL or PL/SQL.

    Find the BI Publisher forum (still on this same site - just different forum) and ask your question there. With some luck, one of the moderators will see this and they will move your question to that forum instead.

  • PhHein
    PhHein Rank 2 - Community Beginner

    Moved from SQL/PLSQL

  • Gianni Ceresa
    Gianni Ceresa Mod

    @Moo+ ,

    Isn't this the same as https://community.oracle.com/tech/apps-infra/discussion/4492284/how-can-i-merge-column-head-xml-publisher-rtf#latest ?

    It looks like you posted this one first in a database category (SQL/PLSQL), while the first one is in the OBIA category.

    If it's a duplicate of your other thread, please close one and keep only one of the 2 open (double posting is against the forum rules).

    As far as I know there isn't a BI Publisher category here (there is one in the MOSC forum, so if you have a valid CIS, you could consider ask this in https://community.oracle.com/mosc/categories/bi_publisher instead.