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
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
Here we will learn how to configure Git and publish your changes from Git to GitHub. To learn how to install Git please follow the link below Installing Git Once you have installed Git the first step is to open Git Bash and configure your user id and user email id. Please make sure … Continue reading Configuring Git to Connect with GitHub
Hello All, I was exploring Github and Git and really love the whole concept of this process. I would like to share how to install Git which is the local repository and GitHub which is the social platform where you can publish your work and collaborate with others. Before you install Git you will need an account in GitHub. Once that is done you will … Continue reading Installing Git on your local
Scenario I had created a BIP report with a dynamic date of sysdate -8 as a prompt. The report works fine and the dataset is all good. However when I schedule this report I get and error stating ‘IOException:[INSTANCE_JOB_ID=344978] Invalid parameters requested.’ I tired to look into the code and also the trigger which I had set up and for some reason I could … Continue reading Dynamic Date Parameter in BIP Scheduler
Q. How to convert a Excel sheet in SAS as source ? A. We cannot use Excel as a source directly in SAS. It has to be converted to a SAS Data Set and only then can be used in your SAS Analysis.PROC IMPORT is the function which is used to convert the excel data to SAS Subset Code for importing Excel … Continue reading SAS and its different syntax
What is Data Visualization ? Data visualization is, quite simply, the process of describing information through visual rendering. Pictures speak louder than words.Humans have used visualizations to explain the world around them for millions of years. Data visualization allows immediate insight by tapping into our mind’s powerful visual processing system. Why is Data Visualization So Important ? Technology and the digital era have made data … Continue reading Why Tableau is the best visualization tool in the market
Many believe Microsoft soared and Apple bored in last weeks launch of new machines, Microsoft’s looked like something new and Apple’s resembled something familiar with a few bells and emojis added. So a look at Microsoft’s and Apple’s new product videos offer a certain atmosphere from which to compare the two. Microsoft Surface Studio Apple Mac Book Pro … Continue reading Apple VS Microsoft – Based on the videos after launch
Thinking about the different realms of science and technology, it is hard to envision a domain that is going to change the world as much as data science will in the decades ahead. With Internet around, there is tremendous amounts of data. Finding patterns in large amounts of data has always been a stumbling block. However, by using state of the art software for data mining … Continue reading Its all about data
What is MUD ? Multiuser development (MUD) provides a mechanism for concurrent development on overlapping code bases.It provides a built-in versioning system for repository development. How does MUD Work ? Several developers work concurrently on subsets of the metadata and then merge these subsets back into a master repository without their work conflicting with other developers. Administrator creates projects in the repository file in the … Continue reading Best practices for setting up MUD – Multi User Development in OBIEE 11g
Its All About Data - By Jethin Abraham 