dbt_artifacts is a package for modeling a dbt project and its run metadata. It includes the following models to help you understand the current state of a dbt project and its performance over time. It...
Purpose of the Article: This blog explains how to load the data from Salesforce to Snowflake Intended Audience: This article will help our Organizational level kind of developers working on data migra...
Tableau vs Looker: Which BI tool is best for you?...
1. Introduction The wireless market is growing rapidly; being pushed through wireless connectivity demand various wireless connectivity means are emerging (WLAN/802.11, WMAN/802.16a, WWAN/802.16d) [IE...
Tags
Categories
OBIEE conditional format using arrows was sought. Let’s start with the basic report: Calculate the delta: Add two conditional formats: Add the correct images: Set it to image only: There you go: ...
Read MoreDownload NAVTEQ sample data from the below path: http://www.oracle.com/technetwork/middleware/mapviewer/downloads/navteq-lic-168395.html Link to download or buy map data from different vendors: http://www.oracle.com/technetwork/database/options/spatial/downloads/partners/spatial-partners-data-087203.html#navteq Step 1: Download NAVTEQ data Go to the below link: http://www.oracleimg.com/technetwork/testcontent/o31bi-354140.html Create a folder c:\Sample_data and extract or unzip the contents of both the file into this folder location. Step 2: Connecting to...
Read MoreThe newest release of Oracle Business Intelligence 11.1.1.7 shows Oracle's continued efforts in trying to integrate its Oracle Business Intelligence Platform with big data technologies such as Hadoop and Hive. Specifically, I'm talking about OBIEE 11g's ability to integrate with a Hadoop Data source. What is...
Read MoreI've seen quite a few articles on OTN and Google which outline how to configure Mapviewer for your 11g solution. The problem is that many of these articles are: 1) overly complex 2) out of date With the release of OBIEE 11.1.1.6, mapviewer comes pre-configured with weblogic and the...
Read MoreSome times the data model does not allow you to create a single query to get the results you need. then we are forced to do a Union. (actually they are 4 possible operations Union, Union All, Minus and Intersect). The default is Union. I...
Read MoreOBIEE with Key / Name / Value table, the Union solution A customer asked me to create an analysis on top of a Name - Value table. A table where instead of having one row for each key, there are multiple rows with the structure of...
Read MoreIn one of our projects we had a requirement of putting tooltip on column header without losing the data format of the column values. Below are the steps: Open an analysis in OBIEE 11g Go to column format of the column where tooltip is required Put...
Read More‘Custom links’ are a way of embedding external content into the OBIEE home page and main header at the top of the webpage. This can be very useful to a user as it allows all the external content they require to be located in 1...
Read MorePerformance Tiles are easy to create, but a little supporting code can improve their effectiveness. Legends define the ranges clearly and give context to the metrics. With the logic exposed, the description can contain information on underlying calculations or data lineage. The original tiles from the...
Read More