on 05-05-2015 9:25 AM
Hi!
I have a problem which a lot of people seemed to have solved. Unfortunatelly not me. We are currently using BO 4.1 SP05 and accessing Oracle Exadata (Oracle Client driver). I am trying to include several synonyms in my single source DFX. While I am able to see and add these synonyms, I am unable to see their columns.
I changed the "Include Synonyms" parameter in the Oracle.sbo file (client machine) to True but still no columns.
Has anyone got an idea how to fix this?
Regards, Miha
https://service.sap.com/sap/support/notes/1953956
https://service.sap.com/sap/support/notes/1835823
I've listed two relevant KB's. Yes this was an issue.
A work around exists to use the parameter "Include Synonyms" as True in the Oracle.sbo file.
Fixes were
BI 4.0 SP 7.7 BI 4.0 SP 8.2 BI 4.0 SP 9 BI 4.1 SP 2.2 BI 4.1 SP 3 Not reproducible in 4.1 SP4.
If you are on at least SP4 and you have used the parameter listed in the KB. I would investigate this may be a bug regression.
Thanks,
Jacqueline
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Miha,
We had similar issue in 3.x environment with SQL server environment.
We are supposed to support both Oracle and SQL server databases in that case we used Synonyms for Oracle and Views for SQL server.
In our case the name of the table and synonym are same, so what we used to do is develop the universe using normal user who has access to the main tables and then we used to use the actual user for testing. So it displays the columns always
The pain point is whenever you want to change/refresh the structure you need to login as the user who has access to main tables.
If you think you can manage this activity then you can still go ahead use synonyms.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Miha,
Were you able to resolve the issue?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi and thanks for the replies!
I want to emphasize what I posted in my initial post:
1. I am using UNX/IDT (solution with external strategies not applicable).
2. I already tried setting the "Include Synonyms" parameter in the Oracle.sbo file and it didn't work.
So, none of the above suggestions provide any help.
I am starting to suspect that the cause for this behavior is somewhere else (DB level). Maybe I should use views instead of synonyms. Hm...
Regards,
Miha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
just to echo the above
Note SAP 1622792 - BI 4.x Columns from Oracle synonym tables are not visible in data foundation and universe structure
and also some other related notes:
1706214 - Synonym Columns not visible in UDT 4.0
Regards,
H
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
The issue was resolved after following the below SAP Note: 1706214 - Synonym Columns not visible in UDT 4.0
One of the user was not able to replicate the note, so we provided the access to Oracle.sbo file, after making changes he had to restart his laptop which resolved it at his end (may be some cache issue).
Thanks
Unmesh
Hi ,
This is the bug with SAP version.
But you can still add synonyms by doing following steps:
http://rakshits-bi.blogspot.co.uk/2011/09/sbo-designer-enable-use-of-synonyms-in.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Swapnil
As far as I know, this was a bug, which was supposed to be fixed (introduction of the "Include Synonyms" parameter), but obviously hasn't. Your proposed workaround includes external strategies which to my knowledge aren't supported in IDT. The affected universe is in the UNX format, so IDT is mandatory. If the above workaround can be achieved in the IDT, please let me know.
Regards,
Miha
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.