IDT Error on Multiple connection DF

[jens_grotholtmann]

First of all, let me describe, what I did:

I created a number of tables and some views within a oracle 11g db.

I created a connection, secured it and build a multisource DF on top of it.

Now I started building the universe on top of it. It all worked very well, except 3 columns of a single table. This table is not connected with any other tables und reflects a view. I have other tables which are views and those work perfectly good.

If I press the "Show Values ..." Button, it throws a:

Failed to execute: SELECT DISTINCT

  Table__26."COL2"

FROM

  "DEMO-CONNECTION"."SCHEMA"."TEST_VIEW"  Table__26

Cause of Error

[Data Federator Driver] [Server] The column name 'COL2' could not be found in the table/alias: 'Table__26'

The column exists. Recieving row from the TEST_VIEW with Developer works to, recieving rows from other views inside IDT works as well.

I tried recreating the TEST_VIEW, I even put a dummyvalue inside the columns with errors but it did not work. The SQL does not get fired on the DB (verified this by looking at V$SQL).

Any suggestions?

[jens_grotholtmann]

Anybody an idea?

Maybe this is the wrong space, so if a Moderator reads this, if there is a better space for this thread, please move it!

Thanks in advance!

[former_member193452]

The form is correct.  Semantic Layer addresses the Data Federator component in BI4.x.