Answer / shweta

When we use individual data source, it means we are applying
filters over the values in the DWH directly before they are
brought to cache. In the cache the values are summed up. so
it will apply the filter before summing up the value.
Eg.
Suppose we are creating a report
Product Quantity
Lux 50
Pantene 60

In the main data base these values are
Lux 10
lux 15
lux 15
lux 10

so wen we are using individual data source the filter will
work on the main data base value and not the summed value
that we bring to the report from cache.

Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder

0 Answers   IBM,

---

how to do page breaks in cognos 8 Report studio pls give the navigation

4 Answers  

---

Explain what is the main advantage of impromptu over cognos reportnet?

0 Answers  

---

what is the automation tool used for data warehouse testing???

3 Answers   Covansys, IBM, Wipro,

---

what is sdibling function tell me the some functions

3 Answers   IBM,

---

what is cube size?

4 Answers   IBM,

---

11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance

1 Answers  

---

how to perform back drill through in cognos 8 what is the use of it

0 Answers  

---

--------------Explain Table of contents?

0 Answers   Cap Gemini,

---

what is the use of macros&folders&herarchies in frameworkmanger?

1 Answers  

---

17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?

3 Answers   TCS,

---

what r the filters in fwm and report studio

6 Answers   TCS,

---