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 are the roles defined by cognos platform?
how u will determine the performence tune will occur either in report or system
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)
How can we find out cardinality between two tables?
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?
----------------What is Scopr Relationship?
how to merge 2 crosstabs thans
how u publish the packages in framework manager
What is the difference between Conditional Layout and Conditional Block
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?
faq's on cognos
Define dimensions?