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 / 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 |
What do you mean by query studio?
How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?
1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.
How to select multiple values from Type-in prompt? Example - I want to enter into type-in prompt in 'Product name--- Liza' display report data in 'product name is Leza' only OR I want to enter into type-in prompt in 'All', that time display report data in all are report data. How is possible this Scenario using in type-in prompt.
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
suppose a value prompt contains 100 values and i want to select all values in that prompt....i want ALL option in the value prompt? how can u keep this option in value prompt?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
Define query studio?
How can you create prompts in framework manager?
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,
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
How to schedule the report twice in a day?