Interested to Buy Any Domain ? << Click Here >> for more details...
in which scenario we go for views in cognos or oracle?
- 1 Answers
- 6596 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define report item?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
New coloums are added in database, then how you know in report level
How do you Parametermap variables in Quiries?
can you tell me what are the dimension tables are used in project
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What are the types of hierarchies?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What is a Framework manager?
Can you explain new content durability?
write a query to display the departments with no employee?
Tell me about Dnamic and Static Dashboards?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
What is a Query Subject?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
