Decimal column is always dirty
Hi, I need to check in a Table View if certain column values are dirty and I've noticed that when you call the IsDirty() function on any decimal type column (and this only happens on that type), it always returns 'true' even though no changes took place. Because of this i need to manually parse the value and check if the originalValue is different from the current value. At this point I was wondering if this behaviour is intended or not, it seems odd that IsDirty() returns the correct value for every type of value BUT a decimal one. Any clarification on this matter is appreciated, thanks in advance. 🙂
Table view service - get customSubstVars inside SaveTableView function
Hi, I need to use inside my Table View service some parameters that are bound to combo boxes in order to write a query, and execute it when the "SaveTableView" function is called. Unlike the "GetTableView" function, SaveTableView's signature doesn't provide a parameter that contains all substitution variables (Dictionary<string, string> customSubstVars for GetTableView) I also tried setting the customSubstVars dictionary into the BRGlobals from the GetTableView function, but once you try getting the dictionary from the globals, it returns null. Is there no way of getting this customSubstVars dictionary to use it inside SaveTableView?
Table View Service assemblies
Hi, I am trying to call Table view service from a spreadsheet. I tried to use the syntax defined in the reference manual. The above syntax is not working. The above syntax works with the Spreadsheet Business Rule Assembly. Anyone tried Table view service type? If so, what is the syntax to call the table view service from a Spreadsheet?
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!
Entity Relationship Properties update via business rules
Hi Team, I would like to fetch and update the Entity Relationship Properties for the Entity Dimension members via Business Rules. The below peace of code works fine for only when I pass the Actual and Budget but when i pass the other scenario Type like Scenariotype 1 to 8 I get the error Object is not set to an instance of an object. Dim Scenario As String = args.CustSubstVarsAlreadyResolved("Param_SecnarioType_EO_24") 'The above value i get it from the combo box as delimited list Dim Scenarioid As Integer = BRApi.Finance.Members.GetMemberId(si,dimtype.Scenario.Id,Scenario) Dim MyScenarioTypeid As ScenarioType = BRApi.Finance.Scenario.GetScenarioType(si,Scenarioid) Dim Timefilter As String = args.CustSubstVarsAlreadyResolved("Param_Time_24") Dim Timeid As Integer = BRApi.Finance.Members.GetMemberId(si,dimtype.Time.Id,Timefilter) Can you please help me with the correct way to get the scenario Type.
Negative numeric values for GetTableView function - Table Views
Hi, In the GetTableView function of a Spreadsheet BR, I extract data from a database table (XFW_TLP_Register). For a numeric value (e.g. NCode1) negative numbers are by default extracted to Excel as varchar (with “,” as decimal separator) and positive numbers as numeric values (with “.” as decimal separator). Hence, the value cannot be submitted back since it’s trying to submit a text value into a numeric database column. If I cast the column (in my SQL query in the GetTableView function) to numeric it works but then it will not display digits in the Excel. Any idea how to solve this?
Data Cell update limit on Table Views
Hi, is there a limit on the number of cells that can be updated through Table Views? We have a large table, 250 rows by 140 columns. When we try to update all values at once, there are many cells that do not update. When we only load 10 or so rows at a time, it updates all values correctly. thanks, Greg
Spreadsheet rules | Auto-Capturing User-Selected POV from OneStream to Excel
Hello OneStream Community, I'm seeking guidance on a functionality related to POV selection within the OneStream application and its transmission to Excel. Specifically, I'm curious if it's feasible to automatically capture the user's selected POV from OneStream and populate it into Excel cells using table views once the Excel application is initiated from OneStream. In my current setup, I've created a custom cube view that allows users to select certain POV members. There is also a custom button that exports the cube view in Excel using spreadsheet rules. The goal now is to have the user-selected POV members auto-populate within Excel cells. Has anyone implemented this functionality or does anyone know if this is possible? Any guidance or insights would be greatly appreciated. Thanks in advance for your help!
