Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of 'individual data source' option while
using filter in query studio?
- 1 Answers
- 5663 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
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
Explain is there any comparison available for cognos reportnet vs crystal reports?
How can we Maintain the Cube Security by Category level and Dimension level ?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate what is catalog and types of catalogs in cagnos and which is better? What are the types of studio present in Cognos? Can you define report item? How can I test reports in cagonos? What are all the types of indexes in Cognos? -----------With out using DrillThrough how to do Reports? What is a dimension? How can you link a query to a data container manually in
Report Studio? What do you mean by drill through report? How to generate the Catalog in Cognos?
Basically all post describing generating the Catalog from cognos impromptu .
Is there any way to generate the Catalog using Cognos Administration or Framework Manager? Synchroness
1.What are hash prompts?
Ans: Tree prompts in which hierarchies can be seen,they can
be said as hash prompts.
2.User wants to see 5 more coloums in the report.We have
package and data base,how will u implement using it in
report.?
Ans:
3.What is automatic optimization?what is optimization?what
are the properties you set for optimization in report
studio?
4.what is command to display first 10 records from a table?
IGATE
1.In FM if we change a fact symbol to attribute,will it
effect the report?
2.If a report is slow in generating output. How do u
perform tuning? How do u reduce joins in sql? Using left
outer join is it going to improve the report performance?
IBM
1.How do you configure ?
2.How do you drill through report from RS to Analysis
studio?
What is the difference between a cascading report and drill through report?
