TM1 DISPLAYS #N/A VALUES INSTEAD OF "0"

Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

TM1 DISPLAYS #N/A VALUES INSTEAD OF "0"

Post by mce »

Hi,

In Planning Analytics Local v2.0.5 environment, I created a cube with 27 dimensions and it displays #N/A as value in consolidated cells although there is no rule in the cube at all.
Did you face this issue before? Any comments will be appreciated.

Regards,
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: TM1 DISPLAYS #N/A VALUES INSTEAD OF "0"

Post by mce »

Restarting Architect solves the issue.
User avatar
Steve Rowe
Site Admin
Posts: 2410
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 DISPLAYS #N/A VALUES INSTEAD OF "0"

Post by Steve Rowe »

27 dimensions !
Are you sure?
Technical Director
www.infocat.co.uk
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: TM1 DISPLAYS #N/A VALUES INSTEAD OF "0"

Post by mvaspal »

Restarting Architect solves the issue.
That can be the case when you are stuck in batch update mode, for example a TI that you run switches it on on the Prolog but then aborts without switching it off on the epilog
Post Reply