Discuss the features and functionality of OneStream.
Recently active
I have a process that causes contention if launched concurrently by users. Is there a way to check if a session with a specific description is already running? I would like to abort the session if another session with the same name is already running. I tried looking through properties and found "GetTaskActivityItem", but the definition and sample are not of much help.
In BI Viewer, Is it possible to drilldown to the base level members using Pivot Grid within the same dimension. Like if I pull Entity dimension in a row then is there any way to drill down to the base level members ?Also, Can filters list out the members in a hierarchical /tree format? Generally combo box/list/tree map displays it in a flat structure so is there any alternative way to achieve it ?
I have a scenario where I modified the member property:Number of No Input Periods Per Workflow Unit - 4I thought this would prevent users from inputting data into the first 4 periods (Jan - April). However, it seems as though it is not functioning or locking the periods. I can still input into these periods.Am I doing something wrong?Thanks,Sean
We have a user that has the Solver Add-in installed in Excel. He has to disable the add-in when he wants to use OneStream. Has anyone else had a similar issue and found a different resolution other than enable and disable the solver add-in?
Hello folks, I'm trying to add a regression line on a scattered chart in Bi Viewer. I'm trying to use Calculated fields but when I arrive to the point of calculating the y in the equation I get an error as a "summary expression" is expected: [intercept] + [slope] * [V4] If I surround V4 with Max or Min it's accepted but no line is plotted on the chart. Does anyone have a clue if it's possible to add a regression line on a chart?Many thanks
Hi, Anyone knows what the LoadDashboardReasonType or LoadDashboardActionType after the user selects the parameters for the prompt upon opening the dashboard? I want to put a code after the user selects values for the dashboard parameters (see below) and click OK on the prompt. Thanks!
Hi everyone. I am looking for some assistance with using data buffers for a revenue planning form. Essentially, budgeted revenue growth percentages will be input individually for each brand by month. The total PY Actual revenue for each brand by month will be loaded into OneStream. The formula to forecast budget is:CY Budget = PYAct * (1 + Growth % / 100) While I can calculate each CY Budget cell individually for each brand by month, this would be a tedious and very long process since there are 26 brands and 12 months, which would require 312 individual calculations. I would like to use a data buffer instead to calculate CY Budget by looping through each brand (and across all months from Jan 2022 to Dec 2022). However, I am unsure of how to do this and would appreciate guidance. For ease of reference, I have also attached a screenshot of my cube view.
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
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
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.
Hi Experts, Kindly advise if there any possibility to import CSV file into Dashboard. Thanks, Naresh
Hello, I have a cube view that is driven by the workflow. In this cubeview the user sees base level entities as columns . This is achieved by using the synthax E#Root.WFProfileEntities. At the same time I would like to add a column that totals those base level entities to see what the totals are at the parent level. Does anyone know what the syntax is? Thank you in advance for your time.
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
Hi, Does anybody have a example of an business rule to import data from Sage with an API?
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
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.