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 is the model filter?
how to merge 2 crosstabs thans
1. Explain your project.
What is a Datastore in Cognos?
Explain the characteristics of cognos?
What are the advantages of shortcuts?
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
Explain what is the difference between microstrategy and cognos reporting tool?
What is difference between content store and content manager?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
Explain about scorecarding?
difference between impromptu and cognos8
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
in u r data u having duplicates how to fetch the latest data in our report?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?