Skip to Content
0
Jul 16, 2013 at 08:03 AM

universe "Unexpected behavior" in WebI (no issue in IDT)

1913 Views

I have created a universe via the Information Design Tool.

This universe gets data from a table in our R/3 system (via a function module) - the table looks like:

Field Data element Data Type Length Decimal Places Short Description GJAHR GJAHR NUMC 4 0 Fiscal Year MONAT MONAT NUMC 2 0 Fiscal Period ZDCO ZDCO INT4 10 0 DCO ZDDCO ZDDCO INT4 10 0 DDCO

If I run a query in the Information Design Tool on this universe I get the following results:

But when we try to create a WebI report we cannot run the query if we add MONAT in the query:

If we remove MONAT from the query we get:

How can we solve this issue?

Kind regards,

Lieselot

Attachments

IDTresult.png (19.2 kB)
WebIresult.png (10.7 kB)
WebInoMONAT.png (14.6 kB)