Expand the hierarchy column automatically when delivery reports in Oracle Business Intelligence 12.2

3281755

Hi Experts,

I got a requirement to display the hierarchy columns in expanding by default in the Oracle Business Intelligence 12.2.1.4.0 version.

Is there any configuration steps need to change, can you someone help me to achieve this requirement.

Thanks in advance.

[Deleted User]

"when delivery reports"? Not sure what you mean with that.

BI Publisher *report* delivery?

OBI *analysis* delivery?

Delivered as what? An HTML? A PDF? Embedded? Attachment?

Please read this:

3281755

Hi Christain,

After running the OBIEE report, the Hierarchy column will display in a single row even if it has multiple levels of values at present. the expected result is to display the hierarchy column in expanded at least one level of values. please find the attached example for the same.

Thanks and Regards,

Arun

[Deleted User]

Arun,

That is an "analysis". Not a report. A report is a BI Publisher object. Different technology.

And you have not answered the quesion of how exactly this os being delivered.

If you do not provide aminimum amount of pertinent information it's hard to help you.

3281755

HI Christain,

My Apologies.

I have one analysis which will have the Hierarchy column (Agent name). usually, the analysis gives the result in a single row of data even if it has multiple levels of data by default like below and after click on expand then it will display the multiple levels of data in the hierarchy column.

My requirement is to display the Hierarchy column data in expanding multiple levels (at least one level) by default like below.

Thanks and Regards,

Arun.