What is the use of 'individual data source' option while
using filter in query studio?



What is the use of 'individual data source' option while using filter in query studio?..

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.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

How applying "Level Span" in Cognos 8.3?

1 Answers  


what is meant by roll up and roll back in dataware housing????

4 Answers   Covansys, IBM, Wipro,


How we check the errors before running the report,plz let me know the answer

4 Answers   TCS,


What is the difference between Open Connection command ang Open Session Command?

0 Answers  


Define the cognos reporting tool?

0 Answers  






Can any one expalain the procedure for How to create a Mastr Detail Report in Cognos 8.3 ver?

1 Answers  


What are types of batch available in cognos?

0 Answers  


if at all asked.wat is u r cube name?wat would be a appropriate answer? plz help me

2 Answers   WNS,


--------------Diff b/w ODS and OLAP?

0 Answers   Bank Of America,


Hi Cognos Experts,I am Having DatePrompt In My Report.I want to display The Report Between Twodates Like jan-SEP How can We Achieve This one?PLS Expain Me With Ex:

3 Answers  


What are links & Segments in Cognos Framework Manager?

1 Answers   Systime,


how to explain health care project and which reports we can create in health care doain?

0 Answers  


Categories