i am relatively new to obiee, have a question.
i have four transcation tables in sql server, i need to import those in obiee.
What is the best way i can import/create the equivalent based on facts and dimensions.
thanks
Hi,
I think you need some training, I would get yourself on a course or if this is not an option at least work your way through the Oracle by Example material.
The process is that you edit the repository (rpd) via the admin tool to add the tables in question to the physical layer. You alias said tables to give an indication of what you will use them for when modelling them in the logical layer. In the logical layer you then model the FACT logical table(s) and dimension logical tables(s), renaming columns to business friendly equivalents setting up their hierarchies and setting appropriate content levels between logical tables sources. These are then exposed to the end user via the end user layer ensuring not to expose keys, to follow best practise in folder naming, ordering and presentation.
In short it is no small task and you really need to know what you are doing.
Hope this helps,
Robert.
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…
I am getting a general error when my workbook's scheduled email tries to send out an excel file (See below error). I have tested and successfully send a scheduled email that sends a PDF - so I am wondering if there is an issue with sending excel files currently? It worked fine until this morning:
