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,
TM1 DISPLAYS #N/A VALUES INSTEAD OF "0"
- 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"
Restarting Architect solves the issue.
- 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 DISPLAYS #N/A VALUES INSTEAD OF "0"
27 dimensions !
Are you sure?
Are you sure?
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- 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"
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 epilogRestarting Architect solves the issue.