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 / 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 |
what are determinants?
4 Answers College School Exams Tests, IBM,
What are the considerations regarding performance kept in mind while setting up cognos?
what is stitched query???
How to publish a package by running Java Script?
what is your project workflow and your role in the project?
whats the difference between previous version of cognos and cognos 8 BI?
If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?
what is the difference between list sequel and cross tab sequel?
2. What is With Clause In Cognos?
What is meant by drill down?
Why we should go for cognos? when there are so many other BI(Reporting) tolls in front of us?
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha