Active form returns zeroes

User avatar
Olivier
Community Contributor
Posts: 159
Joined: Thu Jun 26, 2008 5:46 am
OLAP Product: TM1
Version: Tm1 10.2.2fp4 -> 2.09
Excel Version: Excel 2013 - 2019
Location: Sydney

Re: Active form returns zeroes

Post by Olivier »

Marco,

The view sliced as basic active from displays zero as well until CTRL + ALT + SHIFT + F9 is hit.

I have created test cubes incrementally reducing the number of dimension and spreading dummy numbers to test the behaviour of the active form for each cubes with different number of dims based on indications in this post.

Based on my tests,
a cube with 10 dimensions and below generate active form without issue.

A cube with 11 or more dimensions generate active form showing zeroes.

This is the case for both views sliced as active form, customised/enhanced active forms and active forms resulting from a drill down.

Did anybody else hit this case and could confirm that 10 dimensions seems to be the limit for a 9.4MR1 HF16 64bits install or other versions ?


Hope that helps,
HTH
Olivier
Post Reply