in which scenario we go for views in cognos or oracle?
Answer / vanthian
As far as I Know
Oracle views are nothing but the virtual copy of the table.
the only differnce is we can't alter the table structure
(i.e) we cant perform the insert,edit delete operations for
the table..once we are using the oracle views in cognos
whenever a new dataitem is added to the existing table
then the view will be updated using the Create or Replace
option and the view will be deployed once again so that the
new dataitem will be added to the view
Consider a scenario,in which the Datamodelling team will
design or create the tables and they deploy the views for
the tables
The Cognos team will then use the views as the Source for
their tables and they create Packages using the views
Is This Answer Correct ? | 6 Yes | 0 No |
What is an olap designer?
Explain about Parametermap?
Can you define confirmed dimension?
hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.
Define datastores in cognos?
suppose if u burst the reports if ur reports not reached to the destination how u will identify that one???
What is the size of the cube?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
7. What is performance tuning?
How to apply securities for reports in cognos connection?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is the report studio?