Skip to Content
avatar image
Former Member

strange behaviour of query pls suggest

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 16, 2008 at 06:30 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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