OneStream Platform Forums

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?

 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

Hi there, From other security related questions posted in the community, I understand there are templates for creating user and user groups in OneStream. I would like to know is there a similar template to assign user into their relevant user groups as well? Any suggestions would be helpful. Thank you. JC

We have summary dashboards with a lot of information. I'm trying to find a way for users to filter down on that information and have created 2 combo-boxes. However, none of the data pulls through. How do I make those combo- boxes (parameter values) dependent on each other? The idea is when a user selects the first "Resort" box only that resort's projects will be shown in the dashboard. Secondly, the second combo-box "Entity" would only return the entities from within that resort selected (step 1). Currently, no data pulls in when either parameter is selected. If I remove either of the combo-boxes, leaving only one, it works properly. 

We have files that utitlize vlookups or sumif formulas  when we save an offline copy the formulas do not work after. I have found many times that if I change the value I am referring to in the formula to a text format, it saves them, but sometimes it is not always the case. Has anyone else had this issue and what is the work around? 

Hi,  Could someone enlighten me on what happens if no currency is set for entities?

Hey all, Pretty new to programming but have manage to get a file moving rule to work that basically moves a file from FileShareBatchHarvest to Application /Public structure for users to pickup.  However, the rule currently needs the exact name of file. I have tried using wildcard symbols like "* #" for the date with no success.  Does anyone have a recommended solution to get the variable dynamic on the date section?  

Hi, is there a way to present the "Cube Root Workflow Profile" description in the workflow selection window rather than the name. So in this Example below it would say Test rather than GolfStream? Thanks

Cash Planning rolling forward, Capex tracking in OS: Anybody experience to share in this context?

We want to use a dashboard to run our books using a data management job so that they can continue to run in the background while the user works in OneStream.Using a button on the dashboard triggers an Export File data management step from a data management sequence. When the sequence is run by itself the book dialogue window opens. But from the dashboard the dialogue window does not open and instead the POV members are passed from the cube POV. Dialogue Window when hard coded and run directly from the Sequence. Similarly when a parameter is entered for the Url or Full File name, the dialogue window does not open, but does when the Full File Name is hard coded. No dialogue window. Dialogue window appears. How can we get the dialogue window to appear while keeping the dashboard dynamic to be able to run any book. Thank you.    

Hi All, does anyone built a Smart Integration Function and compressed the datatable with CompressJsonObject and then, in the extensibility rule, inflate it with InflateJsonObject using the variable bulkRemoteResults.resultDataCompressed ? I'm getting the error: "Object reference not set to an instance of an object". If I compress itand inflate it in function worked and in the extensibility rule worked. But, compress in the function and inflate in the extensibility rule didnt work. This is an example in the guide, so I'm not sure if I'm missing something. Thx in advance

Dear community, With 7.4 onward, we have the concept of "Workspaces", which usually works well. For one of my requirement, I need to embed a dashboard which is on another Workspace. The problem I am facing, is that the parameters that are currently in combo boxes are not recognized when I do so. When I open the dashboard as usual (ie not embedded but as a regular dashboard), then I don't have this issue. How to solve this situation ? My parameters are delimited lists and bound lists. When I open the "main" dashboard that embed the targeted dashboard in Design Mode, it recognize these parameters but these are shown as empty. EDIT : oddly, a similar issue apply to the "Refresh", as my embedded dashboard are getting refereshed as expected when open as standalone, but not refreshed when the dashboard from another workspace is embedded... Regards,

Hello Community - Looking for guidance on options to calculate data at QTD to overwrite the number generated from periodic values. This intersection has an option for users to enter periodic values, so I cannot make a member dynamic calc. I am using UD8 dimension member for the calc. Please share your thoughts. Thanks!  

I'm trying to load plan data into a range scenario that spans across 2 years. While the workflow view year is 2024, the range is set from 2024M1-2028M12, so the expected result would be that the load can occur for the 2024 and 2025 data that is being loaded in this import step. Is that hypothesis true?  The primary question is: What is the difference between workflow view year and workflow range? Additionally there is an icon in the workflow that "cannot import data to time periods 'AFTER' the workflow view year [2024] (see below).  In the application properties, there is a setting that allows loads after workflow view year.  When this is set to true, the icon goes away and data can be loaded to both years. We are trying to avoid flipping this switch to keep users from accessing any time periods not within the range. 

hi folks!  I'm seeking advice on overcoming the obstacle of exporting data from an Operating System (OS) to make it accessible for a Business Intelligence (BI) solution. Currently, my goal is to export data into a STAR schema within an external database. While I know this task is achievable, I'm curious to learn if anyone has leveraged the OneStream WebAPI or any other innovative methods to retrieve data instead. Would appreciate insights or experiences shared on this matter! Cheers Frank