OneStream Platform Forums

Hi all, new OneStream consultant and developer here. I am trying to build out a cube view for a client and I think I need to use CV math for one of the columns, but I am not sure... I need my 'Var%' column to show the difference of Actual and Budget scenarios, which I assume should be very simple, but I do not know how to do it.  Here is a partial screenshot of the Excel report I am re-creating: The row this intersects with is using the following: a gross profit account and a U8 calculation for percent of rev. The current data is showing the percent of rev for the Actual column. Do I need to use CV math within an override to get the desired result?  Thanks in advance!!!

My requirement is i need to provide few users(Admins) only oneplace and system tab access, and few users(Admin) i need to provide only oneplace and application tab access.Please any one give me detail steps on this, Thank you.

How do we delete the seeding data for a specific entity and month without an import workflow or resetting the whole scenario?

This post is to illustrate how to call a public function of a Finance Rule from within XFBR rule. The Finance Rule has a function called EntityText8 splitter, and I need to call it from within a XFBR rule. To make it work, first need to make the Finance Rule "True" - Contains Global Functions for Formulas (in Rule Properties) and refer to the specific rule assembly in XFBR rule properties (screenshot2). The XFBR rule reads: '-------------------------------------------------------------------------------------------------------------------------------- 'Returns the Entity in Text8 or emtpy '-------------------------------------------------------------------------------------------------------------------------------- 'BRString(SeedingXFBRStrings, Text8Entity, curEntity=|CVEntity|, curScenario=|CVScenario|) 'XFBR(SeedingXFBRStrings, Text8Entity, curEntity=|CVEntity|, curScenario=|CVScenario|)   If args.FunctionName.XFEqualsIgnoreCase("Text8Entity") Then   Dim curEntity

Hi! I just ran a parcel and didn't receive an email.  This has been working fine.  The log shows it was successful.  Email's not in junk folder either.  Do you know what else I can check? 

Hi All, I am building a roll forward form and I am able to get Beginning and ending balance through business rule. I am not able to input activity manually in activity roll forwards as the fields are disabled. Please see the attached picture. I have checked all POV and everything but could not solve the issue. I am attaching the picture of POV and flow member for your references.  

Dear Community, we have a requirement to add Pie chart (BI Viewer Component) to the dashboard reports. we were able to see the pie chart when we ran the BI Viewer component but when attached to the dashboard it does not show the pie-chart. Here are the properties we used for the dashboard. Any solutions to this will be helpful and appreciated.  

I have a cube view that utilizes a shared Row and Column set. The row set has roughly 300 rows. Is there a way to Supress NoData Rows across the entire cube view - as opposed to modifying the setting row-by-row? Thanks, Matt

Hello, The customer would like to explain a dollar variance between Budget and Actual by leveraging 4 columns of data to explain the difference displayed: enter a dollar amount, a combo box to select a type of UD1 data timing (Perm/Temp) and another combo box to select UD8 driver type (Audit Change/Scope Change) with the last column for a comment.  The comment input cell has the following: V#Annotation with UD3&UD5 based upon the CV POV selection and the remaining UD's set to None; V#Annotation:UD1#None:UD8#None. For reporting purposes the customer would like to associate the commentary entered with the Combo Box selections made for UD1 and UD8. V#Annotation:UD1#Perm:UD8#AuditChange What is the best method to do this? I have tried the following: api.Data.Calculate("U8#AuditChange:V#Annotation:U1#Perm":O#Import" _& " = U8#None:V#Annotation:U1#None:O#Top")

Hello, We want to update the UD2 Text5 property from a workflow step (via a cube view or a dashboard, for example). Is it possible to do it? We don't find how to do it. Thanks.

Hi there - I'm looking to add a sparkline image at the end of my cube view / page. The cube view trends 13 months of actuals. How can I add this?

Hi everyone, I'm having a problem with the Harvest directory. Indeed, I have two batches running at the same time and which retrieve files from an SFTP to put them in the Harvest directory in order to load them into the WF corresponding to each file, for this I use this line coded :Dim batchInfo As WorkflowBatchFileCollection = BRApi.Utilities.ExecuteFileHarvestBatch(si, fixedScenario, systemTime, valTransform, valIntersect, loadCube, processCube, confirm, autoCertify, False) But with this line I do not filter the files present in Harvest. Is there a way to filter by file name inside Harvest which seems to be common and mandatory? Thank you for your help

