
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can intervalmatch be applied to a dimension involving aggregation?
Hi everybody,
I have a question regarding intervalmatch. So far I used the intervalmatch function in conjunction with static dimensions (e.g., a computed field of a loaded table). It works fine. I like this way of mapping since the computation is done in the script and I can centrally adjust the upper and lower limits of the intervals.
So far so good. But this time I have a dimension which involves aggregation and rangesum (inventory turn based on a rolling time window). My questions are:
- Is it in general possible to apply intervalmatch to a dynamic variable whose computation involves aggregation or summing over a time window?
- If the answer to the first question is yes, what additional steps in comparison to static intervalmatch have to be undertaken?
Thanks in advance,
Tobias

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just to follow up. I changed my data model such that inventory turn can be computed during the load. Then intervalmatch works of course.
The lesson I learned: If the computational expressions become too complicated, change your data model.
