KPI Partners Blog

Star Schema or No Star Schema? That is the (Tableau) Question.

Posted by KPI Partners News Team on Tue, Sep 23, 2014 @ 01:23 PM

by Avinash Mohan

Exploring the different ways Tableau connects to data and whether dimensional modeling is necessary when using Tableau’s architecture.



Tableau has two primary ways to connect to data sources and work with them as shown in this simplified architecture diagram shown below .

Read More

Tags: Data Warehousing, Real-Time BI, Cache, Avinash Mohan, Data Discovery, Business Intelligence, Tableau, Data Integration, Book, Blog

Free OBIEE Cache Purge/Seed Utility

Posted by KPI Partners News Team on Wed, Aug 20, 2014 @ 02:10 PM

by Shiva Molabanti

To see reports with the most up-to-date data from the latest extract-transform-load (ETL) process, we typically purge the Oracle BI Server Cache using a common job called, "Cache Purge."

Read More

Tags: OBIEE, Pre-Built Solutions, Shiva Molabanti, Cache, Business Intelligence, Tutorial, ETL, Oracle BI, Oracle BI Applications, Blog

What Is Cache?... 5 Steps to Automatically Purge Cache in Oracle BI

Posted by KPI Partners News Team on Wed, Apr 16, 2014 @ 01:02 PM

by Raviteja Mamillapalli

What is Cache?

Analytics systems reduce database calls by creating a ‘Cache’ of data on the same machine as the Analytics engine.  Caching has a small cost in terms of disk space to store and a small number of I/O transactions on the server, but this cost is easily outweighed by the improvement in response time.

Read More

Tags: OBIEE, Cache, DAC, Raviteja Mamillapalli, Oracle, Business Intelligence, Oracle BI, Oracle BI Applications, Blog