What are the different ways of adding data in Transformer?
Answers were Sorted based on User's Feedback
Answer / chitwan humad
I think you can add data by-
1. iqd(s) (Most commonly used)
2. reports
3. Flat files/Excels
etc.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / arun
in transformer u import metadata from architect or catalog
to create a cube. we just imprt metadata. we dont add data
to it
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / reddaiah
There are difference ways to add data in cognos transformer.
1)IQD(Impromptue query definitation)
2)packages
3)Reports
4)import metadata from database.
5)Excel files
6)delimited files
7)MS-Access ete.
| Is This Answer Correct ? | 2 Yes | 1 No |
HI,can one suggest best institute for cognos Training in Hyderabad
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
where you can save the report net documentation in our local system?
how you create security to reports?
Wt is the Diff between Business Key & member caption?
What snowflake and Starschema?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
Define query items?
How the Bursting happens in same report and how to Print the bursting Report?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
write the sql query to display 5th and 10th row in a table?