Use Essbase as data source, when displaying both member and alias columns can we have alias columns as hierarchy drill down instead of member columns in OBIEE 12c.
No, this functionality does not exist.
This would be one of my pet niggles.
The flat lists that provide no clue as to level in the hierarchy make Essbase in OBIEE not a great option, so much so that I once resorted to full data and metadata extracts / import to Oracle DB to provide the kind of functionality you would hope OBIEE would be giving, given that both OBIEE and Essbase are core Oracle BI offerings.
My rdbms version was faster to run, easy to write reports against and considerably more flexible as I also flagged leaf level members, as well as bringing parent / child through to the subject area.
Oracle - wake up and smell the java - you have a lot of clients who want this!
Only way to get this is to tell it to the Product Managers. Or have a client important enough and complain long enough to their account manager.
And how do you get the 'ears' of the product managers?
I have worked for a number of blue chips but I have yet to see the client who actually influences Oracle, do they live next to Larry in the bay?
By talking to them when you meet them and send them repeated emails
Do you know if connections that do not use TLS will be affected by the September 2026 update? Regards, Alison.
We have a requirement to embed OAC reports within the OCC Marketplace for both Organization and Non-Organization users. Currently, Organization users can access the reports through Oracle Analytics Cloud. However, the requirement is to make these reports available as embedded content within OCC Marketplace. When a user…
Hi Team, We would like to raise an enhancement request for the SSO/SAML configuration guidance for OAS 2026. We have already raised multiple SRs regarding OAS 2026 SSO configuration. However, we are facing difficulties getting the required guidance, as the available documentation does not clearly cover the OAS 2026 SSO…
We are planning to archive the Contract and Lease data currently sourced from the External Source as Contract and Lease accounting functions are being migrated to Oracle's CLM and Lease Accounting modules. At this stage, only active and partially closed records are being converted into Oracle and the remaining historical…
The difference column is a calculation, and I would like to average that row.
