how many facts and dimensions in ur project and query
items,how u deliver ur report to end users..i am going with
fake exp...pls ans me generally what to ans..
Answers were Sorted based on User's Feedback
Answer / ramu
Facts & Dimensions are depends on the project, requirement,Client,.etc.In that scenario you need to 15 Dimensions, 5 facts(That's for general project)
& Coming to delivery method,this is not your part . as a report developer you may develop reports then save it in Public folder that's it.
| Is This Answer Correct ? | 6 Yes | 2 No |
how to create measures and dimensions?
explain how to create powerplay reports?
I have Date,product,Quantity_Sold columns and I want Product, MTD(month Till date),YTD(Year Till Date) as output. Can anyone help me with the logic in getting MTD i.e quantity sold from 1st of this month to till date (i.e. 01- 11-2013 to 26-11-2013) and YTD i.e QTD sold from 1st date of the year to till date(i.e. 01-01-2013 to 26-11-2013). Sample output model: Product MTD YTD
Please answer me the below questions, It's really urgent, and ur help would be appreciated. 1. What is looping in FM? How do u control it 2. How do u create IQDs in FM? Explain 3. What are the diff u noticed between Cognos 8.2 and Cognos 8.4 4. Can we use cube as a data source? How 5. How do u connect ur database in FM? do u connect directly 6. What's the structure of your database? Say u use Oracle 7. Did you use tables or views to bring the data from your DB 8. Does the dimensions of analysis studio have hierarchy? 9. Did you create any dashboards? How u created, explain
Can u please describe the different types of traps with eg. Thanks
Create 12 columns for months by writing single case statement?
Can you define transformer?
1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question
how to test reports in cognos?
Can you explain a cognos controller?
what is requery in cognos?
What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?