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


Please Help Members By Posting Answers For Below Questions

Define metrics studio?

774


-------------What is Coditional Prompting?

1809


actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....

1458


What is defined as Cognos Impromptu?

828


What are the types of security?

768


What is meant by alternate drill down with ex?

813


Can you define cognos powerplay?

838


What do you understand by the term 'aggregate cache'?

745


What is the difference between Open Connection command ang Open Session Command?

2128


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

1825


Can you define cube?

775


Explain is there any comparison available for cognos reportnet vs crystal reports?

745


what do u mean by bridge group? where we r using this one?

1726


What are the roles defined by cognos platform?

811


what is the procedure for scheduling conditional rendering?

2250