sdutta
New Member
Good Afternoon,
I'm trying to expose a OE created view to our reporting tool in Cognos. I would like to know if it is possible to do so. I've noticed that I can create the view through the procedure editor but I am unable to do for each queries on it. However, I can do SELECT queries on it through the procedure editor.
I also tried to expose this view to ODBC utilizing sqlexp command that comes with OE but am getting an error stating that Table/View/Synonym is not found. Any ideas? Thanks.
I'm trying to expose a OE created view to our reporting tool in Cognos. I would like to know if it is possible to do so. I've noticed that I can create the view through the procedure editor but I am unable to do for each queries on it. However, I can do SELECT queries on it through the procedure editor.
I also tried to expose this view to ODBC utilizing sqlexp command that comes with OE but am getting an error stating that Table/View/Synonym is not found. Any ideas? Thanks.