1.how do nyou configure link between fwm and database
(source).if you created fwm where it will be? and if you
create reports where it is stored?
2.what is spic shot in fwm?
Answer Posted / karna
1. To create link between FWM and DB(Source)
Open FM-->File-->New Project-->it will ask you to select
DATA Sources..we can select new DS to create or existing to
connect.If you select 'new' it will ask for type of ds
(Oracle,sybase) and click next then give Connection string
and userid/pw .then test for connection.if the connection
is succeeded.connection is established between model and DS.
2. Once model is created..it will be stored under projects
in location where C8 is installed.
(eg) if your modelname is 'sample' then it will be stored
as 'sample.cpf'..C:\Program files\C8\samples..
3. I you create reports..it will be stored as specification
in .xml file.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
Define report item?
Which studio is used to create reports?
What is Fullouterjoin?
What are all the advantages of Cognos?
Please explain the different stages in creating a report in cognos report net?
How to join multiple db in catalog?
What is model?
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?
How do you call a store procedure within a transformation?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What DB View and Bus View?
What are the advantages of using cognos sql?
Explain the different types of views used in cognos.
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What are the other methods working as deployment functionality?