Question: Active Form vs Application

[knoppentop]

Hello all,

I have an active form (Perspectives) where everything works fine; I have a cell referring to the last element of a dimension, and picking a measure in it:
=DBRW($B$9;$C$17;$C$19;$C$20;$C$21;DIMNM("PriceTool:Modifiers";DIMSIZ("Pricetool:Modifiers"));J$32)

However, when I upload this active form to the web Application, this cell is empty.

Also, I make use of a picklist cube (control cube). Everyime I change a value in the active form, the rest of the form is updated automatically. But on the web application, I have to manually rebuild the sheet, to have the values refreshed.

My questions are:

1. Why is this value empty on the application? I tried excel formulas but they become circular and they suggested me to use TM1 functions.
2. Is there any way to automatically refresh the Web application when selecting another item in the picklist?

Thanks in advance for your help.

[jim wood]

Is this something you added? Did you rebuild it before publishing it?

[knoppentop]

Hello Jim

thanks for the feedback. Yes, I added it in another cell. I've rebuild the sheet and uploaded it on the application.
Please see the difference in the attached images.

It is the 'modifier' value that is empty and where I entered the formula.

[jim wood]

As you're referencing a value within the formula I wonder if it's a calculation order issue? Try hard coding the value within the formula add see if it makes difference. Also try moving the DImNm formula outside in to it's own cell. I tend to find with these things it can be a process of elimination.

Are you using the picklist within the view for values or dimension lookups? I didn't quite get what you're trying to do there,

Jim.

[knoppentop]

Hello Jim

after a few days I managed to fix the issue. The problem was that I was combining too much Excel functions and calculations. I created a calculation cube where I stored all my values (that I needed, but invisible for the end user). All other calculations are now implemented in rules and it works.

Thanks again for your help!

Kind regards

[tomok]

I have an active form (Perspectives) where everything works fine; I have a cell referring to the last element of a dimension, and picking a measure in it:
=DBRW($B$9;$C$17;$C$19;$C$20;$C$21;DIMNM("PriceTool:Modifiers";DIMSIZ("Pricetool:Modifiers"));J$32)

If this cell is then used in another DBRW formula then you're a victim of calculation order. DBRW calculates cells in batches and you have no control over the order. If you combine two DBRW formulas then it will likely not calculate in the order you want and the result will be an empty value.

DBR, on the other hand, calculates one cell at a time. Had you changed this:

Code: Select all

=DBRW($B$9;$C$17;$C$19;$C$20;$C$21;DIMNM("PriceTool:Modifiers";DIMSIZ("Pricetool:Modifiers"));J$32)

to this:

Code: Select all

=DBR($B$9;$C$17;$C$19;$C$20;$C$21;DIMNM("PriceTool:Modifiers";DIMSIZ("Pricetool:Modifiers"));J$32)

it probably would have worked.