TM1 Forum

Hi,

Using Perspectives in TM1 10.2.2 with Excel 2013. Created an Active Form using the Insert button on the TM1 ribbon. Chose a view to use from a cube for the Active Form. Used the default Active Form Name of ARPT1. This original view compares Actual and Budget values. After the information was pulled into Excel, modifications were made in Perspectives to the report for formatting and functionality.
Now, I'd rather have the report compare Actual to Forecast (instead of Budget; all of these are different elements in a Version dimension). Is there a way to update the report if I update the original cube view the active form is sourced from? I cannot find any indication within the worksheet how the worksheet is tied to the original cube view, but it seems it is, because if I just change the reference in the formulas to pull Forecast instead of Budget, zeros come back against Forecast after Recalculating, presumably because it's not in the original view.

Does anyone know if and how an active form is tied back to the original cube view it is sourced from?

erind wrote:Does anyone know if and how an active form is tied back to the original cube view it is sourced from?

No. The original view is just a starting point for the active form. Once you create it, everything is in the Excel workbook. Go to cell A1 in your active form and unhide all the hidden rows and columns. This is likely where your metadata for the parameters for the DBRW formulas are (unless you inserted the active form further down below in your workbook. If you can't find where the metadata is iook for the first parameter in your DBRW formulas and unhide that cell. This will get you started. I have no idea how your active form is designed, as in what dimensions are titles and which are rows and columns, but you'll have to make your changes in Excel. Or, you could just change your view and start over, your choice.