Platform

Platform

A place for Apptio product users to learn, connect, share and grow together.

 View Only

Tip:  Watch out for three object drills in R12 

Tue November 07, 2017 02:41 PM

The Apptio platform preloads calculated data into cache in dynamically published environments. This allows the system to quickly display charts and tables that would otherwise take a very long time to calculate in real-time.
While this method of storing and displaying pre-calculated data is effective, there are some combinations of data paths that won’t be pre-calculated. One of these is three object drills that are filtered at each upper object. Here is an example of such a datapath:

 

.View:Three Object Drill/
IT Resource Towers/
!FILTER[{IT Resource Towers Master Data.IT Resource Tower Name}="Application"]/
.WithDefaultMetric-Cost/
.DrillTo/
Fixed Asset Ledger/
!FILTER[{Fixed Asset Master Data.Class}="Database"]/
.DrillTo/
Cost Source/


In this example the top object is IT Resource Towers. This object is filtered by IT Resource Tower Name. The second object is Fixed Asset Ledger. This object is filtered by Class. The bottom object is Cost Source, which doesn’t necessarily need to be filtered in order for the data path to not be pre-calculated.
These datapaths sometimes aren’t immediately noticeable. They can be created real-time by slicers. In the case above, the data path was created by slicers that were on the report:


As slicers are selected they will append their backing object into the data path if the object is not already included. Because this data path is not pre-calculated, if a user selects a combination of slicers that creates the three object drill in a dynamically published instance, Stage or Production, a real-time calculation will be initiated that can potentially cause severe performance issues and, in some situations, an outage. This is why it is very important to pay attention to what objects are backing the components on your reports.





#TBMStudio

Statistics
0 Favorited
3 Views
0 Files
0 Shares
0 Downloads

Comments

Tue April 09, 2019 02:50 PM

Depends if you're trying to avoid the three-object drill entirely, or just trying to avoid a negative performance hit while keeping the ability to drill across all three objects. For the former, it's just what Jesse said at the end of his post: "pay attention to what objects are backing the components on your reports". For the latter, the short/simple answer is to keep the row count of the "slicer applied" table view as small as possible for any slicer value that will trigger the drill.


#TBMStudio

Tue April 09, 2019 02:32 PM

Has anybody found good fixes to avoid this? 


#TBMStudio