Proper use of TM1 / DMR in an Active Report in Cognos 11

[Marvin Falentin]

Hey everyone,

I'm trying to mix a TM1 and a DMR for a crosstab in my active report. Using the DMR source works fine but I can't use anything from the TM1. Whenever I try to do that the report just stops "rendering" before finishing (meaning the little gear stops spinning when you press the create report button). Attached you can find a screenshot of my Problem.

What I found really frustrating is Cognos not giving me a error message no matter how often I let him run the report although I had three different error messages at some point:

when I use the DMR in a blank active report it gives me this one  "XQE-GEN-0002 An unexpected Expression has occured Error retrieving Default member. Hierarchy: ..."

At some point I got this message "XQE-GEN-0010 Interner Fehler gefunden: 'Failed to create metadata wrapper.'."

I had a third one that I can't remember but it hasn't occured ever since.

I'd really appreciate some help here because I'm really unfamiliar with using a TM1 in my reports (still new to Cognos BI if you guys remember me showing up 2 months ago :) )

Kind regards,

Marvin

[MFGF]

Hey everyone,

I'm trying to mix a TM1 and a DMR for a crosstab in my active report. Using the DMR source works fine but I can't use anything from the TM1. Whenever I try to do that the report just stops "rendering" before finishing (meaning the little gear stops spinning when you press the create report button). Attached you can find a screenshot of my Problem.

What I found really frustrating is Cognos not giving me a error message no matter how often I let him run the report although I had three different error messages at some point:

when I use the DMR in a blank active report it gives me this one  "XQE-GEN-0002 An unexpected Expression has occured Error retrieving Default member. Hierarchy: ..."

At some point I got this message "XQE-GEN-0010 Interner Fehler gefunden: 'Failed to create metadata wrapper.'."

I had a third one that I can't remember but it hasn't occured ever since.

I'd really appreciate some help here because I'm really unfamiliar with using a TM1 in my reports (still new to Cognos BI if you guys remember me showing up 2 months ago :) )

Kind regards,

Marvin

Hi,

Are you trying to generate a single crosstab object from both TM1 and DMR? If so, this isn't ever going to work. You can create a crosstab from each source side by side on the same page, but you can't mix content from both in the same reporting container (crosstab/chart/map etc).

Cheers!

MF.

[Marvin Falentin]

Hey MF,

thank you for your replay I knew I could Count on you on this topic :) attached you can find a screenshot of what I want to achieve.


So I want to create a crosstab showing me the difference between the value of TM1 and DMR for the current month. It doesn't matter if it's TM1 - DMR or DMR - TM1 because when the difference isn't 0 the colorcode will show bright red signaling a data mismatch.

Does this help you understand what I'm looking for?

Marvin

[MFGF]

Hey MF,

thank you for your replay I knew I could Count on you on this topic :) attached you can find a screenshot of what I want to achieve.


So I want to create a crosstab showing me the difference between the value of TM1 and DMR for the current month. It doesn't matter if it's TM1 - DMR or DMR - TM1 because when the difference isn't 0 the colorcode will show bright red signaling a data mismatch.

Does this help you understand what I'm looking for?

Marvin

Hi,

The easiest way I can think of to deliver this is to create a list within a list. The outer list can contain the DMR data, and the inner list the TM1 data. You can create a master-detail link between the lists, but to do this the captions of the members need to match, and you need a calculation in each list to extract the caption of the month member - you then use these calculated items as the link in the master-detail relationship.

Cheers!

MF.

[Marvin Falentin]

Hey MF,

thanks for the advice! I'll try it once I got some time to work on that topic.

Would it maybe be easier to just hang the original Excel Report into our Active Report?

Kind regards,

Marvin