Active Form TM1RPTVIEW and DBRW Problem

[babytiger]

This is a common use of applying control cube values to active forms. Though, I wouldn't think the necessity of converting DBRWs in the active forms to DBR.

Below is a quick test on 10.2.2, with all DBRWs still intact.

system date example.PNG (22.21 KiB) Viewed 2264 times

One "feature" with activeform, TM1RPTROW will only bring back elements that the DBRWs are picking. For example, if you have suppress zero toggled on, and your spreadsheet is structured as follow:

[1] TM1RPTROW... [2] DBRW(TM1RPTVIEW...), [3] DBR(VIEW...)

In the case, [2] is 0, [3] <> 0, the active form won't return this element.

[tomok]

Thanks for the question babytiger. I have a DBR formula which pulls the current "system date" from a control cube. This "system date" identifies the latest month of actual data loaded into the server. All of the other DBR formulas pulling data from the primary data cube reference the "system date" DBR formula to know which timeframe to pull the data from the cube.

I've never found it necessary to convert all formulas to DBR in this instance (where an element used as a reference in a DBRW formulas is coming from another TM1 formula). I've always found that converting the reference formula to DBR is enough, meaning all the other formulas in the report can stay a DBRW and the active form works fine.