Hi Rama, Thanks problem here to distribute Months between Start Date & End Date. How to identify how to plot for ever month by checking its start date and end date. Regards sher ullah baig

any expert view on this???

Hi Srini, Thanks, i tired this but problem is Sorting on Pivot table you can sort ASC or DESC but i want to arrange according to my needs for Product Name Want to Achieve: in Pivot table NameAmountKeyboard120Mouse80Total (key,mouse)200Window Glass500Tables1000Chair1500Total3000

any comprehensive guide on this ?

Step 1: Create Analysis take any column (dummy column) Step 2: Past below to get yesterday Date TimestampAdd(SQL_TSI_DAY, -1, CURRENT_DATE) Step 3: Save Analytics Step 4: Drag and Drop on Dashboard Section where you want to show to your users. hope this will help u. regards

Thanks Thoms this resolved my issue. A followup question, Do i need to perform any Configuration on Linux Server to read Excel File ? i saw some blogs but couldn't understand them well. Thanks agian

Hi Thomas, Thanks i tired but problem is that BI Admin Tool is by default picking DNS Connection from "Windows\System32\odbcad32.exe" I want to tell BI Tool to Pick DNS Connection from here "windowns\SysWOW64\odbcad32.exe" Regards sher

Hi Your log file says: 2016-03-15T16:16:02.000+05:30] [OBIPS] [ERROR:31] [] [saw.connectionPool.getConnection] [ecid: ] [tid: ] Error connecting to the Oracle BI Server: Could not connect to the Oracle BI Server because it is not running or is inaccessible. Please contact your system administrator.Odbc driver returned an…

Thanks Gianni. i do agree with you but it quite hard to chase oracle New releases but its a good practice to do so. Regards

Thanks mate it worked perfectly.

Hi am not 100% sure but you can try following, 1- Make sure ur OS user is having Admin privillages 2- disable anti virus 3- check disk space on ur C drive

Thanks Bec_Wagner will go thought about it thanks