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 |
write a query to display to 10 max record from the employee table?
what are the components having in the report studio using interface eg:insertable objects pan,properties pan
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
Mail me at: Amit_Cog@yahoo.com for a Very latest COGNOS 8 Certi Dumps like COG-112, COG-122, COG-125, COG-132, COG-142, COG-145 I scored Full Score, if anyone need it, just drop me a mail with Code
What are all the components of Report Studio?
Can you explain model durability?
This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,
What is the difference between Open Connection command ang Open Session Command?
What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....
wat is bus schema?
Hi, How the relations will be exists in DMR models if u have any idea please explain me
what are determinants?
4 Answers College School Exams Tests, IBM,