Skip to main content

Posts

Featured post

Semantic Modeler Series: Setting up Git repository

I will assume that I have already created a semantic model which has been deployed in my OAC environment. My intention is to share this semantic model with other developers who are working on this same model in the same time. In OBIEE this was only possible by setting up Multi-User Development Environment (MUDE). My experience with MUDE is that it wasn't perfect, often, if not careful, it was leading to problems with locking, merging, deployments. With Oracle Analytics and in particular with Semantic Modeler introduction, this has changed. When working with Semantic Modeler, Oracle Analytics gives developers two options how to setup (much stronger) collaborative environment by: giving permissions to make updates to the model to other users - Semantic Modeler is, in a way, by default multi-user development environment, and using Git , which provides proper multi-user development environment. In this case, access rights are given through Git directly. Integrating Semantic
Recent posts

Semantic Modeler Series: Introduction

Oracle BI Administration Tool Metadata management used to be one of the key strengths of Oracle Business Intelligence. Using BI Administration Tool developers were able to design and implement enterprise data models that were sitting on top of data warehouse data schemas. OBIEE developer designs and develops a metadata model, a repository, using BI Administration Tool, which results in a RPD file. This binary file is then deployed on BI Server. BI Server is a component of Oracle Business Intelligence architecture and is responsible for processing user requests and data queries against underlying data sources. BI Server uses metadata information from repository to perform the following two tasks: use logical SQL query and tranform it into corresponding query (ie. SQL, MDX), depending on the underlying data source (ie. Oracle Database, Microsoft SQL Server, Oracle Essbase, ...) transform and combine physical datasets retrieved and perform required calculations. Typical metadat

Embedding Oracle Analytics Data Visualization in APEX application

In one of my recent projects, the customer had a requirement to integrate visualizations from Oracle Analytics into Oracle APEX application that is running within Oracle Cloud Infrastructure. It is not my prime focus, the integrations, so I checked Oracle's documentation first. There is no "cook book" in there, so I looked it up for some good resources on the internet. Actually, you can find quite a lot of content out there, from blog posts, articles, even videos, however most of these are a bit old (not exactly obsolete) as both products have developed rapidly over the last couple of years. But still, I found some really good ones that I was able to help myself with. For example Mike Durran's blog is usually the ultimate go-to source for these kind of things, and you can find quite a lot of content on this subject there. For example, you definitely want to check his article A Guide to Embedding Oracle Analytics into Oracle APEX . In this blog post, I will try t