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 22.214.171.1241) 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.
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).