OneStream Platform Forums

I am trying to call a cube view extender Business Rule assemblies from a cube view. Not sure if I am missing anything. I looked at the reference manual and followed how it was defined in the manual.  Cube view extender BR Assembly   calling the assembly from the Cubeview.  

Hi all,I have a simple cube view where on the row I have Tree expansions, like the following one:UD5#MemberName.TreeThe reason I am using Tree instead of TreeDescendantsInclusive or others is because I want the rows to collapse on opening  and RowExpansionMode=CollapseAll only works with Tree for the first dimension of the row as far as I now.Now, the issue is that I would like to remove a member from the rows and the Remove does not seem to work on Tree, while it works on TreeDescendantsInclusive and others.U5#MemberName.Tree.Remove(U5#None) returns this (expansion enabled=yes, none removed=no):U5#MemberName.TreeDescendantsInclusive.Remove(U5#None) returns this (expansion enabled=no, none removed=yes):Is there a way for me to have both the ability to expand/collapse the rows and remove members from the hierarchy, or it is just a trade-off with the impossibility of having both at the same time? Thank you 

Hi All,I am trying to use a font in Onestream which seems to be working fine in the cube views and Excel extract, however it it does not work in PDF. May I know the reason why it is not consistent? I have updated application properties, hard coded in business rule, and added the font family in the cube view itself. But does not work on PDF which is the most important one.Any suggestions?

 Hi All,I'm encountering an error while trying to import data:"No valid DataKeys (Scenario / Time) found in data source. Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source."I've attempted both options for the time dimension—applying 'Datakey Text' and then assigning the Time field, as well as using the 'current Data key time' options—but it’s still not working.For reference, I've attached the relevant code:```csharpvar fields = new List<string>{"ACCOUNT","ACTUAL","Time"};return fields;string wfYear = TimeDimHelper.GetYearFromId(api.WorkflowUnitPk.TimeKey).ToString();int wfMonth = TimeDimHelper.GetSubComponentsFromId(api.WorkflowUnitPk.TimeKey).Month;string periodName = $"{wfYear}M{wfMonth}";var sql = new StringBuilder();sql.Append("SELECT ");sql.Append("ACCOUNT, ");sql.Append("ACTUAL, ");sql.Append("Time ");sql.Append("FROM [tablename] ");sql.Append

Hello,  I'm trying to delete a File Share file but getting the error in the Subject above and I don't know what's causing it - I'm hoping someone can help.  This is my code: Dim fileName As String = "MyFile.csv" Dim folderPath As String = BRApi.FileSystem.GetFileShareFolder(si, FileShareFolderTypes.ApplicationRoot, api) + "\" + si.AppName + "\Groups\MyFolder BRApi.FileSystem.DeleteFile(si, folderPath, fileName) When this runs, this is the error:  "Conversion from string "\\sgc000462adev2.file.core.windo" to type 'Integer' is not valid."  Why is it trying to convert the folderPath to Int?  How do I fix this? Thanks in advance for your help!

Dear all, Is there a way to show for instance journal data and also identify which are the names of the journals involved in a given intersection? For instance if there are 3 journals going to the same intersection, recover in a CV 3 lines, describing the detail for each journal name? Thank you in advance.Best regards,Carlos

I cloned an existing connection that pulls the Scenario and Date from the workflow.  The new connection is requiring me setup a  New Scenario Transformation rule that is basically Budget --> Budget and time rule 2024M1 --> 2024M1.  The connection I cloned doesn't require the additional rules and was pulling Actuals.  All my Data Sources, Scenario, and Workflow settings seem the same.  Any suggestions on what I am missing?  I don't want to maintain the time rules, so that's why I'm trying to see what I'm doing wrong.

Is there a way to determine the number of data cells by account-type dimension member? In our example, we are reviewing an implemented application with millions of ZeroData cells and are trying to identify which account formulas are producing the most zero data cells.System Diagnostics has a "Data Volume Stats" tab that lists data cell status counts (i.e., RealCellCount, ZeroCellCount, etc) by data unit. However, there does not appear to be any reports that display this information by account. Has anyone had success retrieving this information via a different application report or custom SQL query (against the application database)? This is probably unrealistic to retrieve (given the data volumes required), but maybe there is a way I haven't yet considered.

Hi all,I am trying to build a business rule to dynamically disable a button (become invisible) once the form status is completed. May I know is there any function I could leverage on to fulfill this functionality?Any suggestion would be appreciated. Thank you.Best,Jacky

I am having to build a lot of alternate hierarchy for external reporting, so I am going and building relationships with our main hierarchy. The problem I am getting into is every time I search for an account (example), OS collapses the hierarchy path where I need to "paste relationship", so I have to reopen it every time, and with a few levels to open, it is getting incredibly tedious. Anyone knows how to stop OS from automatically collapsing hierarchies?

I am trying to copy data from external database to OneStream SQL table. I am trying to achieve this by using Extensibility Rule. Can someone help me with the rule to save data into Onestream table.

I'm attempting to send an email with an attachment from a file stored in File Explorer. What does my file path look like if the file is saved in File Explorer->Application Database->Documents ->Public?  Regards,Anusha

