Active Form crashes Excel
Posted: Wed May 09, 2018 9:56 am
Hello,
first of all we use PA 2.0.4 and Excel 2016.
I have the following situation with a model created long before I came here:
A cube with a couple of dimensions (5). And I want to span an active form over one of these dimensions. Still no problem until here.
The Dimension which is used as active form is the 4th dimension in the cube. And the elements have an attribute wich has the Elementname for the 2nd Dimension. I did it the following way:
Column B in Excel (A is the formatting Column): =TM1RPTROW($B$14;Server&":Dimension4";"Subset")
where $B$14 the TM1RPTVIEW, Server the Cell with the Server-Name and "Subset" a static subset is.
Column C is the DBRA wich gets the Attribute
Comumn D is =DBRW($B$14;$L$24;$C31;I$17;$B31;I$15) Where $L$24 is the same Cell where also the TM1RPTVIEW is pointing to and I$17 and I$15 are 2 Element-Names.
This crashes Excel if I want to open the active form.
If I replace the DBRA in Cell C.. with one of the correct Element-Names I get the correct result.
I even tried a DBR instead of DBRW but than the form does not open.
In TM1Web it displays correctly.
Any idea how I can get this to work in Excel?
Thx in advance
first of all we use PA 2.0.4 and Excel 2016.
I have the following situation with a model created long before I came here:
A cube with a couple of dimensions (5). And I want to span an active form over one of these dimensions. Still no problem until here.
The Dimension which is used as active form is the 4th dimension in the cube. And the elements have an attribute wich has the Elementname for the 2nd Dimension. I did it the following way:
Column B in Excel (A is the formatting Column): =TM1RPTROW($B$14;Server&":Dimension4";"Subset")
where $B$14 the TM1RPTVIEW, Server the Cell with the Server-Name and "Subset" a static subset is.
Column C is the DBRA wich gets the Attribute
Comumn D is =DBRW($B$14;$L$24;$C31;I$17;$B31;I$15) Where $L$24 is the same Cell where also the TM1RPTVIEW is pointing to and I$17 and I$15 are 2 Element-Names.
This crashes Excel if I want to open the active form.
If I replace the DBRA in Cell C.. with one of the correct Element-Names I get the correct result.
I even tried a DBR instead of DBRW but than the form does not open.
In TM1Web it displays correctly.
Any idea how I can get this to work in Excel?
Thx in advance