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