OneStream Platform Forums

Hello, does anyone know if we need to worry about this warning?  There aren't much details provided in the error log. Summary: SQL Blocking detected: Database Name: , Request Session ID: 72, Blocking Session ID: 12, Blocked Object Name: , Resource Type: FILE: 9:0, Requesting Text: , Blocking Text: , Request Mode: , Blocking Time: 12/2/2023 8:05:57 AM. Thank you,      

I didn't yet find a post about this anywhere so adding this here in case anyone else encounters the same problem. If a user has an Excel with a formula that references a cube and a scenario that is not valid for that cube (i.e. there is no CubeRoot profile for that cube/scenario combination), all cells in the Excel (not just the cell with the mistake) will show #REFRESH instead of the expected values. This will somehow corrupt the Excel so that the problem continues even after the cell is removed and the sheet is refreshed! The only way to get all the other cells to retrieve values correctly again seems to be to remove the cell with the mistake, restart Excel, and then refresh again.

Hi I have got a list of member info and trying to do a simple loop through the list to get the member and it's parent using the following code, however ParentMemberId is always coming back as -1. Dim UD1DimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, "CostCentre") Dim listMI As List(Of MemberInfo) = BRApi.Finance.Members.GetMembersUsingFilter(si, UD1DimPk, "U1#Root.TreeDescendants", False) For Each item In listMI BRApi.ErrorLog.LogMessage(si, item.Member.Name & " | " & item.ParentMemberId) Next I've also tried to include DimDisplayOptions and MemberDisplayOptions using following but I have had no luck Dim cubeID As Integer = BRApi.Finance.Cubes.GetCubeInfo(si, "MY_CUBE").Cube.CubeId Dim scenarioID As Integer = ScenarioDimHelper.GetIdFromName(si, "Actual") Dim dimDisplay As DimDisplayOptions = New DimDisplayOptions(cubeID, scenarioID) Dim memberDisplay As MemberDisplayOptions = New MemberDisplayOptions(True, CultureInfo.CurrentCulture.Name, True, True, True, True, True, 0

Hello there, In an Import WF profile, I would like to duplicate all rows where the UD3 member is different than None. In the duplicated row, I need to change the UD3 POV to 'None' I know this can be done easily through 'Derivative Rules', however I am trying to do so in the Data Source through a 'Complex Expression' or 'Business Rule'. PS: This is bad practice since source data should NOT be altered to keep Audit trails, but in my case I am just exploring possible options  

Hello, We have a url stored in SQL server as a text. When we retrieve that we want it to appear as a hyperlink in SQl table editor. Could someone please help. Thank You, Indu

Hi team How do I create a border across rows and columns, essentially creating a box around them? The use case is for showing the detailed amounts for a subtotal in the AFS, contained within the box - as seen in the screenshot attached. When trying to add borders to a cell, it automatically applied the border selection to the rest of the rows as well.

Hi Can anyone tell me the name of the Market Place solution that contains a list of packaged UD8 Rep_Reporting dynamic Calcs?  Thanks Guy

Hi, We have a non-euro company that initially reported on input_level. That local amount has been translated to EUR. Later on in the process the local amount was removed, however the converted EUR amount remains in the system. i have done a force calculate, force translate, (force) consolidate. Nothing seems to remove the EUR amount!? Question: how to remove the EUR amount without touching the Local amounts. thanks!  

We have a client that does a lot of prior period adjustments so they go through the workflow for the whole year a few times. We have automation set up to assist, however they would like a report that shows the workflow status for the whole year and not just one period. I know the application reports are out of the bos that shows a particular month throught method queries. That works great but has anyone ever created one that would pull the whole year? I was looking for a sub variable that does that but cant seem to find one or has anyone done anything different.  Much Appreciated!

Hello - I created a dynamic UD8 calc for a cube view that shows 12 months of actual, forecast and budget periodic amounts. The calc is designed to show zeroes in the actual scenario column for a period if its POV time is greater than than the global time. I added it to the cube view and it works perfectly when I run it for 2024M12 - the actual columns are all zeroes, while it displays the budget and forecast numbers. When I run the CV for 2023M12, since our global time is still 2023M11 I'm expecting zeroes to be in the Actual column, but I'm still getting the opposite sign YTD "no data zero view" totals instead. Below is the formula in the UD8 member - let me know what changes I need to make. I appreciate the assistance. Dim gbTimeName As String = BRApi.Workflow.General.GetGlobalTime(si) Dim gbTimeID As Integer = BRApi.Finance.Time.GetIdFromName(si, gbTimeName) Dim gbYear As Integer = BRApi.Finance.Time.GetYearFromId(si, gbTimeID) 'Get pov year Dim pvYear As Integer = api.Time.GetYearF

Hello! I have a user group who needs a specific set of data pulled just after close every month in order to populate other reporting tools they use. Here's the formatting they require: I'm struggling on my options because this results in about 16M+ rows of data. I get an error when trying to export the CV and a QV won't show all rows even with the max # of seconds set to the largest number (which I believe is 600). A DM extract will not show the right format but I don't think a QV can be auto run and sent via Parcel Service. What are my other options? Thanks for helping me brainstorm!

I am trying to incorporate patterns in the advanced charts and bi viewer bar charts. I don't see any option to select the color patterns. This is one of the examples of the pattern mentioned below -> Light Blue 48A6EA Dotted 90%  

Is there a way to log messages to the Error log within a Smart Integration Function that is running on the Local Gateway?  I notice when a new SIF is created, none of the OneStream libraries are available.   I did find an example where the OneStreamGatewayService library was included.  Is there any documentation on this library? Thanks, Scott

I think I may have found a bug with workspaces but wanted to see if anyone has encountered this issue before.  I am displaying a dashboard with an embedded Cubeview that has a link to a dashboard in a non-default workspace.  When I launch the dashboard, I see the drill link but nothing happens when I click on it.  However, if I add the same dashboard to either the Default workspace, or the workspace where the dashboard resides that I am launching from, the link works without issue.  It seems that if you want to follow a link in a Cubeview in a dashboard it either has to be in the same workspace or in default.  I guess it might make sense because when adding the link in the Cubeview there is no option I am aware of to specify a Workspace so OneStream might get confused as to where to find the dashboard.  Has anyone else had a similar issue or know if I am missing something?

I am working with two different Onestream clients and having login issue with one client. See attached picture of the error. I have tried clearing cache, restarting the machine multiple times. Any help to resolve this issue is appreciated.

Hi All,   I have created a cube view in which rows has data with ChildrenInclusive like parent with child members in a same row  and base members are aggregating to the parent. Here I need to change the format like bold, color, Text color to the parent member only. Can anyone suggest how to do that.   Thanks in Advance.

To be able to use them in Task Scheduler, you must organize your DataManagement Steps into Sequences. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello, How can I see the signage from aggregation weights. For example I have these 2 account groups in a hierarchy: PL44000000 has aggregation weight 1 PL43700000 has aggregation weight -1 When I show these in a cube view with SG&A.Children.Base all numbers are showing as positive numbers, which makes it difficult to see how it adds up. This example is still straightforward, but I have some more complex use cases.  Is there a way to show the numbers based on the aggregation weight, or just show the value from the aggregation weight on the meta data member (-1, or 1 in this example)? Thanks in advance      

Hi Everyone. I am performing a conversion in a SQL query using currencies; I relied on this other post for now. Where is stored the Currency Name ?  The problem I have is that I have some SourceCurrencyId in the FXrates table that don't appear there, so I want to know if there's a way to get all possible currency names through a business rule.

I am new to OneStream and I am trying to find out how you retire an entity.  I have gone into the entity and tried to change the vary by scenario type but cannot get to where you would change to False for "In Use".  Any suggestions

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!!!

Hi, is there a standard IRR calculation that can be shared? thanks, Greg

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?

Does anyone know how to get the Year for the time function below to display as the name in the row?  T#YearPrior2(|GlobalTime|)