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..

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

1711


difference between impromptu and cognos8

1957


Explain difference between powerplay transformer and power play reports?

530


What is meant by junk dimension?

554


1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

1754






What is a Pivot?

533


How do you call a store procedure within a transformation?

539


What are the types of folder present in cognos?

626


i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1540


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

1589


What is the use of cognos decision stream?

648


is cognos 7 is better than cognos 8

1679


Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2128


Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?

1635


What are the batches and it’s details?

553