Interested to Buy Any Domain ? << Click Here >> for more details...
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 do you understand by the term 'dynamic cube'?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
Can you define query studio?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
How do you improve the performance of the Cognos Analytics report
What is the report studio?
Why need staging area database for dwh?
What is defined as catalog and types of catalogs in Cognos?
how to explain health care project and which reports we can create in health care doain?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What is difference between informatica power mart and power center?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What are all the different types of prompt in cognos?
---------------Tell me about DWH Concepts?
What is looping and how to avoid it in framework manager?
