Can we create reports using OLTP database?How?
- 3 Answers
- 11204 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 |
Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!
How create measures and demensions?
Can you define snapshot?
Whrer u can save the Report net documentation in our local system?
I want to schedule the report as sysdate-1.....how to do
suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me
we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer
explain how to create powerplay reports?
what is the difference between filter and condition?
what is prompt types of prompt example briefly each types of product (eg:values, date,search,prompt etc.)
Mention the difference between ‘macros’ and ‘prompt’?
What is Report item
Teradata 
