on 12-01-2010 8:30 PM
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.
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).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I found [this document|https://forums.sme.sap.com/servlet/JiveServlet/download/308-1562851-8553211-1364/OLAP%20universes%20on%20SAP%20Netweaver%20BW%20-%20metadata%20and%20data%20types.pdf].
I intepret that to say that you should leave the type as CHAR in the universe but format using "=ToDate([Object;u201DHHMMSSu201D])" in your WEBi report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.