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 |
How many number of cubes can we create on a single model? How can we navigate between those cubes?
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
what is the difference between list sequel and cross tab sequel?
What are all the components of Report Studio?
. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.
What is a Complex report and explain?
---------------Tell me about DWH Concepts?
in u r data u having duplicates how to fetch the latest data in our report?
How to do deployment?
in which scenario we go for views in cognos or oracle?
What is loop in frameworkmanager ?
Why cognos scenario is used?