IBM Apptio

 View Only

 To create a button which triggers report calculation

Jump to  Best Answer
  • CostingStandard(CT-Foundation)
Robert Sánchez Guisado's profile image
Robert Sánchez Guisado posted 10/10/22 04:15 PM
WE're managing a report which is a freem form report of all data contained in the model. It contains a lot of pickers in different tables. Every time a picker is selected, it triggers an underlying calculation process which may end up in 20-30 calculation threads.
Logic which does not allow to select pickers from 3 different objects it's in place - No issues to this respect.
Is it possible to create a button which triggers all required calculations once the user has selected all the pickers gong for 1 single calculation process?

Please, do you think that you'll implement a nicer solution from the end user perspective? - e.g. to launch effectively the button when all selections are done. This will make easier to control Apptio behaviour.

Thanks,

Robert
#CostingStandard(CT-Foundation)
Rene Norskov's profile image
Rene Norskov posted 10/10/22 06:42 PM  Best Answer

@Robert Sánchez  The feature to postpone the query execution is available in client version 1.12.0 which was released on the 8th July 2022.
These free form / all-in-one reports can be very slow and put a strain on the system that affects all users negatively.  All recommendations I have seen is to avoid them and create individual / targeted reports per use case instead.


#CostingStandard(CT-Foundation)
Guillermo Cuadrado's profile image
Guillermo Cuadrado posted 10/11/22 01:47 AM
I feel you, @Robert Sánchez Guisado: we have a similar problem. Our Controlling TBMA created a general purpose report, with lots of pickers and slicers.

@Rene Norskov: once you open the Pandora box, it's kind of hard to close it again. We've been trying​​ to provide use-case-specific reports, but our Swiss-army-knife flagship report still dwarfs the rest in the Usage statistics.
#CostingStandard(CT-Foundation)
Debbie Hagen's profile image
Debbie Hagen posted 10/19/22 06:23 PM
@Robert Sánchez,
This is the feature that Rene referred to.
​

#CostingStandard(CT-Foundation)
Ed Hayman's profile image
Ed Hayman posted 10/19/22 07:36 PM

Delayed Refresh

Changes to interactive components on reports currently respond in real-time. For example, when a user selects a value on a slicer, the filter is immediately applied. Users can now control the response behavior through a new feature, Delayed Refresh.

The available options include:

• Live

Real-time refresh

• 2 sec Delay

The system waits for 2 seconds before refreshing the screen.

• 5 sec Delay

The system waits for 5 seconds before refreshing the screen.

• Manual

This mode requires the user to select Refresh to update the report. This is useful for large, complex reports where multiple interactive selections are made.

The Delayed Refresh feature is disabled by default. Admins can enable functionality with Enable Features in TBM Studio.

This setting will apply to all reports.  End users can change the setting at any time in the top navigation bar.  As such, for simple reports, you may want it set to 2 or 5 seconds.  Clicking on the button at any time will update the screen (e.g., before the countdown is complete).  For a large report with numerous slicers, pickers, pivots, the user may switch to manual.  Make all the desired selections then click on the Refresh to update the report.  


#CostingStandard(CT-Foundation)

Related Content