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 is the difference between Open Connection command ang Open Session Command?
How to apply securities for reports in cognos connection?
What is main advantage datawarehousing over oracle?
Why cognos decision stream is used?
Why are meta service important then other services?
What are the advantages of cognos?
What do you understand by user class in cognos?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
what is a prompt value in report studio and variables ?
What is the model filter?
What do you mean by query studio?