Accessing external DB data via SQL Table Editor
Hi, I am unable to access external database view via sql table editor in the Cloud OneStream (version 8.2). Can somebody suggest what can be the possible issues? It is working fine when accessing the current app database but only issue is when accessing external database. The external connections are fine as able to access the data via data adapters.13Views0likes2CommentsTask Scheduler
Hi All, I am trying to schedule a task in Task Scheduler to trigger a Data Management job every 180 minutes, starting at 02:50:00 AM and ending at 9:00 PM. However, when I attempt to set this up, I receive the following message. Is this a warning, or is it something that needs to be addressed in order to resolve the issue? Thank you for your assistance.12Views0likes1CommentFiscal Year Change
Hello, I am wondering if there is any way to change a fiscal year once we have been using the application for quite sometime (several years.) Our current Fiscal year is 2025 so all the data is being imported into year 2025, but we now need to adjust our fiscal year one year back. So everything in 2025 becomes 2024. Is this possible? Or what options might I think about? Would I need to setup and start using a new scenario? Any ideas, comments, suggestions would be greatly appreciated. Thank you136Views0likes5CommentsMember Filter on Scenario properties
I would like to apply a member filter on a scenario, which will return a list of a scenarios based on it's properties like Name, Description, WorkflowTime, WorkflowStartTime, and WorkflowEndTime...i.e. WorkflowTime = |someYear| or WorkflowStartTime = |someYear| or WorkflowEndTime = |someYear| I can do this S#Scenario.where(Name contains paramScenario) I can do this S#Scenario.where(Description contains paramDescription) I cannot do this S#Scenario.where(WorkflowTime = 2025) I cannot do this S#Scenario.where(WorkflowStartTime = 2025) I cannot do this S#Scenario.where(WorkflowEndTime = 2025) What am I missing?Solved28Views0likes4CommentsUnderstanding TR
Im having an issue with a transformation rule where i have on stage : - Account 5115-0001 -UD2 2350 -UD4 2020 That combination of dimensions is being assigned by the following TR A#[5015~5115-0406~0408]:UD4#[2001~2010]:UD2#[2002~2203] I believe the problem is in the Account range, but do not understand why. can someone explain the reason why?105Views0likes3CommentsTask Manager Email Notifications Not Sending with Open Workflow Task Type
Hello, We're in the middle of implementing Task Manager and whenever a task is using the "Open Workflow" task type, it seems not to send a notification email when the task has been completed and ready to be approved. We've tested other tasks and the email notifications work fine. Is this a known issue and if it is, is there a way to get around it? I guess we could set all the tasks to "No Action" task type, but I feel like that would be redundant for them to go to TM and then have to go to the WF instead of being able to click on Execute and take them to the WF. Thanks, Will41Views0likes0Comments