When I edit a derived table in BO XI R2 Designer, it changes the name from XYZ_123 to “XYZ_123”. In other words, it adds the quotes around the derived table name. It does not seem to matter if I make a change to the derived table or just open the derived table and close it - it adds the quotes. It also does this to a table named XYZ (no spaces, no underscores - just characters).
Is there a way to keep Designer from adding the quotes?
The issue with the quotes is that Desktop Intelligence then reads the table as Table__nn instead of XYZ_123.
No one ever replied. Ironically, I found out the answer yesterday from someone else in my company. They are encountering it also.
The fix appears to be:
Right-click on the derived table
Choose Rename Table
Select UPPER CASE and click Apply
Click OK.
Do it again:
Right-click on the derived table
Choose Rename Table
Select UPPER CASE and click Apply.
For whatever reason, you need to convert it to upper case twice. Once doesn’t seem to take. And it doesn’t work by choosing lower case or clicking on one of the options and then changing to mixed case.
That’s when I get it also: I am editing an existing derived table in an existing universe and BO changes the table name all on its own.
It’s pretty frustrating that BO seems to think that anything other than upper case is special characters, but I’ll take an all upper case table name over Table__123 anyday.
If this method doesn’t work for you, I really don’t have any ideas other than patience and persistence.
Try doing different combinations - twice with upper case, three times with lower case, once with upper, then once with lower - you get the idea. I ran into this also and I think I just kept trying different combinations and it finally worked.
Actually, there is a tag in the .prm file used for the connection. In my case oracle.prm.
setting this tag to “N” stopped any insert of quotes or other char. during development. however, I returned to the original value “Y” after finishing designer work as this tag controls tables with spaces in the names or special chars.
Hi,
This one for DB2 users
There is db2udb.prm file in the below mentioned path
drive:\Program Files\Business ObjectsXIR2\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\db2\db2udb.prm
Edit this line from
Y
to
N
It will do the magic.
For other databases, look for database folder from the below mentioned path and make changes to respective .PRM file.
drive:\Program Files\Business ObjectsXIR2\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\
Any of the above ideas din’t work for me, however I found out a way. I noticed that the Designer was inserting double quotes only when I have a table name separated by space like for Ex. I was using table name as Cash Flow and the Designer was inserting/applying quotes thus not showing my actual derived table name in the report query and when I later changed the table name to Cash_Flow i.e I removed the spaces, the quotes too were removed. …Try this method if it works for you too.
(BOB member since 2005-06-08)
(BOB member since 2007-10-23)
…Try this method if it works for you too.