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
Quote from: Marvin Falentin on 30 May 2017 06:26:41 AM
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.
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
Quote from: Marvin Falentin on 01 Jun 2017 07:49:40 AM
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.
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