OneStream Platform Forums

Hello, I was wondering if it's possible to have a check figure if the amount equals 0 that it displays "OK" and if it doesn't it says "Check Details". I've tried conditional formatting when the cell amount = 0 then "OK", but I figured I'm missing something or this might just not be possible. Thanks, Will

All,I have a form populated with data & I am trying to retrieve the data through the Finance BR under calculate. It is not displaying the data in the error log.Sample Data. I am trying to retrieve the data at Parent Entity with Base ICP intersection. BaseICP - 3000Parent Entity - P10000.2The below is the code If api.Pov.Scenario.Name="Actual" And api.Pov.Cons.Name="Elimination" Then              Dim Entity As String = api.Pov.Entity.Name              Dim Parent As String = api.Pov.Parent.Name              Dim Ownership As Decimal = api.Data.GetDataCell("E#" & Parent & ":C#Local:S#ActualOwnershipCalcs:A#UltimateOwnership:F#None:O#Top:I#" & Entity & ":U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None").CellAmount       &nbs

Hi All,  I create a spreadsheet business rule to refresh the data from external table using Table Views, now our users wants to drop these files into OneStream file share on daily basis so external systems can consume.  Is it possible to use parcel service to refresh these files (using table views with in the spreadsheet) and drop them into file share every time the job trigger ?  Or Is there any alternate approaches to export data from custom table to excel files ? Thank you. 

Is there a way to hardcode a number into a cubeview?

Hi All, Working with a dialog box with 3 parameters that are being used in a business rule later on. I want the parameters on dashboard load to always show the first value in my delimited list. Right now it always saved my previous selection. I have tried to set "Default Value" in the parameter itself, that dosen't work, guess it is only working on first load? I have tried to run a Dashboard extender BR like below to set param values on load of dashboard, but it dosen't overwrite my previous selection.: Only thing that have worked this far is to set a bound parameter with a set value on my button that opens my dialog box. However it seems to only let me add one bound parameter, I have 3.    Anyone having any advice how I can set one value from my delimited list to always appear when loading my dialog box. 

