Daniel Xiao

Collaborate is where the Oracle user community comes together to share and learn through 1200+ education sessions, panels, and networking events. This year, Collaborate 19, is being held April 7-11 in San Antonio, TX. Oracle’s enterprise performance management (EPM) Java application program interfaces (API) can be very powerful in exacting and loading Oracle’s Hyperion financial […]

Earlier, I wrote a blog post about the presentation (Complex Data Security Made Easy in Oracle BI) that I delivered at Kscope17. I used a typical use case from a marketing organization as to how complex data security like team and position based hierarchies can be implemented via four different approaches in Oracle BI. When […]

opmnctl is no longer available in OBIEE 12c. Instead, it provides you with a better way to start and stop BI servers and components. If you have a default OBIEE 12c install on Windows, you will find three new script files under <mw-home>/user_projects/domains/bi/bitools/bin: start.cmd for starting all or a list of BI servers and components stop.cmd for […]

Perficient is exhibiting and presenting this week at KScope17 in San Antonio, TX.  I delivered my presentation yesterday on modeling complex data security in Oracle BI.  Here is the abstract for my presentation: Learn how to build a position based security model to enable a position can view all it’s direct reports’ marketing/sales performance; learn […]

It seems a good time to talk about security as the WannaCry ransomware attack outbreak two weeks ago is spreading like a wildfire and leaving the world helpless with the kidnapped documents, images, and videos. Although the Data Security I am going to speak to is different from the File Security, there is one thing […]

The need exists for the ability to read and extract data from BICS, especially when the ETL strategy involves a Staging approach, as written about in Best Practice to ETL with Data Sync (BICS). But Data Sync does not support the direct data read from BICS. The built-in Oracle (BICS) connection in Data Sync only supports a data write to BICS. […]

Common dimensions are required for cross-facts reporting, and are oftentimes referred to as conformed dimensions. A dimension can be conformed through its data consolidation, or its logical data model. Data consolidation is useful for conforming the dimension data which has the same hierarchy level, and happens in MDM and ETL processes. A logical dimension is very useful for conforming the […]

Now that we have three different approaches to extract Oracle ERP Cloud data from OTBI, there comes the question – what’s the best practice, or which one should you recommend? Before answering the question, let’s take a look at the feature list of each approach so we can understand what they are best at. Feature List […]

Custom SQLs work differently than logical and physical SQLs.  Instead of going through the OBTI subject areas and the Fusion PVOs in the RPD physical layer, custom SQLs are used to create custom data models in BI Publisher to extract ERP Cloud data directly from the Fusion database tables.  The built-in Data Sync Oracle BI Connector does not support […]

Physical SQLs are essentially the same as Logical SQLs. Behind the scenes, Logical SQLs are converted back to physical SQLs by BI server using the OTBI Fusion public view objects (PVOs) defined in the RPD physical layer. Physical SQLs leverage the same Data Sync built-in Oracle BI Connector used by logical SQLs for extracting ERP Cloud data from OTBI. The process […]

This approach is officially recommended by Oracle. Data Sync comes with a built-in Oracle BI Content connector, which can be used to extract ERP Cloud data from OTBI. The connector supports three data extraction modes. SQL – used to extract data from logical SQL queries Report – used to extract data from BI analyses reports Subject Area.Table – used  for extracting […]

If you ever had a requirement or thought of creating an analysis report in BICS to display report columns dynamically, but later had to give it up due to the complexity, you might find this blog post is what you’ve been waiting for. I am going to show you how easily such a report can be created […]