Recent Discussions
Cube Root Workflow Profile - Display Description
Hi Folks, I was wondering if there was a way to display a description for the Cube Root Workflow Profile in the dropdown menu. For example in my screenshot there is Corporate_MON and Corporate_WOR. I would like them to display: Corporate_MON - Monthly Forecast Workflows Corproate_WOR - Planning Workflows Note: I did try adding descriptions, they only seem to display for children of the main Cube Root Workflow Profile
FDXExecuteCubeView with Consol filter
Hi All, How would I go about passing a Consol member as part of the POV to a FDXExecuteCubeView call? I want to pull one extract that is in Local currency and another that is in USD. Can I do that with this call, or do I need to set up 2 cube views, one set to Local and another set to YTD? Thanks, Scott
How 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, Praveen
Europe SWIFT File
Hello, I have a SWIFT Bank file from a client based in Europe that I need to import. I thought this would be similar to a BAI file and could use the OS BAI Parser solution to grab the necessary information, but the format isn't as similar as I thought. Is there any other tool for parsing out a SWIFT file or will this require some custom logic?
Cube views and Parameters
Hi All, I encounter this issue while opening a cube view from a form template in the Workflow. The same cube view opens without any issues directly but if you try opening the same via the workflow, it gives this error "Cube Views used for Forms cannot use parameters when referencing other cube views for Shared rows or columns. Unable to resolve substitution variable <paramtere_name>" .Some detail worth mentioning here is that we are using paramters for formatting and in one of those formatting parameters we are using another parameter. Has anyone encountered something like this and how did you overcome it. Thanks for your help 🙂 KR ArpitImport .CSV data source with 2 matrix
Hi. I have a .csv file that i am importing as a Matrix. I have 4 columns that each has different UD6 member. Problem is, one of the columns also have a different Account than the other 3. Can I somehow do a double matrix, or pull the data from the one column in another way. I would like to see if I can avoid loading the file multiple times or manipulate it otherwise before load. Appreciate any suggestions :) Details: Column1: U6#TECH1:A#0210 Column2: U6#TECH2:A#0210 Column3: U6#TECH3:A#0210 Column4 :U6#UnallocTech:A#0205How 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, MikkiSendMail input string not in the form for an e-mail address
Hello everyone, We recently made the jump from version 7 to 9, and a rule that was previously working is now throwing an error. We are trying to use the BRApi.Utilities.SendMail functionality after a certification is done through the DataQualityEventHandler, but OS is giving us the following message when executing the certification The specified string is not in the form required for an e-mail address. We verified the toEmailAddresses parameter is a List(Of String) with a single item in the format "user@mail.com". What can be causing this issue?
