OneStream Platform Forums

Hi everyone! I'm currently building a linked cube view that will inherit the Entity and IC members from the original cube view from which it is called. The IC member, though, will need to go through a transformation (remove the last 3 digits) so I created a XFBR rule to do so. For example, if the Entity member will be 1010TRW, the IC will be 1010. I tried to call the XFBR rule in the POV but when I launch it it returns the following error: "Index and length must refer to a location within the string."   Am I missing something? Below you can find a screenshot of the POV of the linked CV Thank you in advance!

Hello, I am using a cube view that has the same rows, but it needs different columns based on the UD8 member. I built multiple template columns cube views, and created a parameter for UD8 members. I want to retrieve the column template CV based on the selection of UD8. I created the following XFBR: I then attached it to the main Cube View: When I run it, and select UD8, nothing appears: If I put directly the template name, the cube view runs with no issues, showing data as well. Any idea why it is not working? Thanks, Ioana    

Is there any documentation available on standalone cube vs extensible cube? it can be pros/cons or functionality differences like data transfers

Hi - Has anyone done WEBAPI through SIC ? I followed the document and I am not successful connecting to the endpoint. All I am trying to get the HTTP response. There are no issue from the firewall and thr port are open. We are able to successfully execute the endpoint from POSTMAN.   Any help would be appreciated.   Thanks    

Can somedody help me on how to connect the golf database to OneStream 

Hi,Can OneStream consume Json data (retrieved with a API from 3rd party system) or must it be converted?Thanks

We have several workflows that for audit backup we have the users attach documents.  With employee turnover the next person didn't know they had to attach the document.  Is there something like an After Event rule you can do to check that something was attached or in a confirmation step?

Hi  I create OneStream parameters for the fields that I want to bring in from OneStream into an extensible document in order not to mess up the formatting of the document as the formula is very long to pull the data into OneStream.  Now I want to create a parameter that uses a business rule to check if the amounts for one line of the two year's  income statement (This year and last year) lines are both positive, then put "Profit" in the text of the account or "Profit/Loss" if the one amount is positive and the other is negative or "Loss" if both amounts are negative.   How do i do that ?     

Hello, I am receiving the error "Entry with the same key already exists" when trying to load a xml through a workflow. I have checked all of the dimensions, transformation rules, data sources, etc. and am not finding any duplication. Looking online I see recommendations on other platforms where the issue relates to a ListDictionary and Add within the code where it tries to add something that may already exist?  I am curious if anyone has ran across this issue and how you resolved it.   Summary: An entry with the same key already exists. ---------------------------------------- Description: An entry with the same key already exists. Error Time: 3/3/2023 10:03:03 PM Error Level: Error Tier: AppServer App Server XF Version: 6.8.1.13230 App Server OS Version: Microsoft Windows NT 10.0.14393.0 Total Memory: 68,719,005,696 (64.00 GB) Memory In Use: 1,979,629,568 (1.84 GB) Private Memory In Use: 2,175,569,920 (2.03 GB) Peak Memory In Use: 2,666,090,496 (2.48 GB) Maximum

Hi everyone! Quick question - I have a workflow profile which is used for the Actual scenario in order to post central overlay adjustments. This all works fine for our needs. However, when it comes to other scenarios like Budget, Forecast, etc, it's just not at all relevant and my hope is that I can simply switch off the whole workflow in certain scenarios. However I can't see a setting for this in workflow profiles. I can see I can easily make individual Forms and Import steps not appear according to scenario (in the "Profile Active" setting) but I can't see a way to switch off the entire workflow for any given scenario. PS - the idea is that someone doesn't have to click through a bunch of forms in the budget/forecast every time which will always have zero/nil entries in them. Let me know if you've got any ideas! Thanks,Richard

Hi Everyone. How do I add an entity to this section of a workflow profile?  

Hi All, Does anyone have any good advice on what Workspaces should be created in the application dashboards screen beyond Default?  In reading the guide, workspaces seem to have a lot of focus on separating development activities or perhaps for partner place solutions(?).  I am struggling a bit to understand at what level to offer a different workspace.  We have been toying with the idea of having a separate workspace for Actuals and Planning but as 90% of our dashboards live in Planning, not 100% sure this is the best use of this split. Any practical advice on the kind of workspaces that people are setting up that adds value?  I want to make sure we are using them in their best manner. Thx, Mike

Is there a report or dashboard that will flag violations of Extensibility rules in dimensions?

Is there a way to report on translation status like the way we have it for consolidation status- calcstatus? what would be the pov in this case?

Is there any known way to prevent a user from utilizing XFSet in Excel?

 We are loading data using SQL connector business rule and it works fine manually. Now looking for a way to load it automatically using a extender business rule and then calling from DM step. All documentation in design ref guide point to using the following code. This works when loading from a file ( with specific file format) and the file needs to be in harvest folder. I can also make it work by keeping a file which is blank in the harvest folder and still executing the workflow using the connector BR. But is there a better method which does not involve a file. Dim batchInfo As WorkflowBatchFileCollection = BRAPi.Utilities.ExecuteFileHarvestBatch(si, scenario, timeperiod, valTransform, valIntersect, loadCube, processCube, confirm, autoCertify, False) 

When an app is copied to a different environment, first we extracted & loaded the security XML (users & groups). Then the app copy was made to this new environment using Cloud Admin tool. Even after this the artifact level security on the metadata, workflows, cube views etc. did not move. All the security groups in the artifacts showed "Not Found". What did we miss? Appreciate your response.

How can I change the Row name on a cube view so it populates differently in my dashboard? Example in CV is "ESG Total", on the dashboard is "Total ESG"  but want the dashboard to say "Environmental Social and Governance Total" cube view: dashboard      

Hello,   I have a Dashboard that has an attachment button, setup as "File Upload" to the Application Database. We want the client to be able to attach files (this part is working). Due to the number of attachments, every file that is attached, will have to be tagged to a Text field for a specific Member. We'd like to tag multiple files on a single text line, separated by commas. Has anyone done something similar? How did you go about this?  Thank you for your time.

Hello, I am a new OneStream admin and I was wondering if it was possible to set up a business rule that would send an email to recipients when someone has processed a cube. The end goal would be to alert the team that changes have been made the the financials.   Thanks!

Hi All, how to copy application in OneStream from front end as well as from DB side if any have performed these tasks kindly navigate the steps please.

Hello,  Need some help to introduce an extra header on top of the Dimension header that shows up on the cubeview. I can get the count and the $ but am not sure of how to introduce the Operating Plan.  Any help would be appreciated. Thank You, Indu

Hi Everyone, We have multiple cubes in an application. Is there a way to retrieve the cube name using the entity dimension member. I have multiple entities in a excel sheet and I need to get the cube names for them. I tried the =XFGetMemberInfo(memberInfoType,dimTypeName,memberName). It did not work.     Thanks  

Hi OS Community, I am just wondering if any of you had a chance to build dynamic member list or some similar functionality which allows you to have a specified member list which will be used in a parameter (XFBR). I am having trouble to achieve that... What I created is parameter supported by simple business rule which also use information coming from another parameter. This is working well but only if second parameter which i am using is not part of POV parameters. Looks like I can not use parameter inside used parameter. where this second is also used in CubeView POV... Let me try to describe you on example what is my problem, maybe some of you will be able to help.  What i would like to achieve is to have some connection between entity selected in the cubeview POV and UD1 list of members which then will be presented as a list of members to choose inside parameter and CubeView POV. Example: I have a CubeView with POV where parameters are used for below dimensions :EntityUD1UD2UD