Daniel Xiao, Author at Perficient Blogs
Blog

Posts by this Author

  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

Daniel Xiao

Posts by this author:

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

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

Read more

3 Ways to Integrate Oracle ERP Cloud (OTBI) with DataSync (BICS)

Here are the blogs that I have posted previously as part of my blog series on Oracle DataSync (BICS). Best Practice to ETL with Data Sync (BICS) In this blog, I am going to talk about three different ways to integrate Oracle ERP Cloud data with Data Sync (BICS) through OTBI.         […]

Read more

Configure Data Sync (BICS) to Load Staging Database

In this blog, I will finish the Best Practice to ETL with Data Sync (BICS) post by showing you how to configure the Data Sync to load data in staging database. First, set up a new database connection in Data Sync for SQL Server or Oracle database. For SQL Server > Set Connection Type to MSSQL > Fill in the rest […]

Read more

Best Practice to ETL with Data Sync (BICS)

As Oracle BI Cloud Service (BICS) starts to become popular, I am going to write a series blogs about best use of the Data Sync to upload data to BICS schema service.  In this post, I am going to share with you a best practice to use Data Sync for ETL. As an ETL tool, Data […]

Read more

Subscribe to the Weekly Blog Digest:

Sign Up