What is the use of 'individual data source' option while
using filter in query studio?
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
Can you define materialized view?
Can you define bitmap index?
New coloums are added in database, then how you know in report level
How the Bursting happens in same report and how to Print the bursting Report?
hi friends pls forward impropmtu interview question
How is possible this scenario using in type-in prompt.?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
What are the main services provided by application tier?
hi my name is siraj i want to know cognos queriy language
7. What is performance tuning?
How Metrics Studio is better than Report Studio?
Can you define query studio?
What is zero-foot print?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
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?