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
Recently a client came up with a requirement to host externally-generated PDF reports in OBIEE and have them display alongside their other OBI content. They also wanted these files to be searchable by name like the rest of elements comprising the web catalog. To achieve...
Read MoreCreate an analysis in Excel using SmartView and save in OBIEE catalog Using SmartView add-in, we can create OBIEE reports from Excel/Word and save in OBIEE catalog.And we can see those reports within OBI Presentation services and can use it for further analysis. To create an OBIEE...
Read MoreCustom Sorting to Column values in Pivot table Custom Sorting In Pivot Table: We have order status and the transactional amount. The requirement is to show the transactional amount across the three different order status: 1.Booked 2.Cancelled 3.Closed User wants the order status to be sorted in the report as below: 1.Closed 2.Cancelled 3.Booked By...
Read MoreWhen the results of an analysis return no data, the following default message is displayed to users: We can modify the No Results view, by adding custom message or more explanation on the use of report or hints on how to filter values. We can also change...
Read MoreRecently I came across a customer requirement to allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly’ or ‘Monthly’ and the appropriate sections of a dashboard would be shown. To achieve this I...
Read MoreHow was it done? I created a basic report: The last column has no meaning, we just need something to be in the measures part. In my case I decided to have a column of NULLs with space as a label. So I create a Pivot: And rearrange it: Now...
Read MoreBottom N function displays the lowest n values of the expression argument from 1 to n, 1 corresponding to the lowest numeric value. The BOTTOMN function operates on the values returned in the result set. A request can contain only one BOTTOMN expression. ...
Read MoreOne of the main problems of Narrative is the lack of drill options, what is called now "Navigate to BI Content". On the other hand, it can be easily achieved using basic scripts and GO URL. I will do a basic example, for more detail on...
Read MoreThere will come a point in the lifecycle of an OBIEE deployment when one user will need to access another user’s account. This may be to cover whilst a colleague is on leave, or a support staff trying to reproduce a reported error. Password sharing aside,...
Read MoreBursting is a process of splitting data into blocks, generating documents/output for each block and delivering the documents/output to one or more destinations. The data for the report is generated by executing a query once and then splitting the data based on a key value (e.g....
Read More