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 AI and Analytics

Child Item

Can we have a OTBI analysis based on a BI Publisher Report's output?

User_MC37Q

Summary

Can we have a OTBI analysis based on a BI Publisher Report's output?

Content

Can we have a OTBI analysis based on a BI Publisher Report's output?

Regards,
Rashmi

Find more posts tagged with

Reporting

SQL

Answers

OTBI

Report Delivery

Comments

Mihaela M

No. By product design, OTBI/OBIEE uses RPD metadata to build analyses. BIP is the product which is integrated with OBIEE catalog, hence you are able to build BIP reports based on OBIEE analyses and not the other way around.

Julian Challenger-Oracle

Moved to General OBIEE forum.

AshishERPCloud

I wonder why you wanna do that as you can directly build a report in BI using OTBI subject areas ( choose Oracle BI EE as data source)

Check if below link helps:

https://apps2fusion.com/oracle-fusion-online-training/fusion-applications/fusion-payroll/2370-bi-publisher-parameterized-report-using-oracle-bi-ee

Kind Regards

Ashish

User_MC37Q

Thank you all for your replies but the thing is i have a requirement where one dashboard should be created consisting of various analyses and the data for the analyses will flow from BIP Detailed Report. For example if there are some scores in BIP Detailed Report then i want to create one analysis having ranking on the basis of that score. Similarly multiple analyses are to be created.

It would be very helpful you guys know a way out.

Thanks

AshishERPCloud

Can you share your BIP Reports and the expected OTBI output.

Kind Regards

Ashish

Mihaela M

Hi Rashmi,

have you tried to model same output via OTBI and you are unable to do so? ( I mean same output as you have in BIP Detailed report you are mentioning). Please share the query used and we might be able to help you with corresponding subject area in OTI/analysis.

Also, you can embed BIP reports within OTBI dashboard, so not sure on what is the expected output of above scenario.

Sricharan Monigari

Hi Rashmi,

You can use the Direct Database SQL option in the analytics to get the BI Query o/p in analytics.

Check https://biapplications.wordpress.com/tag/direct-database-query/

Thanks,

Sricharan

Mihaela M

This functionality is not supported in SaaS environments and does not comply with above request of embedding results into a dashboard.

User_MC37Q

Hi Guys

The requirement is based on goal management and performance management.

I have to create two analyses: one detailed analysis (Where score is to be calculated based on some calculation logic on budget and actual targets)

Then I have to create another analysis based on scores of the detailed report and I have to rank each employee according to their total score %age.

This is how it goes.

Thanks

New Announcements

Upcoming Events

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
Analytics - Fusion Data Intelligence: CEAL Guidance Office Hours | Americas and Europe
Agenda Presentation: Optimize FDI Workbook Performance Learn best practices and optimization strategies for building performant workbooks in Oracle FDI. We’ll share practical tips and lessons learned to help report authors avoid common pitfalls and design workbooks with performance in mind from the start. As a special…
AI Data Platform - Deploying Agents and Agent Hub in AI Data Platform
Learn how to deploy an AI Data Platform agent, register it to the AI Registry, and introduce it to business users through Agent Hub. This session covers how to prepare an agent for deployment, configure endpoint access and authentication, invoke a deployed agent, and monitor it after deployment. The session also introduces…