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 |
-------------What is Coditional Prompting?
what is the difference between filter and condition?
Hi Guro's How to give give one space for every 5 rows in a crosstab report in cognos
Tell me about Schemas?
what are the features in cognos8ui
wHAI IS THE DIFFERENCE BETWEEN LIST REPORT AND CROSSTAB REPORT?
Can you define cognos impromptu?
Where do you edit cognos sql in report studio?
8. Can you use calculations in report headers and footers? How?
Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....
write a query to display to 10 max record from the employee table?
How you create IQD In ReportNet FrameWork?