I got the problem:
In our dwh in business layer we have some fields like name, id, size. These fields are key words in Orcle and we should use they in quotes (""). For example:
SELECT
tablename.ID
From tablename
doesn't work, we should modify query:
SELECT
tablename."ID"
From tablename
Now it works.
But adding quotes is possible only via Universe Designer, but not via Information Design Tool.
And we have 2 options, how to fix it:
1)Modify tables, views and etl or procedures.
2)Add parameter to Oracle.prm file: DELIMIT_IDENTIFIERS
And now our query will be:
SELECT
"tablename"."ID"
From "tablename"
But works properly.
In our dwh in business layer we have some fields like name, id, size. These fields are key words in Orcle and we should use they in quotes (""). For example:
SELECT
tablename.ID
From tablename
doesn't work, we should modify query:
SELECT
tablename."ID"
From tablename
Now it works.
But adding quotes is possible only via Universe Designer, but not via Information Design Tool.
And we have 2 options, how to fix it:
1)Modify tables, views and etl or procedures.
2)Add parameter to Oracle.prm file: DELIMIT_IDENTIFIERS
1. Close IDT
2: Navigate to that following location and edit the Oracle.prm file-
C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects
Enterprise XI 4.0\dataAccess\connectionServer\oracle
3: add below mentioned parameter:
<Parameter Name="DELIMIT_IDENTIFIERS">YES</Parameter>
4: launch IDT.
5: Try to create a new DFX, BLX and check the check the object names.
And now our query will be:
SELECT
"tablename"."ID"
From "tablename"
But works properly.
