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...
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...
Patch Name wls1036_upgrade_generic.jar Reference https://www.youtube.com/watch?v=Be6hrYTANQE Just Click Next and Next MAKE SURE ALL OBIEE SERVICES ARE DOWN AND CLOSED IN PROCESS Open CMD prompt C:Mid...
Tags
Categories
Create 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 MoreStep 1: In the Administration page, Goto System Maintenance à Scheduler Configuration. In the Scheduler Configuration page that appears, click Test Connection in the Database Connection section to check if the scheduler is configured properly. This should display the following message indicating the connection was successful. Step 2: In the Administration page, Goto DeliveryàEmail. Click on Add Server. Step 3: Select the report...
Read More