Need help on the access group of work profile name
Hi Everyone, Need your support I am currently preparing a dashboard to manage user security details in OneStream. As part of this, I need to retrieve and modify Workflow Profile access groups. Specifically, I want to get the Access Group names corresponding to each Workflow Profile (e.g., for Workflow Profile US, the View group is US_View and the Modify group is US_MOD) based on scenario type. Currently, I am able to retrieve the AccessGroupID, but I am unable to get the group names. Could you please provide guidance or confirm the table/approach I should use to map Workflow Profiles to their Access Group names? Your assistance will help in correctly setting up the dashboard and managing user security efficiently. Data Adapter to pick group Data adapter to pick Workflowprofile and assigned entities. Thank you in advance for your support.
How to write Smart Integration Function in Assembly
Hi, I have created one one Smart integration function in to transfer file from sftp server to share point server. can we use smart integration function as a file or use existing smart integration function as dependency , not sure just need suggestions.
SaveCustomDataTable behaviour in different Versions of OS
I have used SaveCustomDataTable in OS v9.01 where you need to clear the data before loading the table and it works fine. Recently i was building similar logic in OS v8.2 and noticed that it was truncating my table , is this expected or is there something i am missing it is the standard call: BRApi.Database.SaveCustomDataTable(si, "Application",Table,dt,True)Async processing in a Connector Business Rule
Hi All, I am writing an Connector BR to connect to a system via their API. I first build the rule as a Extender rule so that I can test the logic. So far it works great. It uses Asynchronous processing on all of the web calls. When I try to move that code into a Connector BR, I am having an issue on the GetFieldList part of it. When I try to use it in a data source, I get the following error: Unable to cast object of type 'System.Threading.Tasks.Task`1[System.Object]' to type 'System.Collections.Generic.List`1[System.String]'. I am guessing this is because the Main module in the BR is public async Task<obect> Main so whatever is returned is going to be a Task<object>. Has anyone done Asynchronous processing in the connector rule and had the GetFieldList part working. My only thought to get around this is the write the data to a table/file with the Extender BR then the Connector reads that. Any thoughts are greatly appreciated. Scott
Time dependent mappings
Hi I'm look for a solution to perform time dependent mappings. For example: Source Target Prior to Dec 25 x y Dec 25 onwards x z Has anyone come across the need for the before? And if so, what solution did you implement for this? Did you notice any issues with performance etc? Thanks, Mark
XFGETCELL(), XFSETCELL() PERFORMANCE
Hi all, Every forecast cycle we get the same performance complaints from the same region group of users. They are always uploading massive amounts of data and refreshing massive amounts of data in the same workbooks using the XF functionality in Excel. To be clear, we have tried multiple times to convince them that they should be importing that data via CSV and advising that they will not get the same performance using the XF functions. We have also tried having OneStream re-index the databases before these cycles and we have regular daily app pool recycles. The OneStream data logs really don't show any significant refresh issues (less than 5 minutes usually) but the one user doing all this work is insisting that it's taking hours and hours to finish refreshing and they often have to close and reopen Excel and re-launch OneStream. We have raised multiple tickets and OneStream does not see any back end issues. We have looked at their Excel preferences and tried different options there but no improvement. I am 100% out of ideas so if anyone out there has any thoughts, would love to hear what you've done to resolve these issues. I'm going to post this as well somewhere in the community where Excel discussions happen. Thanks for any advice.
Cubeview Drill Down issue: Load Results for Importe Cells is empty
Hello there, We are having an issue when using the Drill Down option from a Cubeview, and it's that after getting to a base data cell within the Drill Down window, and then trying to navigate to stage using the "Load Results for Imported Cell", the results window is displayed empty: The workflow that is being used it's a simple Import, Validate and Load, that retrieves the imported data from a Connector and there is no further data processing once it's in the Cube. From the Workflow Page we can use Drill Down and Drill Back just fine. Any ideas of why is this happening? Thank you. Oriol
Change Load method through connector code
Hello everyone! Quick question. Does anybody know how to change the Load Method for a ProcessDataTable through the connector code? We have a dashboard where the user wants to choose the Load Method with a radio button. We are able to pass that parameter to the code and change the api.LoadMethod property to Append but the load still executes as Replace. The above works if we change the load method directly in the WF, but not from the code
