OneStream Platform Forums

Hello,  We recently upgraded to 7.4.2. Prior to this our Pie Captions were showing up when view the BI dashboard. However, since the upgrade we are noticing that we are unable to see the pie chart caption.  In the BI Designed window I can see the pie chart caption, but when playing the dashboard it disappears. Is there a bug in the 7.4.2 version that affects this? As well I was wondering if there is a way to fix the data labels, currently we have the labels to display outside of the pie chart and we have two pie's side by side for Quarter over Quarter variance, however the labels are all on top of each other and we cannot see the labels correctly. Any suggestions on how to fix this?

HI Am looking to lock the accounts (Rev first and then COGS ), such that if the Rev load is done i should be locking the Rev account for a particular scenario, then lock COGS account based on the Input deadlines. Can anyone help me on this Regards Narayana (BOYD Corporation)

Hi all, I might be having a dumb moment here but I cant work out how to overcome a formatting issue. Im trying to restyle some reporting, all the formatting is on style parameters and in this case my highlighted columns are being overriden by the row total formatting. I just want the background colour as per the column formatting. I cant use targetted row overrides as the row set is shared and on a param (it could be one of 11 row sets in this report) Ive tried all the tricks to create a global override but nothing is working.  I cant change the formatting on the row set as its used in multiple places and in a lot of cases it formats correctly, its just this report that works a little differently. Some trick or tip to get round this would be most appreciated!  Thanks, Tom    

If a member has no parent then it's an orphan but if a parent member had children and they all get moved, the former parent is now... Regardless of the term, this company loves to do big reorgs a couple times a year that leave whole branches of a hierarchy empty. It's put me in the weird situation of having to hunt down these obsolete (disowned?) parents and manually remove them because they're now base level members with data and consolidations don't clear them the way I expected. From a technical viewpoint, I can see why this happens, as it's now just a base member that happens to have data and the consolidation doesn't particularly care *how* the data got there so it's not going to remove it. It's just... counterintuitive, unwanted, wrong, and generally annoying. For the most part, they've just orphaned the offending ex-parents and ignored them, forever. The few they have deleted have been cleared via the rather laborious method of creating a new (empty) member under the obsolete pa

Hi!  We are using T#Pov.AllPriorinYearInclusive in a cube view but would like to change the order the months appear from oldest to newest (i.e. Jan to June)  to current to oldest (June to Jan).  Does anyone know how to do this?  Thangs

I have a column performing the following expression: GetDataCell(Divide(CVC(CYAct)-CVC(PYAct)), CVC(PYAct))):Name(PY % Var) The column uses the following formatting: ExcelNumberFormat = 0.0%, ExcelUseScale = True, NumberFormat = 0.0, Scale = 0, ShowPercentSign = True The Cell Amount of the column/row intersection is -26.956   When I run this cube view in OneStream, the number populates as -27.0%, which is okay with me. However, when I export it to Excel, the number populates as -2695.6%.  My resolution is to multiply the number by 100 and then apply a scale to make the number appear correctly. However, if I multiply the division calculation above, it ignores the multiplication aspect.  My multiplication formula is: GetDataCell((Divide(CVC(CYAct)-CVC(PYAct)), CVC(PYAct)))*100):Name(PY % Var) Any suggestions on how to add this multiplication to my calculation, or another way for the number to appear properly within Excel?

Has anyone else see any issues running the OneStream clients on Windows 11? We are testing OneStream on Windows 11 and we keep seeing the error message "The specified data could not be decrypted"  when attempting to access a few modules such as Cube Views, Dashboards, Business rules, etc.  I believe it's a .NET issue since the error can pop up in either the Desktop client, Web client and Excel Add-in.

Hi everyone,   has anyone received the error below before:     The Workflow profile is in place and properties are correct but still receiving this error. Any idea how to fix this?

After migrating from OneStream version 6.8 to 7.4, it looks like the Excel data groupings disappear after refresh. Does anyone know if this is an issue with the Add-in itself or do OneStream/Quick view settings need to be changed?  thank you      

Hi all, I have a member formula with simple calculation (e.g., Account A / Account B), and there is a data access security set up upon account A. I am wondering if a user without account A access, can the user be able to see the calculated result? My hunch is that it will show access on the end results, may I know how OneStream will handle this? Thank you.

I am running a "clear Import Data" from the WF.But its clearing the data of the same entity from other WFs that I loaded .Is this behaviour normal. I just wanted to clear data from the cube that I loaded for the WF where I am triggering the "CLear All Import data". Please advise

Cube View within a Dashboard.   When an amount in a data cell is changed and the save button (either the cube view save button or a dashboard save button) is clicked I would like to add in validation code that evaluates the changed amount. A WorkFlowEventHandler allows me to identify the CubeView so that I can isolate the action solely to that cube view.   So far in the WorkFlowEventHandler I have been able to identify the cube view and get code to fire based solely on that CubeView, however it all seems to run after the cube data has been saved. Is it possible with a WorkFlowEventHandler to have code run before the changed amount is saved to the cube and not save the changed amount based on some validation/code logic?  

I have a cube view within a dashboard.    The dashboard has a save button which fires a Dashboard Extender rule.  (The cube view save button is hidden). I would like to add a step that, before any changed amounts on the Cube View is saved to the cube, checks the sign of any changed amounts and prompts the user based on a rule if they are sure the sign is correct. Any Ideas?    

