Interested to Buy Any Domain ? << Click Here >> for more details...
Can we create reports using OLTP database?How?
- 3 Answers
- 12266 Views
- I also Faced
- E-Mail Answers
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 |
I have four region(Us, Uk, Canada, Europe) in my value prompt. Along with this I want new prompt called All. Once I click on All it should display all regions data. How can I achieve this ?
How many types of models are present in cognos.?
What r the names of the reports that you prepared?
write the sql query to display 5th and 10th row in a table?
Can you define framework manager?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Explain informatica architecture?
what is model and how to create model and how to test model?
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.
write a query to display to 10 max record from the employee table?
Teradata 
