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 a query subjects item?
How will you migrate your reports to QA environment?
Give me some examples for Lifecycle reporting,i mean which lifecycle we will use for reporting
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
in which scenario we go for views in cognos or oracle?
What are the components used in web tier?
Can we test the report other than manual testing?
I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos
How to create users and permissions in cognos?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?