OBI Info

Creation of Dataflows in power BI Dataflows in power bi are reusing power query logic among different pbix files. Dataflow is a collection of entities that are created and managed in power bi service. You can add and edit entities in your dataflow and manage data refresh schedules directly from workspace. Why we need in power bi:   Power bi introduces data flow to help organizations unify data from disparate sources and prepare it for modelling.   Dataflows are used to ingest, transform and integrate by defining data source connections, ETL logic and refresh schedules.   Data is stored as entities in common data model in azure data lake storage GEN2 and these were created and managed in workspaces by using power bi service. Steps to create dataflows in Power BI 1. At first we need to create one workspace for the dataflow in power bi. 2. After creation of workspace, we will create a data flow in power bi service. ...

Snowflake Integration with OACS. Snowflake is an analytical data warehouse provided as a software as a service (SaaS). It provides a data warehouse that is faster and easier to use and more flexible. Multiple ways to connect snowflake.       1. Command Line Utilities. (SnowSQL)       2. ODBC and JDBC drivers that can be used by other applications.   (Tableau)       3.  Native Connectors. (Python)     4. Third party connectors can be used to connect applications such as ETL and BI tools to snowflake. Steps to Integrate snowflake with Data Visualization (DV).     1.   Create a snowflake account.           www.snowflake.com     2.    First we need to create one snowflake account by filling the details as shown in below figure.     3.  Here we have editions in snowflake.         ...

OBJECTIVE : In this blog, I will explain how to create merge cells in OBIEE dashboards. The main functionality of merge cell is all of the text and numbers from the individual cells is merged and displayed in the center of the merged cell. How can we create merge cells in OBIEE reports? Open the Oracle Business Intelligence platform.       Enter the credentials and login to oracle business intelligence.      2.     Create new analysis.   3.      After selecting Analysis, select any one subject area.   4.     As I selected sample sales Lite as my subject area to prepare merge cells in report.        The page will be opened like this: 5.     Select required columns from subject area in left panel to right panel as shown in the figure.    6.    The result will display as month...