Table or view doesn't exit

s234

Hi Team,

I am having two dimension tables and two parent child table

And one fact table. This has been implemented and reports

working fine.

Now I am getting new fact and same dimensions and same parent child table

And same joins and report logic everything is same. Only fact

Table is different.

In physical layer I have imported new fact and joined with existing dimension tables.And have created new subject area and bmm layer designed parent child relationship.

After rpd deployment, existing report is working fine. Now I want to create same report with new fact table.

Here I am taking hierarchy(Parent child ) column and new fact table column getting error

"Table or view doesn't exist". And verified physical query in dB level it's working.

This error I am getting only one dimension table another dimension  table working fine with new fact table.

Kindly provide any suggestions.

Regards,

Sudhakar

Lukin

Hi Sudhakar,

It sounds as though the user in the Connection Pool you are using for queries is a unable to read this table. Confirm you have applied grants to this new table in the DB for your user in the Connection Pool.

Regards,

s234

Hi Lukin,

Thanks for your replay.

The issue has been resolved after changing database object features in physical layer.

The below parameter should be "check"(true)

"PERF_PREFER_MINIMAL_WITH_USAGE" 

Thanks