Can we create reports using OLTP database?How?
Answers were Sorted based on User's Feedback
Answer / m.upendra raju
yes we can create reports using OLTP databases.But the
thing is we need to import tables into framework manager
and create a model and package and publish that into Cognos
portal for report authors to create reports in report
studio and query studio.
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / vinod kumar reddy
we con't create reports from OLTP databases, but we can
import query items from data source it means with out
modeling, it is possible in cognos 8.
Is This Answer Correct ? | 0 Yes | 4 No |
how to find the rank in report studio? i need steps for this question.
How do add dynamic titles in PP?
What is the size of the cube?
What are the message flows?
1.How will u link a list to crosstab.?i.e link a pramater in list so that it shows further information in cross tab.? 2.I have different regions,I want region specific logo to be displayed when I run the report.How it is done ? 3.Among Drill through and Master detail relationship which is more effective? 4.How do u hide a column in list report? Ans: In properties,Burn list option-check whichever column u wanna hide. 5.What is Roll play dimension? 6.What is Data Item Value n Parameter value?,What exactly it ll take when select either of them? 7.How many types of filters are there? 8.What will happen if u use detailed filter ?,n what is da result when used on summary filter?
What is a Query Subject?
What do you understand by the term 'aggregate cache'?
can you tell me what are the dimension tables are used in project
What are all types of Batches?
what is the difference between count and running-count functions?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Can you define materialized view?