Hi , When playing with data and storing a lot of data in tables . Most of the time in the career playing with data , this is an important role that would be played –performance tuning . Also , this is a most important question that would be asked in any interview. High level the steps are to understand where the bottleneck is and try … Continue reading Performance Tuning in Teradata
Hey Guys, Feel super excited in sharing this information. I was given a task to go through log files in a directory. Seems super easy but there were a few challenges through the way. The easiest way was go through a directory and read it in pandas. But had issue where there were comments and there was no straight way in reading it or skipping … Continue reading Reading data from a directory using Python
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
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
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
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
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
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
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)
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
Its All About Data - By Jethin Abraham 