Skip to main content

Daniel Xiao

Blogs from this Author

Drug Induced Liver Injury

Mastering EPM Java API for BI Reporting at #C19TX

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 […]

OBIEE Complex Data Security in Action

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 […]

OBIEE 12c Tips: Where is the opmnctl?

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 […]

KScope17 Session: Complex Data Security Made Easy in Oracle BI

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 […]

Data Security in Oracle BI: Are You Prepared?

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 […]

Best Practices for Extracting Data from BICS Using Data Sync

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. […]

BICS Best Practices for Modeling Conformed Logical Dimensions

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 […]

Best Practices in Reality for Extracting ERP Cloud Data from OTBI

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 […]

Using Custom SQL (BIP) to Extract ERP Cloud Data from OTBI

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 […]

Using Physical SQL (PVOs) to Extract ERP Cloud Data from OTBI

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 […]

Using Logical SQL to Extract ERP Cloud Data from OTBI

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 […]

A Best Practice for Creating Dynamic Column Reports in BICS

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 […]

Load More