The generate missing time periods function does not create a lter block in the time dimension. This means
that if there are no calculations built on the IBP_GENERATE_MISSING_TP function that create a time lter
block, you can use time lters eectively. However, if there is at least one calculation in the calculation graph
that imposes a time lter block, you cannot use time lters, that is, missing periods will be generated for each
combination in the time horizon of the planning view.
If you want to generate missing time periods for a key gure combination, you must ensure that there is at least
one entry for the given key gure combination in the input data set as described below:
• If there are no calculations built on the IBP_GENERATE_MISSING_TP function that create a time lter
block, the entry must exist within the time horizon of your planning view in the SAP Integrated Business
Planning, add-in for Microsoft Excel.
• If there is at least one calculation built on the IBP_GENERATE_MISSING_TP function that imposes a time
lter block, the entry must exist within the planning horizon dened in the Planning Areas app.
Caution
Please keep in mind that though the IBP_GENERATE_MISSING_TP function makes modeling easier,
it signicantly increases the runtime of queries. Queries of calculated key gures that contain the
IBP_GENERATE_MISSING_TP function in their calculation graph might run up to a hundred times longer
compared to queries of stored key gures. We do not recommend to use it with time-critical key gures.
To avoid performance issues, please consider the following recommendations:
• Use stored key gures and the copy operator to initialize key gures, instead of the
IBP_GENERATE_MISSING_TP function.
• Use the generate missing time periods function only when there are very few time periods available for
the given planning horizon.
Using the IBP_GENERATE_MISSING_TP function with a large data set, that is with many time periods
uploaded with data, will cause you serious performance issues. The more time periods you have, the
longer your query will run.
• Make sure that the calculation horizon is not larger than 200. For example, keep the second parameter
higher than -100 and the third parameter lower than 100.
Time period generation with lter blocks
The IBP_GENERATE_MISSING_TP function is used most often as an input of L script and cross-period
calculations. These calculations impose a time lter block that is inherited by the generate missing
time periods calculation; that is, you cannot reduce data volume in the IBP_GENERATE_MISSING_TP
calculation by ltering. Furthermore, the function generates time periods for all possible key gure
combinations for which you have at least one entry available. As a result, you might experience runtime
performance issues and might run out of memory as well. For this reason, it is essential that you test the
performance with productive data.
Use the IBP_GENERATE_MISSING_TP function as close to the calculations that impose lter blocks as
possible. To improve performance, use other eective lters on the REQUEST-level calculations.
For more information about lter blocks and eective ltering, see Filter Blocks [page 482].
Time period generation without lter blocks
If there are no calculations that would impose lter blocks built on the IBP_GENERATE_MISSING_TP
function, use lters in your planning views to keep your planning horizon as small as possible.
240
PUBLIC
Model Conguration Guide
Key Figure Calculations