on 02-28-2014 1:43 PM
Hi,
Normally when we add an alias table to the idt unx data foundation layer generates a table without putting quotes at start and end.
In this case it has put quotes and in tetsing cauisng problems as given table name as table_1 instaed of alias name we have given it and want to see it generate correct table name
what causes this - how can we change it
table_1 - called official_issue_calendar but even despite we name it that when look in dat afoundation at tables calls it "official__issue_calendar"
Why is this and how can we stop it - other alias tables have been fine. Using idt tool bo4 sp08.
SELECT
MEDIA.ISS_ACTUAL_ON_SALE_DATE_M
FROM
MEDIA,
DW.LATEST_PRODUCT_MV,
CALENDAR Table__1
WHERE
( MEDIA.PROD_NUM=DW.LATEST_PRODUCT_MV.PROD_NUM )
AND ( MEDIA.ISS_OFFICIAL_ON_SALE_DATE=Table__1.DAY_DTE AND Table__1.DIMENSION_KEY = Table__1.DAY_ID )
AND
(
( MEDIA.ISS_HANDLED_MONTH_NUM_M = TO_NUMBER(to_char(trunc(sysdate),'MM')) )
AND
( Table__1.MMN_VALUE = TO_NUMBER(to_char(trunc(sysdate),'MM')) )
)
Thanks
Hi Philip,
Did this proposed solution work for you?
Best regards,
Pavan Bayyapureddi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I sort of found a work-around for this.
Version: BI4 SP6 Patch 7
1. Add the alias table.
2. Rename it with name in UPPER CASE. Magic!! It works!!!
3. Now you will see the table name without double quotes("") and also the show script shows the alias name and not like "table_1".
Strange but that is how the tool is behaving.
Before naming the alias table with UPPER CASE.
After naming the alias table with UPPER CASE.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Update: The resolution is to change the Oracle.prm file.
Go to the following location in the Business Objects installation folder in your computer.
Create a backup of the current Oracle.prm file.
Open the Oracle.prm file as administrator using Notepad.
Then change the "DELIMIT_LOWERCASE" parameter to "NO". Save the file.
Now, restart your IDT and you should be able to name your alias tables to either upper or lower case without any problem.
** It is important to know the Oracle.prm file because I had to already do two modifications to this file.
There are two locations of this file.
1. C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle\extensions\legacy
For the above issue only update the 'legacy' folder.
2. C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\oracle\
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.