how the values be passed to prompts in report studio?
when a data item is dragged n dropped in to report, after
the default query generated first which sql will the query
query hit for processing means (native or cognos)?
plz answers to these questions?
Answers were Sorted based on User's Feedback
Answer / ch8nya
1.before executing the query.
2.first cognos sql generate
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / kumar
Hi Friends,
In Cognos We have 3 Kinds of SQL's
1) Cognos SQL --Default in Report Studio, Frame Work Manager.
2) Native SQL
3) Pass Through SQL
The Default SQL is Cognos SQL why it is It can be used to
create New Query Subjects or Edit , change existed.
it cal hold multiple data bases Query where Data Source
Query can be used for that specific DB.
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / vinay kumar
create list report drag and drop the report and genrate the query... in cognos
Is This Answer Correct ? | 1 Yes | 11 No |
What is Outerjoin?
How many fact tables you have in your project?
can we join 2 different queries? One has 10 columns and other has 5+ columns?
suppose there are 15 countries like (US, UK, ENGLAND,INDIA,JAPAN.......)i want a value prompt in the report and this value prompt should contain groups like group1(US,UK,ENG), group2(INDIA,US,UK), group3 (ENG,JAPAN,INDIA)and in the value prompt the values should be group1,group2,group3 how can we do this?
1. What is stiched Query 2. What is loop in Fm 3. Best practices in modeling in FM 4. Three types of SQL 5. Difference between pass-thro and native sql? 6. will usage of pass thro sql will improve the performance? 7. Complex problems fced in your project 8. performance tuning in reports
Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development
what use of surgate key in project
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
Why is auto-regression used in forecasting used on cognos platform?
what is report studiio and how to start it?
What is the advantage of using shortcuts?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?