The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Onestreamer92
10 months agoNew Contributor II
Parser rule to compare attribute data between current month load and last year Dec load
HI Experts,
I have a parser rule that looks at current attribute 9 and compares it with attribute 9 of last year December load and returns it as attribute 10 which helps me map the differences in ...
rhankey
10 months agoContributor III
I can bet performance is poor. Options that come to mind:
- If this is a direct connect data load, then join in the prior Dec attribute value from source so you no longer need to use a one row at a time parser rule
- Use a Transformation Rule Event handler that performs this particular transformation for all the imported rows in a single SQL statement.
- If you know the OS api well enough, you could cache a lookup table to OS Global cache. The first time the Parser rule fires would see the lookup table does not exist, and thus create it for all passible values you could need. For all subsequent rows, the parser rule would see the lookup table does exist in Global cache, and get the value from cache.
Related Content
- 4 years ago
- 4 years ago
- 1 year ago