Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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.

    Add comment
    10|10000 characters needed characters exceeded