Export data using a Method Query
Hi I have a method query that returns a data table of roughly 300k of records. Is there anyway to export the result of the method query to a csv file? I'm not keen on using a spreadsheet business rule or a grid view on a dashboard given the volume of records that is being returned. Thanks, MarkSolved1.6KViews1like4CommentsEncryptText And DecryptText Replacement
Does anyone know what replaces the 2 utility commands below? I get a warning message that those commands are obsolete but it does not give any indication or hints of what the new commands are or what's currently available? BrApi.Utilities.EncryptText andBrApi.Utilities.DecryptText Any help is highly appreciated. Thanks, JunSolved149Views0likes3CommentsHow to export from and import to custom OS tables
Hi, For the v8 to v9 upgrade, it seems like we need to remove our custom tables and add them back after the upgrade. We have scripts to add the tables back but what is the process you follow to export and import the data back. Table Data Manager or write a script to save csv file to OS folder and load it back? Thank you in advance, Praveen50Views0likes3CommentsHow to check data load status of WFs with load overlapped siblings enabled
Hi, Is there a way to check status of all load overlapped siblings enabled WFs? The issue is that we have bunch of overlapped data WFs (even after L3 data unit) and people are stepping on each other, doubling the amounts every time someone loads their WF while other WF data load is in progress. Wanted to try event handler and message showing load is in progress. Any other ideas to avoid this are also appreciated. Thank you, Mikki36Views0likes1CommentIncluding Journal Entries from Different Origin Member in Account Reconciliation Discovery
Hi Community, I’m working on an Account Reconciliation solution where I need to ensure posted journal entries balances are also included in the Account Reconciliation discovery process. Currently, by design the Discovery process only pulls trial balance information already imported and validated in the Stage. Therefore, I wanted to check if there’s a recommended, or best practice approach, to accomplish this requirement. Any guidance or examples would be greatly appreciated, thanks in advance for your help!Automated Extraction of Transformation rules
We have a recurring requirement to share the transformation rules/logic on a regular basis with downstream teams or auditors. Currently, this is being done manually, which is time-consuming. Is there a way to automate the extraction/export of transformation rules? Some options I’m thinking of: - Can this be done via Business Rules (BR) / Decision Model (DM) modules? - Is it possible to extract or view all applied transformation rules directly through Cube Views? - Has anyone built an automated solution (e.g., a dashboard, cube view, report, or extender rule) to export/list all transformation rules in a readable format? Would really appreciate your thoughts or examples if you’ve implemented something similar. Thanks!44Views0likes1CommentHow to copy a scenario from one application to another?
Hello, I recently recovered a scenario from a restored application copy from a point in time. I now would like to extract that scenario from the application copy and put that in our working application. Does anyone have any idea on how this would be done? Thank you, Jeremy MorganSolved2KViews0likes8CommentsAutomate Data extract after consolidation
Hello, I have an extract I am looking to automate with the task scheduler. However, I am looking to also automate a run once a consolidation completes and also have the ability to cancel a scheduled export with a button if it is set at a time when a consolidation is taking place. Is it possible to accomplish this?31Views0likes1Comment