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?
- 3 Answers
- 7949 Views
- TCS, Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How do you Parametermap variables in Quiries?
What is set to be cardinality?
What is metric store database?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
how to connect datamarts
Can you explain dynamic query mode?
What are the advantages of shortcuts?
What is a dimension?
what is degenerate key in oracle ?whare do we use it?
When we save a report in report studio with what extn it save?
Can you explain cognos planning?
What are the steps to import the two data sources in framework manager?
What is the use of report studio?
What do you understand by the term 'dynamic cube'?
