Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What are the different types of reports present in cognos?

0 Answers  


How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?

1 Answers   Mind Tree,


How to publish a package by running Java Script?

0 Answers  


What are the steps involved in migrating CRN enviroment to Cognos 8?

3 Answers   BMW, Goyal Group, Mersan,


we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer

4 Answers   IBM,


what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

0 Answers   Cognos, IBM,


How can we do the unit testing?

3 Answers   Logica CMG,


can we put more measure on cross tab? If so how many? How this affect the aggregation?

4 Answers  


What are the different types of important services used in cognos?

0 Answers  


Column level security in report

4 Answers  


What is conditional Formatting?

2 Answers   HCL,


Where do you set security levels for users in reports?

5 Answers   HCL,


Categories