Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 52 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 288 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 111 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
OAC Visual Analyzer and PBCS
Summary
OAC, PBCS, DVCS, PBCS
Content
Dear all
The question might have been asked already but I could not find any recent answers.
I'd like to use PBCS (BSO cube) as Data Source in OAC Visual Analyzer (and Data Visualization Desktop - DVD).
I can see that both OAC VA and DVD support Essbase as direct Data Source but I could not find anything regarding PBCS.
As far as I understood it's possible to use OAC Enterprise to create a "bridge" Subject Area on top of PBCS and then use the Subject Area in Visual Analyzer (this link summarises the functionality https://blogs.perficient.com/2017/10/13/how-to-connect-oracle-oac-to-planning-budgeting-cloud/).
Great thanks in advance
Rai
Answers
-
Hi Rai,
you can achieve this by defining a Subject Area (OAC Meatadata repository) pointing to PBCS. The Repository can connect directly to PBCS application. Not just the Essbase cubes but the PBCS app directly. This brief video describes the process to achieve this, hope it can help you : https://youtu.be/p2VdfdgwpL4
One note however : OAC Answers is good at adressing hierarchies queries in multidimensional context of PBCS. Powerful reports can be built there. But DV, in it's current version, will hit the challenge of manually setting all the filters for each hierarchies so to hit the right intersection in the data. The video describes this.
Hope that helps
Philippe
0 -
Thanks for the clarification.
Rai0
