Create a Database Function in 5 min

Hi , The SQL CREATE FUNCTION statement is used to create stored functions that are stored in an Oracledatabase. A procedure or function is similar to a miniature program. Usually if we would want to get an output while passing an input , function would be widely used. As always I like to give a scenario where this can be used   Scenario: There is an application that usually runs a large … Continue reading Create a Database Function in 5 min

All values as default option in OBIEE

Hi, I came across a requirement where I wanted the Departments to show all column values but do not want the dashboard prompt defaulted to all column values. Found this article in the blog where adding % as default values does the trick. When defining the presentation variable after defining the name in the filter in place of default values place % and that should … Continue reading All values as default option in OBIEE

Connecting to Microsoft SQL Server using Python

Hello All, Here is a quick guide to connect to Microsoft SQL Server and Extract data to a csv. I have an interest in python recently and posting all that saves me time at work. Python is so powerful that it saves me a lot of time either doing the work manually or writing the same process using other tools. The code below is simple … Continue reading Connecting to Microsoft SQL Server using Python

Split Multiple Files Using Python

Hello Guys,   I found this code really useful and wanted to post it for future reference. At work , at times there is a need to provide data in excel. Unfortunately Microsoft Excel cannot load data which is more than 80K.  In this case scripts like splitting data comes in handy. The code first creates a function and then its called by passing the … Continue reading Split Multiple Files Using Python

Connecting to Redshift using Python

Hi, I have been exploring Python recently as a part of doing my Masters in Data Science and I must says , its really a powerful tool and the possibilities are endless using Python. Recently we had a project to connect to Amazon Redshift and was having issues using ODBC and adapter. I was exploring on the possibility of using Python and its amazing that … Continue reading Connecting to Redshift using Python

Default Current Date in OBIEE Dasboard Prompt

Hello All, In most of the current dashboards users would want to default the date range to a specific interval . Defaulting the report to current date is not only a frequent ask but also helps to reduce the number of records to be processed by the BI Server therby improve performance when the report is run for the first time. In order to default … Continue reading Default Current Date in OBIEE Dasboard Prompt

How to rename files in a directory using Python – (Solved)

Hello All,   I got myself coding using Python . Its really a great tool and wanted to share some of things I have been doing while mastering this tool. Scenario – I am collecting data from twitter and unfortunately got my filename wrong. There were around 750 files in the folder and manually changing the name is cumbersome , that is where python helped … Continue reading How to rename files in a directory using Python – (Solved)

“O9XNZMXB” issue in OBIEE 11g Answers and Dashboards – Resolved

Hello Guys,   Recently I faced a dashboard privilege issue which I spend countless hours to resolve the issue. Scenario Create a new group and provide privilege to a dashboard. Pretty straight forward right !!.  After creating the application roles and providing folder privileges I was hit by this error message and the error details didn’t provide much information. After researching and playing around with … Continue reading “O9XNZMXB” issue in OBIEE 11g Answers and Dashboards – Resolved

String Aggregation in OBIEE

Hello All, There was a requirement of aggregating multiple row values to one row. This is a requirement of summarizing the data which is easily achievable using SQL. However this article will provide you information on how to do it in OBIEE.   Problem Here there are different employees in different department .   And you  would want to see it as below.     … Continue reading String Aggregation in OBIEE

Scope of Inference in Statistics

Hello All,   I am doing my statistics course and I was finding a hard time writing the scope of inference reading the questions. This diagram helped me understand better what to write when we have a random sample and a random assignment.   First we have to understand what is random sampling and random assignment   Random Sampling – In this technique, each member of … Continue reading Scope of Inference in Statistics