Interested to Buy Any Domain ? << Click Here >> for more details...
what is dimention?explain dimentable with example?
- 3 Answers
- 9476 Views
- Syntel, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunitha
Dimensions are categories by which summarized data can be
viewed.
A dimension table is a table that contain summarized
data and historical data.The dimension table has foreign key
- primary key relation with fact table.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / palzkumar
Dimension Table is a table which contains categories and
hierarchies with lowest granule.
Data stored in dimension are nothing but the masters.
Its doesn't store any numeric value or summerised data.
eg.
Product dimension
Customer dimension
Channel dimension
Time dimension
etc..
Time dimension will have the foll records..
Year > Quarter > Month > Week > Day
-------------------------------------
2009 > Qtr-02 > Aug > 35 > 04-sep-08
2009 > Qtr-02 > Aug > 35 > 05-sep-08
2009 > Qtr-02 > Aug > 35 > 06-sep-08
rgds
palz
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / palzkumar
sorry...
pls read date aug i/o sept
Time dimension will have the foll records..
Year > Quarter > Month > Week > Day
-------------------------------------
2009 > Qtr-02 > Aug > 35 > 04-aug-08
2009 > Qtr-02 > Aug > 35 > 05-aug-08
2009 > Qtr-02 > Aug > 35 > 06-aug-08
| Is This Answer Correct ? | 1 Yes | 4 No |
---------- Purpose of Factless Facttable?
What are the components of the report studio?
what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??
What are the steps to create DMR model in FM? Give me brienf discription as interview point of you?
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
first of all i want say thanks to Zilanibasha, As u said that now these days Cirtification in cognos8 is only possible. Will u like to tell me in detail How i apply for cirtification As i m very much Interested.
Where in report Studio's property pane can I find NoDataHandler?
What are all the types of gateway used in Cognos?
what are the filters in framework manager and report studio?
actually we are migrating one project to ACTUATE business intelligence solution to COGNOS REPORTNEt? why the client want to migrate from ACTUATE to COGNOS REPORTNEt? what are the special features in COGNOS REPORTNEt?
Explain difference between powerplay transformer and power play reports?
What are the components required for the application tier?
Teradata 
