Using TM1 numeric attribute in a BI Report calculation

[tsw]

Hi,

I'm having some issue displaying a calculation based on a TM1 numeric attribute in a BI report crosstab.

Does anyone have an example of a calculated measure in a crosstab report based on an TM1 attribute?
Basically, I have a 'Days in Month' attribute in TM1 dimension and I want to use it in a data item or calculate measure, I can't seem to get it to display correctly in a crosstab cell.
If I run view tabular or use a list box, it will show.

Help?

[dan.kelleher]

Would it not be better to calculate the measure in TM1 via a rule? BI is generally not very good (poor performance) when accessing dimension attributes directly.

[tsw]

Hi Dan,

Actually the measure is dynamic based on range of time user enters, so I think it's better to calculate real-time in BI.

My workaround right now is to use TM1 rule to set a measure equal to the Month's Days in Month attribute... so that BI sees it as a measure so I can do some calculations.
However, this workaround eats up unnecessary memory on the TM1 side.
So still looking to see if anyone has done a calculated measure based a TM1 attribute on the BI side.

Thanks!

[tsw]

Would it not be better to calculate the measure in TM1 via a rule? BI is generally not very good (poor performance) when accessing dimension attributes directly.

btw, I didn't see any performance issue accessing the attribute... just couldn't display in crosstab... I'm on 10.1.1 TM1 and 10.2.1 BI.