Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Translating Dates defined as Key Figures in an OLAP Universe

Here's something I have not seen yet. We want to build a BO Universe on top of a BEx Query. The BEx Querie includes Key Figures which display as Time stamp (probably date formated) values. For example, when BEx query runs, it displays a Key Figure called "Cut Off Time" as 15:40:31 indicating it's 3pm 40 min and 31 seconds. The Universe Designer (BOXI 3.1 SP3 Designer 12.3.0.601) translates it as a date, however, it displays the message "#DATATYPE" when running a querie against it. I've tried changing it to a number, a character, a date and setting the format as hh:mm:ss etc. but nothing corrects the issue. If I define it as a Dimension Object the query will not run at all. Any suggestions on how to properly set this up so BO Designer can translate it is appreciated. Thanks.

replied

Very interesting document, unfortunately I gather that key figures of type TIM are not supported but those of type DAT are mapped as date and supported (last page of the document).

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question