What is the use of 'individual data source' option while
using filter in query studio?
Answer Posted / 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 View All Answers
What are cognos connection initial page components?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
How the Bursting happens in same report and how to Print the bursting Report?
what are the names of the reports that you prepared?
--------------Explain Table of contents?
What is Additive function?
What are all the advantages of Cognos?
What are all the components of Report Studio?
Write various indexes used in cognos?
What is the difference between set functions and filter function in dimensional data?
What is the size of the cube?
What is a Transformer?
Can you define metrics designer?