Oracle Analytics and AI

Anis Benromdhane

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.

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

Regards.

Marcelo Finkielsztein

@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