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.