Forum Discussion
Daily Forecast Load
I would like to know from fellow OneStreamers where you’ve done a daily forecasting application. I’m not necessarily looking for a solution. Just ideas on how this can be done.
How do you load day ...
CraigR
OneStream Employee
OneStream EmployeeWhen I have done daily apps, I like to put a generic day dimension in, Day1, Day2, etc. Assuming this is set up to be a weekly time app, perhaps one of the UDs could be a day dim Day 1 - 7. I have also done it for days of the year, Day 1 - 366.
Craig, thank you for your reply. We do have a day dimension set up. Day1-Day31. I’m trying to create a less intrusive way of loading forecast data. I’ll keep you all posted.
So here is what we did. User loads to an import (stage only) profile, transformation event handler then looks at the workflows that need a load day by day profiles. Behind the scene loads multiple workflows looking at the file (days in the file) and loads those day-specific load-only profiles behind the scene.
Easy-Peasy
Thanks & This is an useful info.
