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 |
faq's on cognos
How to upgrade drivers in Cognos 8?
Write some methods to apply securities in framework manager model?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What are the types of security?
How do we convert from Numeric to be Words?
What are differences between Reporter report and Explorer report?
What is Regular Dimension and Measure Dimensions and Diff b/w them ?
Explain the different stages in creating a report in cognos report net?
There are some reports,we have to provide security to that reports like the hr manager should have access to hr department reports only and the accountant should have access to accounts reports where as the CEO can have access to all the reports. How to deal with this situation using Cognos?
In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.
4 Answers Accenture, HCL, IBM,
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha