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.63Views0likes2CommentsTable 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?175Views0likes3CommentsNegative 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?441Views0likes2CommentsCreate Excel spreadsheet from Business Rules
Does anyone know if you can create an Excel spreadsheet from Business Rules? I do not mean a csv file - I need to create multiple sheets. The OpenXMLBuilder object doesn't seem to have anything with writing files. I don't want to use a third-party object as that would require an installation or download. Thanks for any suggestions.Solved13KViews0likes27CommentsData 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, Greg539Views0likes1CommentSpreadsheet 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!852Views0likes3CommentsHow to call a dashboard extender function from a Spreadsheet type BR?
Hi, I have a Spreadsheet BR that creates a tableview and I want a certain dashboard extender function to be triggered when they submit the data from the tableview(spreadsheet) I think this is the way to go but probably because of the namespace, I cannot do this definition. See the screenshot at the bottom. _______________________ Any help is appreciatedSolved1.7KViews0likes4Comments[howto] Use "Insert Code" when posting on Forum boards
Hey guys! Just a reminder: if you're going to post code in this forum, please make it easier to read by using the "Insert/Edit Code Sample" button on the expanded formatting toolbar. Here's a short video showing how it works. If you need to edit code after you created the block, just double-click on it. Ideally you'd also indent it first, either in an editor or with something like DotNetFiddle. Remember: the easier it is for others to read your code, the more likely that they'll be able to solve your problem! Cheers! Your friendly neighborhood Spider-Mod3KViews4likes6Comments