What is the use of 'individual data source' option while
using filter in query studio?



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

Post New Answer

More Cognos Interview Questions

What are the roles defined by cognos platform?

0 Answers  


how u will determine the performence tune will occur either in report or system

0 Answers   Ness Technologies,


Can u solve a small query on table the problem is whether it is possible to add extra cells for already existed table i.e if table contains 3 rows n 4 cols (3*4) it is possible to add another cell (4*4)

1 Answers  


How can we find out cardinality between two tables?

3 Answers   IBM,


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

0 Answers   IBM,






----------------What is Scopr Relationship?

1 Answers  


how to merge 2 crosstabs thans

0 Answers   HCL,


how u publish the packages in framework manager

3 Answers   TCS,


What is the difference between Conditional Layout and Conditional Block

1 Answers   TCS,


Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?

2 Answers   Mphasis,


faq's on cognos

0 Answers  


Define dimensions?

0 Answers  


Categories