Dear Team, while opening the cube view, I am experiencing issue " Value was either too large or too small for a Decimal."  I can see that in BR for EndBal, one of the divided formula causing the issue I am thinking. I am trying to add the divide function, but it is not working. any suggestions on the new formula?  0 Kudos   Accept as Solution Existing furmula: Return api.Data.GetDataCell("VariancePercent(A#AVG_Daily_Sales:T#POV:U8#None,A#AVG_Daily_Sales:T#POVPrior12:S#Actual:U8#None)/100")   New furmula: Return api.Data.GetDataCell("(VariancePercent(Divide(A#AVG_Daily_Sales:T#POV:U8#None,A#AVG_Daily_Sales:T#POVPrior12:S#Actual:U8#None)),100)")    

I got this validation error in plp's Export to cube, and I know it's because I don't have that entity associated to the workflow, but I would like to know if there is a way to solve it without having to remove that entity from the other workflow in which it is.  

Hello, How can I seamlessly integrate SAP with Onestream in such a way that I can pull specific data for specific intersection? For example, let's say I want to only pull data from SAP that has entity as ABC and account as 123. How can I do that? It should be completely user driven and minimal intervention from administrator. Thanks

I keep receiving this error when attempting to run my dashboard that has a BI viewer component attached to it. I made a bi viewer component and assigned a cubeview MD data adapter to it. created my BI viewer and everything works fine. However, when I assign it to my dashboard I get this error. I've tried attaching other cubeviews to the data adapter and making other BI viewers but I keep getting the same error. Has anyone else run into this issue?    

Hello, We are currently seeing slow consolidation times after we copy data from one scenario to another. If we run a force consolidation in the source scenario the full year takes around an hour or so. When running the consolidation in the target scenario it is taking 4+ hours to complete. Both scenarios are using the same scenario type.Anyone have ideas on what could be causing this issue? Seems odd that the same data set would have such huge deviations in run times. This is the second quarter we have seen the issue.  Thanks for your help! Tim

Hi all,  I use the dashboard to trigger data import from external database. After successfull import I want to make the workflow step (type Workspace) complete by calling SetWorkflowStatus. Strange thing is that is does work when I directly call the Extensibility rule from Button, but it does not when I call the same rule from data management process. Do you know why this happens and how can this be bypassed?  Thanks for help! Pavel  

In developing applications, I prefer to group objects intuitively using standardized naming, alphanumeric sorting, and hierarchical grouping.  Dashboard parameters use the "Sort Order" property to sort, which for me adds unwanted cognitive load to a development process.I developed the code below to automatically sort and group parameters the way you would expect them to be sorted to get around the need to specify Sort Order. Implement as an extensibility rule and run it from the editor.  After the rule is run, copy, paste an existing parameter, then delete the pasted parameter to force a refresh of the list from the server.  Be sure to remove this code from your production applications. C# using System; using System.Data; using OneStream.Shared.Common; using OneStream.Shared.Database; using OneStream.Shared.Wcf; using System.Linq; using System.Text.RegularExpressions; using System.Threading.Tasks; using System.Collections.Generic; namespace OneStream.BusinessRule.Extend

Hi Everyone, These tables house information about the Environment tables, and also the Application Tables.  It would be ideal to have not only know information on the fileds in these 2 tables mainly are the fields in GB or Tera Byte, but also the best place for information about the tables that come with OneStream. Thanks in advance of your help

We are currently building a simple form for Shipping Days that allows a user to input an entire year's worth of shipping days all at once. We want this to be a Periodic view to align with how the client thinks about shipping days for each month. We are entering the data into our Actual scenario, which has a Default View of YTD. The below screenshot shows the basic form structure and the YTD row is there for reference. The initial data entry worked great. However, if I go back to a previous period to change a periodic value, I want the new periodic value to update for that month and keep the remaining periodic values the same. However, changing a periodic value squeezes the difference into the next month to keep that month's YTD value the same. In the below screenshot, Cell (1) was changed from 23 to 18 in March 2022. The March 2022 YTD amount updated accordingly. However, the periodic amount in April 2022 (Cell (2)) automatically changed from 20 to 25 so that the YTD amounts for April

I have a column where I'm using a GetDataCell formula and I want my Time Row Header to show a date different than that of the Pov.  I've had a solution that uses a Business Rule but wanted to see if an out-of-the-box solution is available. 

Hello, I have a list of segments in WFText2 that I use as UD2 dropdown selection for my cube view.    So whenever I open my Form/Cube View I can see all segments excluding GBA_021, GBA031, GBA_032 and GBDP_001,  in UD2 Dropdown selection. My dilemma is, I am creating a confirmation rule that will loop for each UD2 that were not stated to be removed. I use this to get Text2: Dim WFText2 As String = brapi.Workflow.Metadata.GetProfile(si,si.WorkflowClusterPk.ProfileKey).GetAttributeValue(ScenarioTypeID.ScenarioType1, SharedConstants.WorkflowProfileAttributeIndexes.Text2) And the entire UD2: Dim GBA As List(Of Member) = api.Members.GetBaseMembers(api.Pov.ud2Dim.DimPk, api.Members.GetMemberId(dimtype.ud2.Id,"gba")) I initially used this GBA in my confirmation rule but it also includes those that were removed in WFText2 in the loop.   Any advise would be helpful.

Hello I am trying to create a type of dashboard that will contain multiple reports. I want that whatever report has data, only that should appear and report with no data should get suppressed along with its rows and columns too whenver I execute a dashboard? Can this also be achieved via a Cubeview? Please suggest?