OneStream Platform Forums

I have a extensible rule called "A" to update my Derivative transformation rule group. Now during the workflow execution , i want to run A just before the transformation step.Requirementstep1- Load the file.step2 - Before running the transformation , I want to execute AQuery?Where can I add the business rule so that it runs atleast before the derivative transformation kicks in?  

Hi Onestreamers,Could you guide me to a document or an article where I can learn more about OIS ?Thanks,Adam

Does anyone know if it is possible to rename a cube? I am happy to execute SQL queries if that's what it takes. Failing that are there any shortcuts for copying a cube (with all the workflows)? We have copied an application but one of the cubes (top level for workflow) must be renamed as it is out of place in the new application. Any comments or ideas will be welcome. Thanks

Team I have a raw dataset with more than 100 Columns. I would like to connect the data and import 30 columns and have the data imported to cubeview as is. And then will manage the view in Dashboard.   Basically, in Excel world am trying to put a pivot on raw data of 100 columns with output being only few of them. Thanks

Using v.7.4.1.Initially, I set up 1 WebServer and 1 AppServerI configured the single AppServer to handle all processing and added that AppServer to the WebServer Config.The AppServer was receiving the heartbeat request as expected.Then I set up a second AppServer.  I changed 1 AppServer to be General Access and Stage Load.  I set up the other AppServer to be Consolidation and Data Management.I checked the logs on both AppServers and only the AppServer configured as General Access and Stage Load received the heartbeat request.I decided to swap the AppServer functions and the heartbeat followed the General Access AppServer.I assumed the heartbeat would be found on ALL AppServers.  Is it by design that ONLY the General Access AppServer gets the heartbeat?

hello - I have the Workflow start time and Workflow end time set on the Scenario. I am trying to change WF POV from Dashboard component Combo box by passing Scenario as parameter. scenario is changing but the year is not, i need workflow start year dynamically updated along with scenario. Any inputs on how to get the Workflow start year changed along with Scenario is appreciated.   below are my settings under Actions section Selection changed POV Action: Change Workflow Selection changed POV Arguments: WFScenario=|!MyWFScenario!|

Hello,I am using a custom defined navigation for my users to easily navigate between workflow profiles.However, for an import task, when the user click on the button to access it they are redirected to the standard import workflow profile menus ( with the "Import > Validate > Process tasks ...).--> Is it possible to actually integrate this standard import workflow menu into a dashboard (as some kind of "embedded dashboard" for the import functionalities) ? Many thanks,

Hi Community, Does anyone have experience running confirmation rules when the workflow tracking frequency on the scenario is set to yearly?  The rule looks like its only running for the POV time which the WFYear but I want the rule to run for each period. I'm hoping someone else has come across this as well. Cheers!

Hi, I would like to know how to extract a list of active user from an entity in Onestream.

Hi community, For a client I am looking for the following: - Data extract from Yardi is loaded via .csv file into OneStream.  - The data file contains columns for amount = beginning balance + amount ,account = account  and flow = Segment6 column. FinTrialBalances                                                             Transaction_Type Control_Number Blank_1 Blank_2 Transaction_Date Post_Month Reference Notes Property_Code Amount Account Blank_3 Blank_4 Books Remarks Blank_5 Beginning_Balance Blank_6 Blank_7 Segment1 Segment2 Segment3 Segment4 Segment5 Segment6 Segment7 Segment8 Segment9 Segment10 Segment11 Segment12 J 14202303     3-1-2023 23-Mar :TrialBal   xxx 0 22020100     1     -2866.67               F40 - Reclasses in Bal. Sheet    

Hello, Is there a way to set a requested app server name when executing a data management sequence? Thank you.

Recent installation of 7.3.1.1 WebServer and 3 AppServers.When I log on to the WebServer and attempt to hit "http://localhost:50001/OneStreamWeb/OneStreamXF.aspx, I get an error that says 'Unable to access application server using address "http://[AppServer]:50002/OneStreamApp." 'If I open a browser on my webserver and navigate to http://[AppServer]:50002/OneStreamApp/svc/Data.svc, I get the expected result ("You have created a service").I was also able to create an application database from my app server, so I know the connection to the db is correct.How do I figure out what is missing?Thank you in advance for any help. Ray 

Hi All, Can anyone  please suggest how to add Orders Commentary in Dashboard?     Thanks in Advance.

Hi all, Is there any way to automate workflow creation and step renaming using business rules ? Can someone provide an example please.  Thanks for the help.

Hello,I was wondering if it's possible to change the workflow year to show FY20XX instead of just 20XX. In our legacy system we used FY20XX as our current year and we would like to continue with that style. I cannot seem to find a spot where to change it but I've seen images of other workflows with the year showing FY20XX. Thanks, Will

Hello Everyone,    Is there a way to force the composite expression to run before the One To One Rules ?  i am trying to run a complex expression to override values coming from the Source Data. but the One To One Mapping is triggering the mapping, what i want to Select all BS accounts from source based on the Target mapping , and import UD2 as a None Value . Instead what is happening is that all the BS accounts with UD2 value are being Mapped based on the One To One mapping i did for the PL Accounts. and i only want the PL accounts to have a UD2 Value.      

Could you confirm if it is possible to apply Security when using in an application the EXTENDED DIMENSIONALITY: It means, if we  want that Corporate cannot create new users for a specific LOB, or create new companies or accounts or manage access rights for this LOB. It is possible to restrict to Corporate all these options? Many thanks

Hi Team, Could you please let us know if it's possible to use the function math.pow in a databuffer? and if yes, which is the correct syntax? As for example Dim resultDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula("Math.Pow(($sourceBufferMonthlyRate),$sourceDataBufferResidual)") or maybe in a api.Data.Calculate function?  Thank you in advance! Giorgia

Hello,Well, the title is quite explicit 🙂I am trying to avoid the standard workflow panel as often as possible. Right now, I would like for the user to select the workflow profile just by clicking a dashboard button component and access this menu : Is it possible ? Regards,

Hi, Does anybody have a example of an business rule to import data from Sage with an API?  

Hi,   ParamA will be a multiselect combo box and the same should be passed to business rule as well. May I know how it can be done? I'm passing the parameter in calculate button, then DM step and then to BR. Calc button : {seq_name}{ParamCC = |!ParamA!|} DM step: {|!ParamCC!|} BR: Get value of ParamCC Need suggestion on how should it be passed if parameter is multiselect. thanks

Originally posted by Rahat Fatma Hi I am trying to load data into BI Blend cube but getting this error while table creation.  "BI-Blend base data does NOT match any Aggregation Base Members." Where do I need to look to trouble shoot the issue.

Hi everyone, I need to retrieve the account name from a certain line in a cube view in an XFBR rule.  So, it boils down to the need for an api.Pov.Account.MemberId XFBR equivalent.   Is there anyone that can help me with this issue? It seems so simple but I cannot figure it out. Thanks! Floris

Hi Team, The user unable to login into OneStream application. We have verified that all access has been setup. But, after clicking of "External Provider sign in " we are facing the below "500 internal server error"     Thank you Regards, Praveen

OS Version 7.3.3My files are stored in a Named Workspace, "Finance WS"I want to open a file stored in Finance WS.  How do I get the workspace guid to accces the file? Dim guidWs as Guid = ???BRApi.Dashboards.FileResources.GetFileResource(si, False, guidWs, strFilename)