Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

3281755Feb 1 2019 — edited Feb 4 2019

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.

Comments

"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

sample.jpg

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.

pastedImage_0.png

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

pastedImage_1.png

Thanks and Regards,

Arun.

1 - 4