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 |
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
what is dynamic sort?
In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?
What is set to be cardinality?
How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.
what is report burn and where it occurs
What is snapshot ?
What are the services provided in cognos 8?
Hi,please suggest me how to creat username while creating a report.
In an existiing Framework model, how will you add a new column to the existing table?
data import to models, datastores,stored processed, is there any other way to import data?
what are the types of facts ? explain them?
2 Answers Business Objects, Informatica, Syntel, Teradata,