Skip to Content

Materilazied View Does Not show up In BO Universe Designer Postgres 9.1

Jul 05, 2017 at 02:10 PM


avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jacqueline Rahn
Jul 05, 2017 at 03:34 PM

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.

10 |10000 characters needed characters left characters exceeded