Discuss the features and functionality of OneStream.
Recently active
Hi All, I have a requirement to open a web URL(it is a field in the table) in users default web browser. Current solution: I could do it using the "web content" component in the dashboard. I am capturing the field in a literal parameter and then using it in the web content component to display in a dashboard. It works. Issue: Dashboard opens the web page in the dashboard window but does not render it properly. The component is pretty basic and does not have any option to customize it. It could be that it is using some costume inbuilt browser type component to display it and may not support all web page components require to display it properly. Looking for: A simple way to open the default browser in the business rule. I am sure there will some VB function which can do it but could not find it yet. has anyone ever done that? appreciate any help.
Hi Community, For us the biggest lack of the Onestream product is the ability to point to two different applications in the Excel formulas. We are a customer since around 2016 (live 2018) and we have raised this on may occasions and in many forums. It has been hurting us all along when testing developments on test vs. production - to see either that it did not impact the numbers or it had the impact we desired. We have been coping with comparing reports etc. Now we are in the middle of the first rebuild after going live - and the amount of datapoints, levels that we need to check is massive - while we still wait for this most obvious long term deficit, in an otherwise very good product, to be fixed, we turn to you guys. Can any one share their approaches to compare the data between applications in the development process in generally. Kind regards Per
I want to create a new application in our production environment, but I only want certain people to have access to the application. How do I add security on the application? Thanks, Winni
Statement: You can do a direct cash flow in OneStream. Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Hello,How can we navigate to a specific workflow step from a button? That workflow step holds a form template group at present. Can we have navigation on button click to that form template group?Any leads would be appreciated.
Hi- Our scenario is set up as Range ( say 2022M1 to 2024M12). I have a database table which have Jan to dec as columns and I have Year also as a column. So we have different year 2022, 2023 as rows and the data is in Jan to dec. IS there any way to load all of this together. Right now i can use a matrix data and put in a complex expression which can either say workflow time & "M1" etc or i can read a literal parameter read the year to be loaded and i can concat and return in the data source. But is there a way in data source complex expression or a parser business rule that I can get the value of another column in the data source , so i can reference what is the field value of the year and the concatenate that.
Is there any way to do a GetDataCell in a Cube View or Quick View where the members are dynamic/based on some criteria? The formula below doesn't work, but hopefully give you an idea of what I wish did work. GetDataCell(SUM(E#TopEntityMember.Base.Where(Text5 = 'Germany'))):Name(GermanySum) I know you can add specific members together in the GetDataCell, but I'd like to be able to have one row that shows the sum, which is based on a property value that can be changed or be able to use it as a member filter and not have to display it in the grid.
Hi, I am building cube views that should be accessible by several users based on the workflow they are affected to. These cube views are the same, but each workflow has its own entity. Therefore, the same cube view will be available through several workflow, and the entity (or entity selection) should change based on entity affected to each workflow profile. I'm probably missing something, but the problem is that there are no (known) parameters that would simply give me the list of entities attached to the current workflow profile... what would be the best way to achieve this ? Regards,
Hi all, I have built out my cube view that shows headcount change for 2019 M12, I want to be able to capture the ‘Ending Balance Headcount’ for 2020 M1 as its ‘Begin Balance’. Will a rule be the way to go in order to achieve this? Unsure on where to go from here. Thank you.
Is there a way to export the Transformation Rules into an Excel file?
Hello All, Could someone guide on how a system business rule is triggered? As part of automating some daily tasks, we intend to automate addition, deletion of metadata members through a system business rule. Is the process similar to triggering extender rules? Any leads would be appreciated. Thanks
Statement: I can run any business rule in the business rules section in order to test it. Question Credit: Chris Bielinski Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Hi !I am trying to use a Drill Back option in my Data Connector.So far, I get the data from my connector in the staging area, which is great. Now I am trying to open an invoice document, which is stored noth in FileShare, or in Application Database for test purposes.However, even though I get the drill back types name, when trying to open the PDF file I only get the message "querying source system" and then nothing happen!Do you know of any reason why ? I thought it was a simple business rule ... Regards,
Hello All, I have one specific query about data Management Tasks as below: If I want to allow a user to be able to edit parameters of only one of of the DM Group and not to allow edit anything else - Question is >> which 'Security roles' need to be looked at? I can see only way to allow editing is to allow Security role 'ManageData' BUT this allows everything and all DM tasks and even user can setup a new DM group - which is really risky and can not be allowed. Kindly help with your comments if I am missing something here. Our current status is, we can not allow users to edit the DM tasks and we keep on making parameter changes for business users, which is really a big pain. You guidance here would be really very helpful. Thanks Satish
Business Rules can be used to load data into OneStream even after certification and Data locking. Rule writers must take care and ensure that the rules has syntax lines to prevent such things for happening. Any other comments on this topic from the experts?
TeamI have 2 concerns:-Few members under account dimension i see grey out which am not able to edit. How do i make them editableHow do i mass delete the members in Hierarchy and under Orphans without loading the entire metadata RegardsVarun
Statement: I have People Planning in my application, I can set this up so that only some people can see the data – and not the CFO admin Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases Want more Fact or Fiction? OneStream Press Authors are subject matter experts... but do they know about the 80's, sports, movies, or other pop culture trivia? Are you able to tell if their knowledge is fact or fiction? If so, come for the crown, stay for the fun, and emerge the new Fact or Fiction Champion at Splash San Antonio. Prizes will be awarded! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!
We recently migrated from the legacy “client API” to the “REST API”. They are fairly similar and the migration was straightforward. We use these interfaces to retrieve data via custom “cubeviews”. The cubeviews act as a vehicle for exporting business data from onestream cubes. However it would be more convenient if we did NOT have to build and deploy cubeviews each time we needed a new piece of data. I have not found any mechanism for this yet, either in the old “client API” or in the “REST API”. In other words, it would be nice if there was an “ad-hoc” mechanism for retrieving data programmatically from dimensions and cubes. I haven’t found this yet, in the OneStream “DataProvider” interface. I see that there is an option for running SQL queries but I was told to avoid it since it is low-level and is used to interact with raw/internal SQL tables whose schemas would not be meaningful from a business perspective. In short, I’m wondering if there is a way to extract data progra
I have some experience retrieving structured cube data from the REST API named "GetAdoDataSetForCubeViewCommand". However, I'd like to get ad-hoc information. Ideally there would be another method that is analogous to retrieving data from an Excel "quickview". Did I overlook a "quickview" mechanism in the REST API? I am using the documentation named "REST API Implementation Guide", but it doesn't mention anything that looks promising. Perhaps there may be some undocumented approach? The cubeview already does much of what I need. However it requires preparation (the cubeviews must be prepared ahead of time and deployed to the server). It would be better if the API allowed "quickviews", since they don't require any previous preparation or infrastructure. Currently we are using Onestream v.6.3.0.
I'm working with a BI Viewer and working out how to sort the dates within the Time data set. Is their an API that allows to call the data adapter used within a dashboard? Currently the dates on the X-Axis are disorganized and are being sorted based on M1x, M2x which causes October (M10) to precede after January (M1).
Even a simple globals.getObject("_ex") throws a object reference not found error. Is the use of the globals object prohibited inside a spreadsheet rule? The code: Error log when this spreadsheet rule is used: But if I comment out line number 24, the error log becomes:
Hi All, in OneStream 6.x some functions in Business Rules became Obsolete. One of them is the BRApi.Database.GetCustomDataTable where the initial script required a string as CriteriaExpression but now it requires a list of dbWheres. That part I fixed. There are also functions that are not available anymore like: 1) Warning at line 418: 'Public Shared Overloads Function CreateSubstVarSourceInfo(dbConnFW As DbConnInfo, dbConnAppOrFW As DbConnInfo) As SubstVarSourceInfo' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality.'. The SubstitutionVariablesHelper is not available anymore. Has anyone an alternative to this function (often used in MarketPlace solutions)? 'Create DBConn Infos (Only Used for EngineIfStatement Expression Processing) Using dbConnFW As DbConnInfo = BRApi.Database.CreateFrameworkDbConnInfo(si) Using dbCon
Hi All,Has anyone integrated OneStream with OKTA in their organization to enable SSO login into the OneStream applications? Any leads/suggestions would be appreciated.Thanks
hi,i have a long running DM job which was triggered from ControlM using the REST API. The problem is controlM couldnt wait for the DM job completion to mark it as completed since the DMjob takes more than 2 hours to complete. Can we write a seperate function which sends back the DM job status from OneStream so that controlM can polls and check for the DM job completion. Is there an API method available which gives out the status of the DM job. ThanksVijay
Hi, this might sounds like a stupid question to the more experienced people in the community, but how do I refer to the workflow variables from within an extensibility business rule? These 2 lines of code are of course not working: Dim sScenario As String = |WFScenario|Dim sTime As String = |WFTime| Any hint? Thank you
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.