Identify the respsective .mdl and .mdc file

[Vishnu Priya]

Hi,

I am new to Cognos Transformer and working on some stuffs with it. I found that there is a .mdc (cube file) and a .mdl(metadata file) for each Powerplay transformer cube. But the problem is the file names for the same cube can be different. That is, for a transformer cube A there can be .mdl file with a different name. So I'm not able to map the cubes with their corresponding .mdl files.

Is there any way I can find them and map them respectively? Please correct me if I am wrong somewhere.

[MFGF]

Hi,

I am new to Cognos Transformer and working on some stuffs with it. I found that there is a .mdc (cube file) and a .mdl(metadata file) for each Powerplay transformer cube. But the problem is the file names for the same cube can be different. That is, for a transformer cube A there can be .mdl file with a different name. So I'm not able to map the cubes with their corresponding .mdl files.

Is there any way I can find them and map them respectively? Please correct me if I am wrong somewhere.

Hi,

When you open an mdl file in Transformer, you can see the cubes it generates down in the bottom right corner in the PowerCubes area - a model may actually have multiple cubes generated from it. You can go into the properties of each of the cube definitions in that dialog and see the name and path of the mdc cube file it will generate on the Output tab.

Cheers!

MF.

[Vishnu Priya]

Thanks for the immediate reply MFGF. That was useful. Is there any way to know the Cube Name (that generates in the Output tab in the Properties of the cube in Transformer) from the .mdl file directly without opening the file in Transformer.

[MFGF]

Thanks for the immediate reply MFGF. That was useful. Is there any way to know the Cube Name (that generates in the Output tab in the Properties of the cube in Transformer) from the .mdl file directly without opening the file in Transformer.

Hi,

No, not one I'm aware of. As I mentioned above, a single mdl can be used to generate multiple cubes with different names, too. It isn't necessarily a 1:1 relationship between a model and a cube.

Cheers!

MF.

[Vishnu Priya]

Hi,

Thank you for the info. That was really a good point to keep in mind in future working

[czg]

Open the MDL file in a text editor and search for MdcFile to find the names of the MDC files that it creates.

[Vishnu Priya]

Thank you so much @czg. This is what I was looking into. Thank you once again for the answer.   :D