What is conditional styling?
a.format applied based on filter
b.format applied based on user
c.format applied based on on condition
d.all the above

2. For a company X, actual revenue and budgeted revenue are
captured
in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff
levels of granularity (Fact_Act is month and budget @
quarter leve )and there is one common Time dimension, A
report is created to show the actual and budgeted revenue
2gther but the data for budgeted is wrong. Which should be
doing for rectifing the error?
a. create determinants for month and quarter
b. join the two table facts into a single fact
c. Create 2 time dimensions @ FM
d. Need to create 2 separate reports as the required info
cant be shown using a single report.


3. Template in a Query Studio?

a. sample Data set
b. CSS
c. A standard that applies for all reports
d. None of the listed options

4.you are a report author @ the Company, which sells
sporting equipment





5. Sales person in different regions each need a report
showing sales target for each country. which of the
following is the best way to distribut?
a. Email
b. Bursting
c. storing in public folders
d. All the above.

6.
I)A query subject behave as a dimensional in one query and
fact in other query.
ii) Queries with more than one fact results in stitched
query.
iii) Cognos identifies a query subject as Fact based only on
the measure

a. ii only
b. i only
c. both i and ii
d. iii only

7. what is meant by pivoting?
a. making a stacked set
b. swapping rows into columns
c. making column as filter
d. none of the above

8. A report cant be viewed in which?
a. CSV
b. XML
c. ASCII
d. Excel

9.A user wants to retriv all products which are not sold for
last X days. Which prompt is used?
a. Time
b. Value
c. Text
d. Interval

10. Dispatcher?

a.routes request to appropriate services and start services
b. routes request to appropriate services
c.starts all service
d. none of the abv


Frenz Please help me out !!! :) Thanks in Advance

Answer Posted / pooja

1. c
2. a
3. d
5. b
6. a
7. b
8. a
9. b
10. b

Disclaimer: This posting is provided AS-IS with no
warranties or guarantees and confers no rights.

Is This Answer Correct ?    6 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Transformer?

741


What is difference between informatica power mart and power center?

647


How can I schedule reports in cognos?

671


How to select multiple values from type-in prompt?

737


WHAT ARE THE DISTNICT VARIABLES?

1856






What is model?

643


how to perform back drill through in cognos 8 what is the use of it

2138


5. Which type of report you build more, list, crosstab or chart and why?

1681


What are the themes in a data warehouse?

670


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2233


Why cognos decision stream is used?

757


what is the role of cognos comsultant?what actually it means?pls reply

1963


Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

1779


How can we Maintain the Cube Security by Category level and Dimension level ?

2040


what are the filters in framework manager and report studio?

677