Answer / suman vaddi

Thumbnails which will limit the data extracted from the data
source.

Thumbnails are used to test the data retreval for the
report. Insted of reading entire data base we use Thumbnails
to limit the data

Mostly Thumbnails are used for testing the report.

Answer / 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

Define the slice and dice?

0 Answers  

---

What is the difference between set functions and filter function in dimensional data?

0 Answers  

---

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

0 Answers   HCL,

---

1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?

0 Answers   Mphasis, TCS,

---

can we insert list report in corsstab report?

1 Answers   JPMorgan Chase,

---

1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports

1 Answers   CTS,

---

What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,

2 Answers  

---

1. Differebces between Merge and Union In Cognos? 2. What is With Clause In Cognos? 3. Differences between Cognos Sql & Native Sql?What are their Advantages and DisAdvantages? 4. What are different events in Report studio? 5. Create 12 columns for months by writing single case statement? 6. What is Tool Tip?

0 Answers   Wipro,

---

What is slowely changing dimensions?why we are used SCD?

2 Answers  

---

What do you understand by the term 'aggregate cache'?

0 Answers  

---

HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS

5 Answers   IBM, Virtusa, Wipro,

---

In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha

0 Answers   TCS,

---