BR Rule - BR api Error log
Hello All, OS experts - Greetings ! I am trying to complete the following code to extract the year and month from a given date. To help with validation and debugging, I've enabled BRAPI.ErrorLog.LogMessage to display the variable outputs in the error log. However, for some reason, it is not displaying any values in the error log. I would greatly appreciate any insights into what might be wrong with the code. Here is the code I am working with: Dim vDate As String = args.NameValuePairs.XFGetValue("Date") ' e.g., "01/01/2025" (MM/DD/YYYY format) ' Log the retrieved Date for debugging BRAPI.ErrorLog.LogMessage(si, "vDate: " & vDate) ' Ensure vDate is not null or empty before proceeding If Not String.IsNullOrEmpty(vDate) Then ' Extract the year (last 4 characters) from vDate and convert to an integer Dim vYear As Integer = CInt(vDate.Substring(6, 4)) BRAPI.ErrorLog.LogMessage(si, "vYear: " & vYear) ' Extract the month (first 2 characters) from vDate and convert to an integer Dim vMonth As Integer = CInt(vDate.Substring(0, 2)) BRAPI.ErrorLog.LogMessage(si, "vMonth: " & vMonth) Else BRAPI.ErrorLog.LogMessage(si, "vDate is null or empty!") End If Thank you in advance.
Business Rules for new OS implementation
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, PreetiReceiving this error - when running a period that has no data.
Trying to understand a little more about this instance. This message appears when trying to run a period that has no data. Some questions have emerged around: Can we customize this message? (Thinking no, it is standard OOB message describing what is happening). What is happening? Does the data require consolidating in order to be leveraged? Under what circumstances would you receive this message relating to dashboards?
How to Run BR on Cube View DB Component Selection Change
I have a dashboard with a cubeview in row one and a chart in row two. I want the chart below to change based on what the user clicks in the cube view. I was hoping when the user clicks a new cell in the cubeview it would trigger the "Selection Changed Server Task" action but I can not seem to get a rule to run there. Does anyone know how a BR on a cube view dashboard compoent is triggered? I was hoping on cell selection but maybe not. Thanks.
performance issue.
Hello OneStream Community, I am working with a Cube View where I need to display the Income Statement data for the end of every year (December). The data should show up as the beginning balance for the January month in the subsequent year. To achieve this, I used a Row Override1 member filter with the formula T#povprioryearm12. The Cube View includes four dimensions: Entity, Division, Cost Center, and Accounts. However, I am experiencing slow loading times when the view is being accessed. it is not exporting to Excel to validate. I would like to know if there are any best practices or strategies for improving the performance of the Cube View in this scenario. Are there specific optimizations I should consider for the member filter, the dimensions, or the Cube View configuration to reduce loading times? Any advice or recommendations would be greatly appreciated! Thank you in advance!MergeAndCenterColumnHeaders in Cube Views
Hi, Anyone on Version 8 who's actually tried to use this 'enhancement' feature in Cube Views? We requested this on Ideastream a long time ago with a lot of support. I can see this command is now available in the header format dialog; however, it would appear that the only thing it does is change the header from left justified to center view. There does not seem to be a way to actually 'merge' column headers, despite the fact that it's called "MergeAndCenter". Even the system documentation appears to confirm this behavior. Someone please tell me I'm missing something here and it actually is possible to merge column headers, because we really really wanted this feature. Thanks
How do you attach an assembly to a Data Adapter?
Hello, I am trying to use the new menu component within dashboards. I tried using method for command type and entering in the assembly file name for the business rule. However, when doing so it returns an error message that it is invalid. I am wondering what the correct syntax is for using an assembly file within a data adapter as well as the correct method type. I currently have it as follows {BusinessRule}{DataSet} or {Workspace.WorkspaceName.AssemblyName.FileName}{DataSet}
Customizing aggregation weight
The client requires us that aggregation is with an average method and not summing (this condition must be applied to all dimensions). For example: Oversea and Europe are aggregating summing (UD4 members), however, the client requires that the aggregation make an average of their children. Note that in column we have metrics (account members) where we need to apply it. The result desired would be 5 %. Thanks in advance.Auto Refresh for Pivot Table in Spreadsheet Component
Hi All, We have a spreadsheet component containing two tabs. One tab has the source data derived from a Table View. The second tab has a Pivot created on the data from First tab. The Pivot Table has "Refresh data when opening the file" checked under Pivot Table Options/Data settings. The source data tab refreshes as expected if TableView output changes based on the spreadsheet component setting. The Pivot table however does not refresh automatically. Is this a known issue ( OneStream spreadsheet component vs Excel) or do we need additional configuration to make it work?
Dashboard in Workflow. How to control when a workflow profile step is shown
Hi, I have an admin Workflow Profile where I have children steps that are different dashboards. I would prefer not to create these as Forms steps as I want to certify each step and not every Form. I have system default settings to set this as Profile Active True/False. Is it possible somehow to change so this is only Active for months which are not a quarter? I want to remove this from the Workflow Profile in quarter months to avoid and eliminate the risk of someone using this dashboard in a quarter.
