SAP Knowledge Base Article - Preview

1696002 - Date dimensions used in a query filter are converted to an Epoch (numeric) format by Web Intelligence causing the query to run incorrectly

Symptom

  • Date dimensions used in a query filter are converted to an Epoch (numeric) format by Web Intelligence causing the query to run incorrectly
  • Date selected from calendar takes a garbage value when the report is based on UNX and Microsoft SQL Analysis Server
  • The date object used in a query filter is converted to an Epoc (numeric) format by WebI and either no data is returned when data should be, or a processDPCommandsEX error is produced
  • If just running the object in the query and not added as a prompt, it displays 1/1/70 instead of the correct date


Read more...

Environment

  • SAP Business Intelligence 4.0
  • SAP BusinessObjects Enterprise
  • Web Intelligence
  • OLAP

Product

SAP BusinessObjects Business Intelligence, Edge edition 4.0, standard package

Keywords

WebI, WebIntelligence, Web Intelligence, olap, msas, ms, ssas, cube, query, filter, epoch, number, numeric, change, convert, no data, blank, incorrect, not correct, format, wrong, display, show, nothing, WIS, error, exception, Epoch, dimensions, object, datetime, date, prompt, between, member, selection, ADAPT01628113, ADAPT1628113, ADAPT, 01628113, 1628113 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.