cancel
Showing results for 
Search instead for 
Did you mean: 

strange behaviour of query pls suggest

Former Member
0 Kudos

Hi guys

we have a query here of sales which have a variable of calender month

if we are passing three intervals i.e 01.2006 - 03.2006 , 01.2007 - 03.2007 , 01.2008 - 03.2008 and in still its showing some value of 01.2005 in query output whichi is very minimal ( 0.17) . this is happening only for this interval other intervals or single values i have tried all are showing correct. i am astonished how its happening. guys any clue .

Regards

Amiya

Edited by: Amiya Rath on Oct 16, 2008 6:03 PM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

how do you display the results? in a workbook? if so, check the query properties once the workbook has run... if someone has put a filter in there and saved the workbook, it remains there (without being very obvious)

Former Member
0 Kudos

hi

report is being displayed in EP and there is no personalization has been done as i have checked in different users login its behaving same.

Former Member
0 Kudos

guys problem solved long back i forgot to close this thread

actualy there had a probelm in transformation so in cube data was wrong i.e

Regards

Amiya