TM1 Forum

Hi All,
TM1 Active Form goes blank after running a TI Process. On rebuilding sheet, values return. Any reason?

Thanks,
LP.

LutherPaul wrote:Hi All,
TM1 Active Form goes blank after running a TI Process. On rebuilding sheet, values return. Any reason?

Could you please review the Request For Assistance Guidelines. You haven't given anyone anything to go on here. There's no indication of which environment you're doing this in (Web or Excel), exactly what you mean by "goes blank", what the TI does, whether what it does is connected to cubes that the active form is drawing from, whether you are running the TI from an Action Button or externally...

People don't mind helping, generally, but you do need to make it as easy as possible for them by putting some details into your questions.

Thanks Alan and applologies.

I face this problem in Excel active form. Server env 2008 R2, TM1 9.5.2.

A button on the active form runs a TI Process that updates the cubes with the values in the spread sheet (this part works fine) and afterwards, does not reload anything back. All cells are blank.
When I hit "rebuild current sheet", cells are reloaded.

I want to "rebuild current sheet" with the values from cube after the completion of the TI Process.
Any ideas?

Thanks,
LP.

Hi
Without knowing anything about the data content of your active form:
Have you tried to select 'Rebuild Sheet' when you click on 'Options...' in the Action Button Properties window? That should automatic rebuild your sheet when the TI finished running.

Thank you mvaspal.
That was the issue. i initially had "Automatically Recalculate Sheet" selected.
What is the difference between "Automatically Recalculate Sheet" and "Rebuild Sheet"?

Thank you.

LutherPaul wrote:What is the difference between "Automatically Recalculate Sheet" and "Rebuild Sheet"?

Exactly what the name implies. Recalculating simply recalculates the formulas existing in the sheet. Rebuild runs the macro hidden in the Perspectives add-in that re-draws the rows.