I'm trying to build a label that shows target goals for each entity. Now since each region has different goals. I'm looking for my label to change the value based on the entity selected.  Here is an example (We're still in development so not the most eye catching) Its referencing a parameter --  How can I pass a condition or a rule that reads the POV entity and shows me that specific value.

Has anyone been able to successfully obtain a parent name for a member, within a UD8 formula without needing to leverage a text field on the member (using Parent Sort Order for example)? As an example, I have a base level entity member of B1229 (this is Branch). I would like to return D1229 - Chicago based on its' parent sort order of 2 (this is District). Appreciate any insight!

Hello,I know you can center columns in a report, but is there a way to do this for cube views exporting to excel? I've only found a workaround where you go to export it to report and then change it to excel, but this won't work for us longterm.Would like to be able to do this - ok with either embedded or just exporting. 

Hello All, I have a Cube View that I want to use as data source for a BI VIewer object. When I execute this CV, I can see data: When I use this (basic) CV as MD in data adapter, it is empty. I checked the set up steps in the doc and I can't see what I could have missed.   Would you have any ideas why the result table doesn't return values that I can see in my Cube View ? Thanks for your help Matthieu  

We are working on a POC to extract data using FdxExecuteDataUnit.  We are using an Extensibility business rule and running it using a DM job.  I am getting assistance from our corporate IT group as I am not good with C#.  The business rule is writing data to a table and then is taking the data from the table and putting it in a text file.  There is something missing or wrong with this and I am hoping someone can help with the code since I do not have access to the TechTalks that focus on FdxExecute. The code was written to do the FdxExecuteDataUnit and then also write some sample data to the table.  This way if the FdxExecute does not generate any data we at least get a file with the sample data.  I am getting a file but it only has the sample data spelled out in lines 100-150 of the business rule.  I am also getting the following warning when I compile the rule:  "1) Warning at line 54:  Unreachable code detected" If I comment out that line

I've tried to implement this function as per the Business Rules Editor snippet: Dim objByte() As Byte() = BRApi.CubeViews.Process.ExportCubeViewGridsToExcelFile(si, custSubstVarsForAllCubeViews, cubeViewNamesAndVars) However, I've had a few problems with this, the main one being that I've been unable to save whatever it returns to an Excel file. Here's what I've tried: Dim fileName As String = "test.xlsx" Dim filePath As String = $"Documents/Users/{StringHelper.RemoveSystemCharacters(si.UserName,False,False)}" Dim XFfileDataInfo As New XFFileInfo(FileSystemLocation.ApplicationDatabase,fileName,filePath) Dim XFfileData As New XFFile(XFfileDataInfo, String.Empty, objByte) BRApi.FileSystem.InsertOrUpdateFile(si, XFfileData) Whenever I run this code the output file is an XML. How do I save this to a .xlsx file?

Hi All - I have a scenario where I need to copy the data from Parent Entity to the Base Entity with ICP.  ThanksKrishna

Hello All, SetDataCellsUsingMemberScript() seems to only write the last value added to list.  I am successfully adding 14 records to the objMemberScriptValues list (I can loop through them and see the 14 unique intersections) but only the last one is being updated in the cube. I'm looping through the records in a datatable and then each intersection is added to the list: '*********************************************** For Each row As DataRow In dt.Rows   strProfileName = row.Item("ProfileName").ToString strCube = row.Item("Cube").ToString strEtT = row.Item("EtT").ToString strCnT = row.Item("CnT").ToString strSnT = row.Item("SnT").ToString strTmT = row.Item("TmT").ToString strVwT = row.Item("VwT").ToString strAcT = row.Item("AcT").ToString strFwT = row.Item("FwT").ToString strOgT = "Forms" strIcT = row.Item("IcT").ToString strU1T = row.Item("U1T").ToString strU2T = row.Item("U2T").ToString strU3T = row.Item("U3T").ToString strU4T = row.Item("U4T").ToString strU5T = row.Item("

Hi everyone, I have to do some systems diagnostics but I cannot run the dashboard because there is an error in the business rule "OSD_SolutionHelper". This business rule does not compile due to an error in line 4882Dim computer As New Microsoft.VisualBasic.Devices.Computer()Error: Type 'Microsoft.VisualBasic.Devices.Computer' is not defined. Anyone else encountering this issue? We are on version 8.4.0.16413. RegardsMartin  

Hi everyone, Good day. We are new to OneStream, and we are building a cube view wherein it outputs quarterly columns for a certain year. However, it only outputs the last period/month for the quarter. For example, under the Q1 Appliances, it shows 305,221,004. But, if I drill down on quarter 1, I can see that the amount per month when totaled, it is equivalent to 607,036,638. This also applies to the 2024 column, it only shows the Q4 value and not the sum of all quarters. I already tried to consolidate and calculate, but it is still the same.  Thank you for those who will share their inputs.   

Hi, I am testing V 7.2.3 in our Dev environment. Production is still on 6.5. The security and user groups, data sources, and workflow profiles are identical between the two. I am able to import and validate TB's in the workflow, but several others are not able to Validate in the Dev environment. Has anyone else experienced this?  The validation message is "No Security Access", but the workflow profile and security groups are idential to prod. Thanks!

I created a new dimension member as a child of our direct_department member in UD2.  I have updated all of the transformation rules and mirrored the member properties of its siblings.  I have loaded this month's data which includes the new department and none of that department's data is showing up following the load/transform process.  I'm not receiving any errors either.  Has anyone experienced this or has an idea of where I can look to resolve the issue?

Hi experts, hoping someone can guide me.   Our P&L is recorded by Line of Business (UD2), however our balance sheet is recorded to UD2 None.  FPA has a requirement that they currently handle manually to "allocate" the balance sheet to the lines of business based on the percent of revenue.  Our partner initially achieved getting closer by using a dynamic formula on UD8.  This does not ultimately provide the accurate results at the consolidated level (due to nature of dynamic formula).  We believe we need to change this to a formula pass but it is proving to be challenging.   We are open to suggestions, using UD7 (tracking) or UD6 (reporting).  I am also open to creating a mini alt acct hierarchy since it really only needs to apply for a handful of summary level accounts.  (Coding examples would be so very appreciated!)  Thank you! 

Hi,is there an easy way to setup a workflow step to run a data management sequence?I have an existing data mng sequence and I'd like users to run it from a workflow profile.Thank you

hey All, I have request to dump out all the imported source documents to a central location. Not sure if it is possible. Looking for some information on Where these files/documents are stored within OneStream is there a way to export these files using a BR              

Hi there, We need to see cube view figures which are rounded to an integer. Could you please advise how to round figures in cube view?  

I'm trying to execute a calc after an input data in a CV, when the user click in the OS default save button (giving the flexibility to use a DB, CV or Excel addin with the same CV) Is possible?

Hi, we are implementing OS at present, and this is our first-ever project in OneStream; I need guidance on Business Rules. I am not sure what business rules we need to consider after and before we import the data from the Client system to match the client's legacy system data with OneStream numbers.Thanks,Preeti

Dear Community,Since I can create a weekly calendar using a customized Time Dim, what is the "Fiscal Year Month Type" such as Fixed week 4-5-4, 5-4-4 in the time profile used for? If it is used for fiscal year purposes, how can I see the impact? I tried to play around time profile, and it doesn't seem to impact anything. Please provide some ideas. Thank you

Hello,I have parameter a specific POV on an Excel sheet and want to duplicate it on another Excel sheet.The QuickView Option to duplicate is only available in the same sheet.I tried to copy the file and then move the sheet to the previous file but it doesn't work.Is there a solution? Maybe to copy the POV to make it applied in the new one?(I know I can parameter the default POV to initialise it via the OS app but I need to keep the POV in 'black' to fix it whatever the POV initially parameter)Thank you