Naaz Vilantakath
Posts on Business Intelligence and Data Warehousing
Friday, July 11, 2014
How to know oracle client bit version in linux whether 32 bit or 64 bit
›
How to know oracle client bit version in linux? *For this you need oracle user $ cd $ORACLE_HOME/bin $ file sqlplus sqlplus: ELF ...
Friday, December 6, 2013
Rewrite correlated subqueries in cognos compatible way. Decorrelating subqueries
›
Correlated subquery scenario 1 SELECT c.LastName, c.FirstName, (SELECT CompanyName FROM Company WHERE ID = c.CompanyID) AS CompanyName ...
Tuesday, November 19, 2013
xming can't connect to x11 window server using ---- xming error putty
›
Problem : xming can't connect to x11 window server using In run command, enter command in following format: "C:\Program Fil...
Monday, November 18, 2013
Sub query subquery in Cognos Framework Manager
›
The only way to implement subquery in Cognos Framework Manager can be done by directly writing in Query Subject Definition or writin in Par...
How to deal with queries with EXISTS clause in Cognos?
›
How to deal with queries with EXISTS clause in Cognos? Here describes how to rewrite SQL queries containing EXISTS clause to Cognos com...
Over (partition by ) query in Cognos Report Studio
›
If we need cognos to generate analytical function over(partiontion by) : Type Expression Cognos query gener...
2 comments:
Thursday, October 3, 2013
Cognos split crosstab corner cell Report Studio
›
Below steps will show you how to split Crosstab corner cell (to add title). 1. Drag a text item from toolbox to the colum...
8 comments:
›
Home
View web version