Answer / sathish

Hi,
Dimensions table is something that is called by the fact
table, so if you take the star schema for example the fact
is the center of the star schema and dimensions are like
the wings like of things,

so fact are usually the only one, the dimensions might vary
depending upon the requirements and needs'

feel free to contact any queries,
sathishcnpt.938@gmail.com

Answer / pooja

Multi fact models exist as well. And number of facts and
dimensions depends on the model.

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

1 Answers  

---

what is dimention?explain dimentable with example?

3 Answers   Syntel,

---

How to do deployment?

5 Answers  

---

What are the considerations regarding performance kept in mind while setting up cognos?

0 Answers  

---

How to improve the performance of the report at the report level?

3 Answers  

---

---

what is online view?

0 Answers   HCL,

---

what is reprompt?

3 Answers   TCS,

---

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

0 Answers  

---

What is slicer & dicer ? what is sub session parameter ?

2 Answers   Cap Gemini,

---

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

0 Answers   Satyam,

---

I need to display blue color for max Revenue and red color for min Revenue by using condition formatting how it possible........?

1 Answers  

---

is it possible to display the column names in first page but not in remaining pages i.e if a report contains 10 pages column names should be displayed in 1st page but not remaining pages ( 2 to 10)

2 Answers  

---