How many fact tables and dimension tables in your project?
Answers were Sorted based on User's Feedback
Answer / c h i t t i
Depend on project, for ex. mostly fact tables 1 or 2 and
dimensional tables infinity.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / nasa
In my project fact tables are 5 and dimension tables are 36
and team size is 12 and duration is 16 month and i developed nearly 80 to 990 reports in my project and my client is australia....
| Is This Answer Correct ? | 3 Yes | 0 No |
what is an outer join? difference between left outer join right outer join with an example?
Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!
HOW MANY LEVELS CAN BE USED IN DRILL THROUGH REPORTS
5 Answers IBM, Virtusa, Wipro,
What is meant by alternate drill down with ex?
What is the difference between drill through, drill across?
what is a prompt value in report studio and variables ?
how many types of keys are there i.e primary key and foreign key etc..?
Explain difference between powerplay transformer and power play reports?
Can you define bitmap index?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
where exactly determinants are used in cognos framework manager?
what are versions of cognos from starting release to latest in the market?