1)Analyse all the tables ,columns & joins required for ur Cubes. 2)i

How to crate cubes in transformer ?

Question Posted / rupanjali

3 Answers
9589 Views
I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What are all the advantages of Cognos?

972

I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

2222

4. How many dimensions did you use in your reports?

1891

Define metrics studio?

978

What is catalog and types of catalogs in cagonos and which is better?

930

can you tell me what are the dimension tables are used in project

2251

hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1847

What you mean by drill across and what is the difference between drill through, drill across?

970

explain how to create powerplay reports?

954

Can you define folder?

914

what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

971

i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?

1933

What are the advantages of shortcuts?

911

how to perform back drill through in cognos 8 what is the use of it

2466

What are the ways to import data into catalog?

1020