Can IA see views (versus physical tables)?

truenorth · Post by **truenorth** » Wed Oct 20, 2010 1:16 am

We created views of tables but when I try to import metadata, the views are not available. Is IA only able to work on physical tables only?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 20, 2010 2:48 am

There should be no problems with views. Have you granted SELECT privilege to the view for the IA user?

tcj · Post by **tcj** » Wed Oct 20, 2010 4:14 pm

I can confirm that IA can see views.

truenorth · Post by **truenorth** » Sun Oct 31, 2010 3:56 pm

Thanks, guys.

The DBA had checked and confirmed we have SELECT permission on the views. But IA still could not see them.

RESOLVED: In Set Pre-filter, I had to Include Views, which is off by default.