Hi
Can someone help me to identify why we normally use oracle views instead of table while Cognos modeling ?
I guess it is due to security reasons and its best practice.
If you have any link stating this would be helpful.
Quote from: R Ambre on 19 Jul 2016 05:22:25 AM
Hi
Can someone help me to identify why we normally use oracle views instead of table while Cognos modeling ?
I guess it is due to security reasons and its best practice.
If you have any link stating this would be helpful.
Hi,
It isn't best practice to use views rather than tables in your model - or vice versa. You use whichever is appropriate. You will need to ask internally within your organization to establish the reason you are doing this.
Cheers!
MF.