Hello, we encounter the following behaviour with the OneStream Desktop Client and the Excel Add-In: The Server Adress URL is stored in c:\users\[username]\AppData\Roaming\OneStream\Common\Settings\webserverurl.txt As soon as I click connect, the URL stored in the webserverurl.txt file gets deleted with the next start of the desktop application or the Excel Add-In, the Server Address field is empty and I have to get the Connection URL by clicking the three dots next to the Server Adress field (which is quite annoying). Does anyone of you encounter the same issue? Regards Martin Gebhartl

Text1 in workflow has two entity seprated by "/"   Text1 parameter Entity1/Entity2   I'm trying to achive rule   If entity=entity1   calc1   else if entity = entity2   calc2        end if  end if     How do i retrive entities in text1 seprated by "/"

I need to create a business rule that will move a file from a user's folder in File Explorer to the server's File Share. I am using the BRApi.FileSystem.GetFile method to successfully read the file, but I am unable to write the file to the server. I believe my issue is with the XFFileInfo parameters. I am not sure how many parameters to provide and what the value to provide for the folderFullName parameter. Here is my current code: 'Get the file Dim sourceXFFileEx As New XFFileEx sourceXFFileEx = BRApi.FileSystem.GetFile(si, FileSystemLocation.ApplicationDatabase, sourceDir & "/" & sourceFile,True,True) 'Save the file but this part is not working Dim targetFileDataInfo As New XFFileInfo(FileSystemLocation.FileShare, fileName, ??) Dim targetFileData As New XFFile(targetFileDataInfo, String.Empty, sourceXFFileEx.XFFile.ContentFileBytes) BRApi.FileSystem.InsertOrUpdateFile(si, targetFileData)  

Hi Everyone,I am actually trying to make a dashboard that let users execute different sequences from data management without accessing the Application tab so i am using a dashboard with a combo box that lets you choose the step you want  and a button to execute it.The problem is that i don't know how to send to the button the sequence i chose from the combo box and how to make so that the button can execute any sequence i chose without preparing the parameters in advance like we do in the data management tab where we run then choose parameters we need. I already linked a parameter containing the list of steps to populate the combo box but i don't know how to send the selected step to the button to run it. Thank you.

Hi ! I'm looking for a way to change a value of an input value parameter type using a business rule. The use case is quite simple : the user will input a value in order to calculate a data. However, using a button I would like to "reset" the input value with another value. I can easily change the value of a "litteral parameter" with a business rule, but I dont know how to change the value of a "input value" parameter type (needless to say, a litteral parameter will not allow my user to input a value !)  ... so what would be the best way to achieve this ?   Regards,

Hi,While we copy from Scenario S#Bud1 to S#Bud2, Annotations are not getting copied.Understand from related posts, it can be achieved using api.Data.SetDataAttachmentText(). Any tried approach using this syntax.Any leads would be appreciated.Thanks

Hi All, I am aware of various options available for copying scenario data in OneStream. These options (data management or custom calculate) usually copy only periodic data across scenarios. Any idea how annotation data can be copied from sceanario1 to scenario2 in OneStream? Any leads would be appreciated. Thanks Bharti

What is the best way to query the Security Roles and their assigned Security Groups in the Application. It would also be helpful to query security roles assigned to Workflows. Any ideas?? 😕 Thanks.        

Once my SIC Gateway is online, how can I apply the data sources to specific workflow profiles? The "data source name" shown on the Custom System Configuration is not one of the available options to select for the workflow profiles.

Is there an audit on FX rates, to see who updated the FX rates?

Hi,I have created a dashboard with a Reset Scenario button.The code behind the button updates the workflow time, wf start time and wf end time of the workflow scenario (there is actually a dialog dashboard in between, i.e. when I press Reset a dialog box opens asking what the new WF Time should be, and user can press OK to reset the scenario or Close the dialog. WF Start and End times are determined based on the WF Time).The issue I have is that the workflow POV does not change, unless we click on a different workflow step, which can be confusing. So if I change the WF Time of the scenario member, using the Reset button from 2024 to 2025, the workflow time POV (the one shown in the OpenPlace tab) does not change, but as soon as I click on the following step (eg. Seeding) the workflow time POV changes to 2025.How do I make so that the Reset button forces the workflow POV to refresh? Do you think is something that I can achieve at dashboard level (through refresh or redraws) or business

Hello,The client would like to view forecasted, budgeted and PY data based on a ratio that takes into account current day of the month for Periodic and YTD data.Below, is a functioning calc. Use Case: it is October 22nd, and the client is using daily uploads for Sales. To get a more accurate view of the Sales compared to the scenarios listed above, they want to multiply the monthly total by the factor relative to the day of the month. E.g. if Sales is 100,000 for the October budget (periodic), but it is October 22nd, we would multiply (100,000 by (22/31)), the cube view would show 70,967.74. The calculation in a UD8 member above represents this logic.The tragic flaw is that if view the data in YTD view, it takes the entirety of the YTD amount by that ratio, when I only want the current month to apply the ratio. What would be the best way to approach this? Ideas:Use a ratio that uses total days of year up to end of current periodE.g. In October 22nd, 295 total days have p

Spoiler (Highlight to read)  Hi everyone,I am trying to replicate an example that i have created in OneStream 8.2, where I have a combo box inside a cubeview:But when I do the same in OneStream 8.4, the combo box doesnt work:I replicated the same parameterization in both version but I dont understand why in 8.4 doesnt work.Does anybody knows if there is a bug? Thank you