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 |
write the sql query to display 5th and 10th row in a table?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
difference between impromptu and cognos8
What is called cognos reporting tool?
----------0Diff b/w Report Functions and Database functions?
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
What is the difference between a data mart and a data warehouse?
-------------------What is Deployment?
What you mean by drill across?
What is the difference between drill through, drill across?
if there are list,crosstab,chart how can you apply a single filter to all object?
---------------Tell me about DWH Concepts?