TM1 Forum

Good day.

I need to create a report that shows variances between sales data off TM1 cube and what is actually in Syspro Database. My report currently shows both sets of data, each in it's own crosstab. Is it possible to somehow reference the two crosstabs in order to get a variance in a separate crosstab?. The final variance is the result I require. This can be in a separate report.

Any ideas.

regards

Allan Bulloch

Why not pull the relational data into TM1? Variances would then be very easy and fast.

Of course that's a way to pull the data into TM1, but that will be another data copy step...

If you want to avoid that, you can try to join your result queries and create a third query to show both (and the variance)

Regards

But of course, if you do it in the report, you open the door to other users doing it in the report, and then doing it differently and then giving two different answers