вторник, 25 июня 2013 г.

SAP BO 4 with Oracle database - config parameters oracle.prm

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


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.