Hi All- We are trying to create a BI Viewer to compare Current v Previous Qtr OPEX. We look at the end date (only two end dates possible of course) to create a Current QTR measure (max end date) as below. However, I can't seem to get the syntax for the measure correct. Not sure what I am missing which is generating the error below: A Summary Expression is Expected    

We are capturing parent entity adjustments, and they are not rolling to C#Share. Any idea what the cause may be or how to enable this.

Originally posted by Andrea Tout 12/10/2019 Does applying slice security have any performance impact? Or is it more just maintenance impact?

Hi All,   I need a same base member in different parent members in Account dimension and it should aggregate to their respective parents, do i need to create multiple base members or I can use the relation, can anyone suggest what is the best way to achieve it.   Thanks in Advance.

I have a requirement for a book to produce different views (i.e. Periodic, QTD, YTD) based on the WFTime. The periodic report should always appear no matter the WFTime, however the QTD Version will only appear in certain months. I cannot get the "if" statement shown below to trigger.  I have an item to change a dashboard parameter present in the CV as well.  Is my syntax incorrec on the "If" statement?  Any help would be appreciated!     

Could someone please direct me on where I can find documentation or training on how OneStreamEmail works?  How it can be implemented, authentication used, etc.?  I can't find anything when searching Design and reference guide.   

Hello Everyone,I am using a Delimited List Parameter which results a list of comma separated values from SQL through XFBR.When i use this parameter in Dashboard, it always shows as blank when it starts up, even though i have set the default value property.Looks like its a limition at this point of time.Are the any alternate ways we can use the default value for Delimited List Parameter in Dashboards ?

Hi, I am trying to build in an if statement in a cubeview (getdatacell formula) on the cell amounts. In specific: If cellamount of CVC(col 10) > CVC(col 11) then CVC(col1) else CVC(col1).  The reason why I am trying to do this in a cubeview getdatacell is because the col 10 an col 11 are referencing other columns and those other columns are referencing other columns in return. A workaround would be to recreate these column references in BR or create new members with formulas doing similar. But I am trying to avoid recreating this if possible. Hope someone have ideas. 

Is it possible to format cells inside a table in a report component so that the value displays as both a bar and a value similar to how it looks in the BI Viewer grid component in the image below? I am currently using a cube view to pull the data for my table in my report.  BI Viewer table with cell values formatted as bars and values My report table is currently formatted in the following way: Any help would be greatly appreciated.

What is the formula to pull the Exchange rate data via a formula into an extensible document (word) 

Dear Community, I am struggling with components that are coming from 2 differents workspaces. Right now, I have a dashboard which is in Workspace A, that have a cube view cube and buttons to open other things in dialogbox from the same workspace. It's working fine on its own. I have dashboard in workspace B, where I need to embed the dashboard from workspace A. I ensured that both are shareable workspaces, they also have shared workspace names. My problem is, and I can see it in the dashboard design mode, none of the parameters that are in the embedded dashboard from workspace A are shown, so it behave like these input parameters don't exist and its messing up everything. I've seen these options since V7.4 related to "Embedded Custom Control Dashboard" but I don't know if I can use this to solve the situation ?   - Parameters from Dashboard A (workspace A): - Parameters of Dashboard B with embedded Dashboard A (Workspace B). As you can see, none of the parameters from Dashboard

Hi All,  I would like your help. I installed OneStream as a plug-in using MS Excel. When I try to create a pull or refresh a sheet this is what it shows: "Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0-1".  Any chance you know how to fix this issue?

Hi I am loading data into a Bi Blend table and I don't want any aggregation applied. My understanding from the documentation is that I can use 'SSOnly.' However, whenever I try use this I get an error. Below is the config: Question 1: Am I doing something wrong in my config or is my understanding of how it works is incorrect? Another idea of mine is to set the Blend Unit Dimension Token to a UD member which will only ever have 1 member (e.g. UD4 and set the Aggregation Info to 'None'), so the aggreation should never create any additional aggregated parent records. I have tested this and it appears to work but I am worried that there is a potential issue that I'm not aware of... Question 2: Is this a viable workaround and is there anything that I should be worried about if I follow this approach?   Thanks, Mark