nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Exporting Hierarchies Visualizations

Cade Johnston

We have a problem when exporting visualizations that are utilizing hierarchy columns when it is uploaded into Excel it just shows the top level of data when we would like the detailed levels to be included in the csv. Does anyone have similar issues or a fix to this problem?

Find more posts tagged with

Analysis and Data Visualization

FDI

Fusion AI Data Platform

Accepted answers

All comments

Raghavendra Raghunath-Oracle

Hi Cade, while exporting use the option excel instead of data, fyi

Raghu

Screenshot 2023-11-29 at 11.03.18 AM.png

Cade Johnston

Thanks @Raghavendra Raghunath-Oracle! It seems I don't have the ability to export as an excel format, is this a feature we have to enable???

Krithika Raghavan-Oracle

@Cade Johnston Could you send a screenshot of available options?

Cade Johnston

These are the only options for me. Thanks for looking into it @Krithika Raghavan-Oracle!

Madasamy -Oracle

Couple of inputs on DV Workbook export excel

Check if the export excel option is available in the Edit mode of your workbook
In the "Present" mode, the excel export option will be available after you select a visualization by clicking on it. So try selecting one of the visuals on your "Present" Mode and choose the Export option, to see if the excel option is available.

Krithika Raghavan-Oracle

@Cade Johnston You probably have not yet enabled the preview feature.

Could you please ensure "Preview Excel Export" is enabled from your system Settings.

Krithika Raghavan-Oracle

Here is a screenshot

Cade Johnston

Thank you @Krithika Raghavan-Oracle! I will enable this right away!

Krithika Raghavan-Oracle

@Cade Johnston Let me know if you are then able to see the option.