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
how to perform back drill through in cognos 8 what is the use of it
what do u mean by bridge group? where we r using this one?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
faq's on cognos
i was asked what are the caluclations done by you in your report? plz give reply
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Define the slice and dice?
can we insert all types of charts in a list report? what r the realtime prompts?
What is the complex report you faced in real time?
What are the advantages of using cognos sql?
---------------Describe OLAP Reporting and RDBMS Reporting?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
Why is auto-regression used in forecasting used on cognos platform?
-------------How you design DWH?
