4 Replies Latest reply on Feb 4, 2019 6:49 AM by 3281755

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

3281755 Feb 1, 2019 3:50 PM

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.

1. Re: Expand the hierarchy column automatically when delivery reports in Oracle Business Intelligence 12.2.1.4.0

Christian Berg Feb 1, 2019 7:32 PM (in response to 3281755)

"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: How to Ask Questions in Developer Community Spaces
Like Show 0 Likes(0)

Actions
2. Re: Expand the hierarchy column automatically when delivery reports in Oracle Business Intelligence 12.2.1.4.0

3281755 Feb 4, 2019 5:23 AM (in response to Christian Berg)

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
Like Show 0 Likes(0)

Actions
3. Re: Expand the hierarchy column automatically when delivery reports in Oracle Business Intelligence 12.2.1.4.0

Christian Berg Feb 4, 2019 5:40 AM (in response to 3281755)

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.
Like Show 0 Likes(0)

Actions
4. Re: Expand the hierarchy column automatically when delivery reports in Oracle Business Intelligence 12.2.1.4.0

3281755 Feb 4, 2019 6:49 AM (in response to Christian Berg)

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.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.