cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member193452
Active Participant
0 Kudos

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.