Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

OAC - Adding the title to the sections

Needs Votes
85
Views
1
Comments
Anis Benromdhane
Anis Benromdhane Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server Idea Lab

Hell ,

I have an analysis where I have a title and then I have a table that I have put in a section, and the table is repeated several times in function of a variable that I have put in the section,

I wish to add the analysis title in the section as well, so each time I have a table I have its title.

On the screenshot you can see that I have putten the pivot table on the section but I could not add the title as well.

Capture d'écran 2023-07-07 161559.png

I suggest Oracle adds the option of adding titles and other view forms in the sections beside the tables.

Regards.

1
Up
1 votes

Needs Votes · Last Updated

Comments

  • Marcelo Finkielsztein
    Marcelo Finkielsztein Rank 6 - Analytics Lead

    @Anis Benromdhane

    Hello Anis,

    Until Oracle implements your request, consider this work around...

    1. on the "Criteria" tab, add a new column to the analysis. Any "string" column, it does not matter, we are going to change it soon.
    2. Edit the Formula for the column
    3. click the "custom headings" checkbox
    4. Change the Column Heading for this newly added column; put in there the heading text taht you want to see on the section.
    5. change the [Formula] for the column, set the formula as '' ; just (quote)(quote) an empty string.
    6. Switch from Citeria to Results. Now you have an extra column on the analysis.
    7. Edit the Pivot Table.
    8. Drag the new column from its current location to the "Sections" area. Expected Result: Now you see the heading showing on top of the Pivot table. :)
    9. If needed, click the gear icon on this "fake heading" column and change its properties to set Bold, Font SIze, Color, etc.

    Makes sense? hope this helps you.

    : ) Marcelo Finkielsztein