TM1 10.1 - Trace Calculation behaviour

Post Reply
AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

TM1 10.1 - Trace Calculation behaviour

Post by AnthonyT »

Afternoon all

I am doing some parallel testing of TM1 version 10.1 against 9.4 (both 64bit)

I have found some calculation differences, and fully expected them to be down to the volumes of data that I am working through, but I have stumbled upon something odd

When I try to right-click on a calculated value in my view in 10.1 the "Trace Calculation" and "Check Feeders" options are greyed out - but both are present in 9.4. The views I am checking are identical, and the calculated values are not consolidated in any way. I have done the same check on multiple views - all with the same result. The even weirder behaviour is that the options aren't greyed out when the calculated value is zero!

I can see why the rules aren't working - feeders are coming through I think - but I can't check. I have got PersistentFeeders set to F (as well as ParallelInteraction) so as to mirror the 9.4 environment as best as I could for now

Anyone any ideas ?

Thanks
Anthony

That's no moon - that's a space station
declanr
MVP
Posts: 1815
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TM1 10.1 - Trace Calculation behaviour

Post by declanr »

Anthony,

Seems you have found a possible bug... can you not Trace calcs on any rule driven cell?

My Trace Calcs and Check Feeders have worked exactly as expected thus far.
Declan Rodger
User avatar
Steve Rowe
Site Admin
Posts: 2415
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: TM1 10.1 - Trace Calculation behaviour

Post by Steve Rowe »

It probably won't be this but when you have multiple cells selected in the cube viewer you can't trace calcs etc. It is not always obvious that you have multiple cells selected.

Might be worth checking?

Cheers
Technical Director
www.infocat.co.uk
AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Re: TM1 10.1 - Trace Calculation behaviour

Post by AnthonyT »

Thanks for the replies

I've double / triple ( and all the other 'le's' ) checked that I am only tracing from one cell.

The "feature" seems to work on some calculated results that are zeros, but not all - and I have tried different dimension combinations within the same cube, different cubes, and different clients reading the same 10.1 database

Such fun

*** UPDATE ***

I can select Trace Calculation on a consolidated level, and then drill back down to a leaf level, without problem - ODD
Anthony

That's no moon - that's a space station
sander
Posts: 52
Joined: Thu Dec 09, 2010 9:23 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Re: TM1 10.1 - Trace Calculation behaviour

Post by sander »

Anthony, i have the same issue here, have you contacted support? or any other updates?

Grtz, Sander
AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Re: TM1 10.1 - Trace Calculation behaviour

Post by AnthonyT »

Hi Sander

I haven't had the chance to yet

I still have the same problem and although I can work around the Trace Calculation problem by going in at a consolidated level, I can't do that with the Check Feeders option

I will see if I can log it next week, when I get back to the office

Thanks for letting me know I'm not alone :)
Anthony

That's no moon - that's a space station
sander
Posts: 52
Joined: Thu Dec 09, 2010 9:23 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Re: TM1 10.1 - Trace Calculation behaviour

Post by sander »

Anthony, I logged it yesterday, I'll keep you posted!

Grtz Sander
AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Re: TM1 10.1 - Trace Calculation behaviour

Post by AnthonyT »

Hey Sander

Great - look forward to hearing the outcome
Anthony

That's no moon - that's a space station
image2x
Posts: 125
Joined: Tue Jun 02, 2009 7:05 pm
OLAP Product: TM1, PAX, PAW, SPSS
Version: 2.0.916.10 on RHEL
Excel Version: 2016
Location: Minneapolis, MN

Re: TM1 10.1 - Trace Calculation behaviour

Post by image2x »

+ 1 for seeing this in the wild.

Thanks for pointing out the trace and drill work around.
sander
Posts: 52
Joined: Thu Dec 09, 2010 9:23 pm
OLAP Product: tm1
Version: 10.2
Excel Version: 2013

Re: TM1 10.1 - Trace Calculation behaviour

Post by sander »

This morning I got an answer from IBM support;

'Hi, The issue has been accepted as a defect and has been targeted at a future release......the APAR number for this defect is PM63037.... You should be able to view this on the web in the next few days.'
AnthonyT
Posts: 42
Joined: Mon May 19, 2008 10:25 am
OLAP Product: TM1, EV
Version: 9.0 9.1 9.4 9.5 10.1 10.2
Excel Version: 2003 2007 2010 2015
Location: London, UK

Re: TM1 10.1 - Trace Calculation behaviour

Post by AnthonyT »

So I wasn't going crazy then :lol:
Anthony

That's no moon - that's a space station
andre lie
Posts: 49
Joined: Thu Jun 05, 2008 9:54 am

Re: TM1 10.1 - Trace Calculation behaviour

Post by andre lie »

Hi all,

I would like to know if this issue has been resolved. I have installed TM1 10.1 FP1 but I still cannot trace calculation (and check feeders) for those N Level cell

Regards
Andre
ps_in_atl
Posts: 12
Joined: Fri Apr 01, 2011 12:55 pm
OLAP Product: Cognos TM1
Version: 10.1.1 x64_MS Server 2008
Excel Version: Excel 2007

Re: TM1 10.1 - Trace Calculation behaviour

Post by ps_in_atl »

Same here. First hotfix did not address the issue either.
rodrigosborges
Posts: 9
Joined: Fri Apr 01, 2011 7:47 pm
OLAP Product: TM1
Version: 10.2.0
Excel Version: 2010
Location: São Paulo, Brazil

Re: TM1 10.1 - Trace Calculation behaviour

Post by rodrigosborges »

What i realized is that while I did not create the feeder of the calculation the options "Trace Calculation" and "Check Feeders" are available.
When the feeder is set up these options are grayed out.
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: TM1 10.1 - Trace Calculation behaviour

Post by Harvey »

I found this bug too. I have filed it under "uncool".
Take your TM1 experience to the next level - TM1Innovators.net
kempzhong
Posts: 20
Joined: Tue Aug 25, 2009 8:27 am
OLAP Product: Cognos TM1
Version: Cognos TM1 10.1.1
Excel Version: MS Excel 2010

Re: TM1 10.1 - Trace Calculation behaviour

Post by kempzhong »

i noticed this bug too....
andre lie
Posts: 49
Joined: Thu Jun 05, 2008 9:54 am

Re: TM1 10.1 - Trace Calculation behaviour

Post by andre lie »

Hi all

FYI, this bug has APAR # PM63037: TRACE CALCULATION AND CHECK FEEDERS GREYED OUT. It has not been resolved.

Regards
Andre
Post Reply