Hello,
I created a cube locally with the 'Include when needed' property specified in Transformer for most of the measures.
The cube was 35 Mb.
I then wanted to put it in our Production environment (created with scripts and scheduled).
And when created via script the cube size was 52Mb... while containing exactly the same data.
When I looked at it I saw that I was now getting all the categories, even when no measures are associated with them.
This is very strange for me as the PYI and IQDs are exactly the same, only the Transformer version is different (7.1.32 on my PC and 7.1.98 on the server).
No need to say that I re-opened the model and checked: the
'Inclusion when needed' property is correctly selected....but it does not need to be taken into account.
Did anyone already have the same problem or an idea of the problem?
I created a cube locally with the 'Include when needed' property specified in Transformer for most of the measures.
The cube was 35 Mb.
I then wanted to put it in our Production environment (created with scripts and scheduled).
And when created via script the cube size was 52Mb... while containing exactly the same data.
When I looked at it I saw that I was now getting all the categories, even when no measures are associated with them.
This is very strange for me as the PYI and IQDs are exactly the same, only the Transformer version is different (7.1.32 on my PC and 7.1.98 on the server).
No need to say that I re-opened the model and checked: the
'Inclusion when needed' property is correctly selected....but it does not need to be taken into account.
Did anyone already have the same problem or an idea of the problem?