BI Publischer Enterprise and JD Edwards EnterpriseOne

Frank Ott

Summary

BI Publischer Enterprise and JD Edwards EnterpriseOne

Content

Hello,

I try to create a data model in the BI Publisher Enterprise 11g with the data from JD Edwards EnterpeiseOne 9.1

For the data connection I use the JDE DAD driver.

I use the F4211 as the target table. I select different fields also the fields KCOO and MCU.

I create a parameter for KCOO to select a company from a list. It works fine.

Now I create another parameter for the field MCU to use the MCU also in the data selection.

But when I use the MCU it is not working.

I think the problem is with the leading blanks in the filed MCU. When I use a parameter for the MCU the BI Publisher cuts the leading blanks from my value and the SQL selection is without the leading blanks. So the result was no data selected.

How can I crate a parameter for the field MCU with the leading blank?

Thanks for help

Frank