OneStream Platform Forums

Hello, I am trying to create a Dashboard with several cubeviews in it. I created a delimited list parameter with different categories of cubeviews. Does anyone know how to assign the cubeviews to the different display items?For examples, I will have a category "Sales" and when the user will select "Sales" in the drop-down menu, I want certain cubeviews to be displayed in my dashboard. thank you!!

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.  

Hello OS community,I am currently developing my Cash Flow Statement  and I want to add a condition for a loan account. If it has a positive balance in the Working Capital Requirement  variation flow, I want to map it under one CFS table. However, if it has a negative balance, I want to map it under a different CFS table. How can I implement this condition in my Cash Flow Statement?

Hello,      I am having trouble with a selection screen on a Dashboard where items are moved from one ListBox to another. It is a multiselect=True but how can we have the items selected on the 2nd list box. I have to read this list in a BR but until and unless they are selected the item is not passed to the BR for further processing. Any help would be appreciated. Thank You, Indu

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 

Hello,There is this grid view property that has been bugging me for a while called 'Show Row Headers'. Using VB.Net, we cannot define 'Headers' for the rows of a DataTable object, so I'm curious to know how to use this property to the fullest ?By switching it to 'False', the only noticeable difference is this little blue arrow that disappears: I assume that we can have a CubeView-like formatting with Row & Column headers using the grid view, but I can't seem to enable it.Thanks for your help.

Hello, I mistakenly added a sub parent along with 3 base accounts to an alternate hierarchy.  Is there any way to remove the parent child relationship in the alternate hierarchy without removing it completely from the original hierarchy? 

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?

Looking to shorten a report so it fits on one page. The Auto fit to Page Width is set to True.Using General Settings, Report, is this achieved by adjusting the bottom margin? How else might this be achieved if the above is not the option.   

Dear community, Upon saving a Word document, I would like to apply some logics to my document (like data cleansing). My question is, is there an event handler business rule that we could use for that ? Regards,

 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

Hi, I am trying to establish a connection between OneStream and my local SQL server but getting below error. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (SQL Error Number -2146232060, -1) Business rule and error  

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, We have a Dashboard Maintenance Unit which requires a user to have maintenance access for the object to be able to open the dashboard. In which cases is it necessary to have maintenance access for a dashboard if you don't need to maintain it in the Application-tab?  

Hi all, looking at the Train Me download available in the OpenPlace exchange for our org. Am I following correctly that this is ONLY for video uploads? Some of our users do not like videos and prefer a quick reference guide instead. I'd like to layer both options in ....curious if anyone has rolled this out and your thoughts. Also open to any other suggestions for documentation on training and MEC task how-to's.  We have a Teams site but it's clunky at best and would like a one-stop place for all the info. Welcome any insight, thank you!

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?

Hi OS Experts: I have an existing hierarchy called "ControlMgt Hierarchy," which has several rollups underneath it. I need to recreate a new hierarchy named "ControlMgt Hierarchy_ALTERNATE," where "_ALTERNATE" will be added to all the rollups. The base elements will remain the same between the two hierarchies. I’m considering exporting the "ControlMgt Hierarchy" and updating it to include "_ALTERNATE" for all rollups in the XML file, and then importing it into the entity dimension. Is this possible? Will this create a new hierarchy, or will it overwrite the original hierarchy? Could you please suggest the best approach to accomplish this?

Hi, I wanted to know what the difference was between the following security: Workflow Execution and Workflow Access. Can someone please help.

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 am an administrator however it will not let me change the colour of the onestream dashboard (This is for the test environment). It is greyed out so will not let me change. How do i change the colour? Thanks