Hello,
I am facing a weird scenario when querying for all 4 quarter end dates. Data comes back fine for all quarters except Dec 31st when using web service in Xcelsius dashboard. Data comes back fine in Preview mode though for Dec 31st while creating web service (say 12/31/2012).
FYI,
- Even though the database & universe objects are DATE formats when used as prompts, it displays as 12/31/2012 12:00:00 AM on both webi & qaaws queries and works fine to pull back data both webi & qaaws.
- Replicated the qaaws in webi and took the SQL and ran it on Informix and works fine for 12/31/2012.
-
While tracing web service using Fiddler I noticed that date is being displayed/passed as 2012-03-31T04:00:00.000Z in input and the same date is displayed as 2012-03-31T00:00:00.0 and gets back data fine.
This same scenario for Dec 31st behaves differently:
Input : 2012-12-31T04:00:00.000Z
Output: 2012-12-30T00:00:00.0 when it is the only object and does NOT bring back any data(with message “NO data to fetch”) when any other objects are added to query.
Because of such behavior I think somehow it is querying for 12/30/2012 date on database and so not finding any data to return. - Linux server is configured for EST and we are on BOXIR2 version.
Any ideas would be appreciated on what else needs to be checked, how to test/debug anything else, what could be the reason etc…
Please let me know if you need any additional information.
Thanks in advance.
bambazooka 
(BOB member since 2007-01-26)