Answer Posted / vij
When you use thumbnails, Impromptu retrieves only the
number of rows you specify and then saves them temporarily
on your computer.
Impromptu attempts to use only the data in the thumbnail
when you run a query. If your query requires information
that is not in the thumbnail, Impromptu accesses the
database and retrieves the information required. When you
close the current report, the thumbnail is discarded.
For example, if you work with a thumbnail of 30 rows,
Impromptu retrieves the first 30 rows from the database and
then uses the 30 rows as the data source for your queries.
If you add a column to the query, Impromptu must retrieve
the new data from the database.
A thumbnail is an efficient way to test your report before
running the query against a large database.
Thanks,
Vij
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you call a store procedure within a transformation?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
What is Bitmap Index?
is there any difference between operational database and data base?if yes what r they?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
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 stitch query in reportnet?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is Online View?
What are the types of studio present in Cognos?
How can create users and permissions in cognos?
What are shortcuts? Where it can be used? What are the advantages?
What is cognos powerhouse?
------------------What is Inline Query?