Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cognos my friend ;-)

Status
Not open for further replies.

msgdetlev

Programmer
Aug 19, 2003
1
EU
Hello,

I try to understand how Cognos works.
Is there anybody who can tell me how Cognos creates the .mdc (multidimensional cube)File. Where can I find it ?
Is it also created if the creation of the Cube failes ?
Which Files are nessecary for Cognos to build the .mdc File ? How can I get the sQL statements which together build the mdc-File ?

ther is a functionality called drill-through, it means to create a kind of view as it is known from oracle.
this mechamisem builds a button in the cube. By pressing the button the user gets the Data frm the area which is connected to the button.
please conn any body tell me more about it, which proceses are running ? which programs are nessecary ? which Files are build for the Button ? ... I want to know nearly all about it ;-)

Perhaps you can tell me a link to an documentation in which I can study it.

special Thanks for your answers !

Detlev
 
First the transformer reads data as defined in the SQL in the iqd files which are defined as datasources. When it has read the data it creates temporary workfiles (categorie workfile and a "measure" workfile). In one or more swaps (depending on the partitioning settings) these workfiles are used to create or update the mdc file.
When drilling through to a impromptu report it uses the SQL code stored in the imr file with added (a) filter(s) for the filtering on categories defined as filter in the cube.

Regards,

Menno
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top