TransformationEventHandler & ExecuteFileHarvestBatch
Hello, Our transformationeventhandler rule adds missing UD1 members to an unmapped parent. The rule works and has been for a few months. A couple of weeks ago I built a business rule which leverages the utitlity "ExecuteFileHarvestBatch". I have the relevant settings as True. Dim valTransform As Boolean = True Dim valInterest As Boolean = True Dim loadCube As Boolean = True Dim processCube As Boolean = True The batch rule was built so I could schedule the data load. What I am noticing, is when the scheduled job (which calls a DM job with the rule) runs there are failures because of missing UD1 members. If I, then run the import/validate/Load and Process steps manually there are no errors and the missing UD1 members get added. It is as if the TransformationEventHandler is not being executed when the import process runs via the scheduler/dm job/rule. Any ideas for suggestions of where to look?Solved3.2KViews0likes4CommentsData Audit Dashboard
Hi All, I am trying to create a dashboard to extract the data for the given point of intersection basically I have given all the dimension parameter for the user to select and click on the button download that runs the DataManagement job and will extract the data for the selected POV . I am able to achieve the above requirement just like an enhancement I want to also get the data of the user details who has loaded data into those point of intersection. Can some one help me with the lead how can I achieve the above user details that would be really great. Thank You8Views0likes0CommentsCube View
Hi, I'm trying to create a form with set of accounts in rows and column should be for adding the adjustments. Here, I do not required to pull any data from the cube. Instead I have to update the adjustments based on the scenario selected. This should be a separate form where the adjustments data should not update the existing forecast data. POV: Parameters in POV are defined to pull the accounts accordingly. Rows: Columns: Issue: I couldn't get the form with editable fields. refer screenshot below. FYI: Can Modify data for Column is set to 'True'85Views0likes14CommentsSyntax for calling a Finance Custom Calculate Service
Hello, I am working in an 8.5 application and want to utilize Finance Custom Calculate services within a dashboard. My service factory is enabled at the Dashboard Maintenance Unit level of detail. I am trying to launch the custom calculate function via a dashboard button. Does anyone have example syntax for this? I figured OneStream would release documentation externally for this but was unable to locate any. Thanks!Solved103Views0likes3CommentsIs there a way to Extract or Download Multiple Files at once from the File Explorer to my computer?
I used data management jobs to extract historical data from a legacy application and they are now sitting in file explorer and are split-out by period. I need to extract these files to load to a new application. I tried holding shift and control on my keyboard to highlight multiple files but I did not have any success. I believe this will need to done via business rule but I am unsure. Please let me know if I can provide any additional information.Solved40Views0likes2CommentsManipulate RichText content
Hello everyone, We are currently building a solution. Where we try to only pull the PlainText from a RichText component. Currently we got in our research two solutions proposed: Regex solution, which is prone to errors as we need to cather for various cases and exceptions RichTextBox() functionality, that seems to do what we want as standard (see below) that but that throws an error Seems this function is not used/available anymore in v8. Does anybody knows if it's possible to use this still in v8 via some additional set up in the app ? Or if we would have a corresponding similar rule in v8 environement ? Alternatively, would you have any suggestions as to how easily manipulate and extract plain text out of rich text object's code ? Thank you in advance for your help!10Views0likes0Comments"In Use" property: Time and Scenario Dependent maintenance
Hello All, for our project, we are using the In Use property in UD2 with the Time/Scenario dependency option. Seems to work but the problem for us and also raised by customer is the maintenance part of it. We showed them how to use Grid View but with that we are not able to see how this In Use property is configured by scenario and time. Grid View only shows In Use ticked box everywhere even if we set it to False for some scenario/time combinations. This is really a drawback for us now in implementation phase and for them in the future to administer this application. Does anybody that used scenario/time dependant set up (whether for in use property or for any text attributes, that would be same problem) had a good way to maintain this property without having to go one by one in each member to see what is configured and update it ? Or did you achieve differently the requirement to handle the fact to activate/inactivate some members over time without using the In Use property ? Thank you in advance for your support and feedbacks on that!Solved56Views0likes3CommentsResult table of Cube View MD is empty
Hello All, I have a Cube View that I want to use as data source for a BI VIewer object. When I execute this CV, I can see data: When I use this (basic) CV as MD in data adapter, it is empty. I checked the set up steps in the doc and I can't see what I could have missed. Would you have any ideas why the result table doesn't return values that I can see in my Cube View ? Thanks for your help MatthieuSolved3.3KViews0likes6Comments