Answer Posted / k naveen kumar
View is mirror image to the base table(main table) i,e it is
a logical pointer to the base table.
for the view it does not occupy space for the data but it
occupy space for the structure
Two types of views
1) simple 2) complex view
simple view created on single table
complex view created on multiple tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the themes in a data warehouse?
i was asked what are the caluclations done by you in your report? plz give reply
Can you explain model durability?
What do you mean by drill through report?
What are the advantages of cognos?
What is called a slice?
How to do Performence Tunning in Cognos Reports?
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.
------------- How to identify the Revenue Column in Report?
How is cognos model organization works?
What are the methods by which it non-durable model could be changed into the durable model?
how you create security to reports?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What do you mean by Drill down and Drill Up?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?