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 |
What are the different types of reports present in cognos?
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?
How to publish a package by running Java Script?
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
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
How can we do the unit testing?
can we put more measure on cross tab? If so how many? How this affect the aggregation?
What are the different types of important services used in cognos?
Column level security in report
What is conditional Formatting?
Where do you set security levels for users in reports?