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.