Answer Posted / rupanjali
1)Analyse all the tables ,columns & joins required for ur
Cubes.
2)in Impromtu drag all the tables,columns .abd give their
join.and form the catalog.If any loops then resolve the
loop.
3)Then generate a impromtu report by taking all the catalog
columns.and save this as .iqd extension.
4)This .iqd file will be the input for our cubes.
5)Then open this .iqd file in tranformer.where you will
create heirarchy for dimension and define the measures.
6)Save it as .pyi files.
7)Run the .pyi files.
8)When the cube is generated save it as .mdc format.
9)This is the cubes.
10)You can open the .mdc file to create your cube report
(multi dimensional) in transformer
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the roles defined by cognos platform?
What are the different kinds of panes included in cognos?
How do you Parametermap variables in Quiries?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
what are the dimensions that you have in your current project?list them?
in u r data u having duplicates how to fetch the latest data in our report?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
What is the use of powerhouse?
What is the difference between regular dimension and derminant?
What are the themes in a data warehouse?
what is model and say about process how to create model and how to test model?
What is zero-foot print?
What is the difference between Open Connection command ang Open Session Command?
What are the main services provided by application tier?
What are the types of hierarchies?
