on 07-05-2017 3:10 PM
BO Environment
4.2 SP3 FP5
4.1 SP8
Postgres 9.1 ODBC connectivity
The Database team has recently created a Materialized view on the database side( post gres) , I can see the materialized view through the service account in Postgres client , but from Universe designer I cant see that , although I can see Other views but not Materialized view.IDT same thing
I can though create a Derived table referring the Materialized view i.e Select * from Metarlized view.
Tried in Crystal designer there as well I cant see that Materialized view. Any Inputs on what can be wrong , didn't find any guides to it.
This was an issue for JDBC corrected in SAP Note
2246247 - BI4.1 The list of views does not appear in IDT when using PostgreSQL 9 DB
It's possible it is not corrected for ODBC. Can you try with the JDBC?
otherwise I would open an incident with Support.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
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.