ONC Intercompany Report
Hi, We have installed ONC after upgrading OneStream to version 8.5. Before that, we were using the standard application reports and attached the Intercompany Matching Report as part of one of our workflow steps. Is there a way to replace that by the ONC Intercompany report instead? It seems like we can only add the Frame_ONC_OnePlace dashboard as when we add the individual interco report we get the following prompt: Any ideas would be very appreciated. Thank you for your help!7Views0likes0CommentsGetting Column Text Value from Derivative Rule
Hi I have a derivate rule that I created that returns the absolute value of an amount based on column name. The column names are assigned in the data source and based on the data source column it will either assign an absolute value or a negative value. I want to be able to pull a column in my derivate rule that is a text attribute column and if the text equals something like "S5" it will do some type of conditional logic. With my limited experience with derivative rules and research it seems this cannot be done via a derivative rule. First question: Is there a way for me to do this? Second: If not, is there another alternative way that I can extract the text field of a column and based on that to do some type of additional logic?20Views0likes1CommentHierarchy Comparison Reports or Dashboards
Has anyone built a cube view, or more likely a dashboard, that can automatically compare the base level members of 2 or more hierarchies in a dimension to identify exceptions? We do this manually now in Excel but was asked by the users to put this comparison in OneStream. I thought this might be an application report, but I don't see anything close. Also, we are currently on v7.4, so if there is a feature in the latest version please pass along. Thanks!37Views0likes3CommentsIssue in Web Content and File Viewer component to directly open a HTML file in a browser
Dear community, I currently have an html document which is located in the file Explorer under "Documents/Public" folder. I am trying to get this HTML document to be presented into the components, embedded in a dashboard. However, with either a Web Content component or a File Viewer component (which will pinpoint to this specific file in Application Database File, as soon as I open the dashboard, it will load the html page into my default browser... I am using OS v8.1 ... is it a known bug or the expected behaviour ? What is even more strange, directing the Full File Name to a URL will correctly open a document in a dashboard ... Regards,Solved2.8KViews0likes9CommentsIs it possible to extract(as xml) a Maintenance Unit and it's components using extensibility rule?
Hello OneStream experts, We are trying to extract a maintenance unit and all it's components underneath it using a BR/Extensibility rule with the latest OS version - 9.0.1. But, however after the run we could able to see a empty xml in the fileshare folder. Below is the snippet of code which we are using. Any suggestions or help would be greatly appreciated. Thanks! Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As ExtenderArgs) As Object Try Select Case args.FunctionType Case Is = ExtenderFunctionType.ExecuteDataMgmtBusinessRuleStep, ExtenderFunctionType.Unknown 'Get Configuration Settings Dim configSettings As AppServerConfigSettings = AppServerConfig.GetSettings(si) 'Data Management extract location Dim folderPath As String = FileShareFolderHelper.GetDataManagementExportUsernameFolderForApp(si, True, configSettings.FileShareRootFolder, si.AppToken.AppName ) & "\" & DateTime.UtcNow.ToString("yyyyMMdd") & "\Extracts" 'If the directory does not exist create If Not Directory.Exists(folderPath) Then Directory.CreateDirectory(folderPath) 'Full path and file name for extract Dim filePath As String = folderPath & "\MaintainanceUnitBkp " & DateTime.UtcNow.ToString("yyyyMMdd") & ".xml" 'If file already exist If File.Exists(filePath) Then File.Delete(filePath) 'Extract Options ' Dim xmlOptions As New XmlExtractOptions ' xmlOptions.ExtractAllItems = False Dim xmlOptions As New XmlExtractOptions Dim dashboardOptions As New DashboardMaintUnit xmlOptions.ExtractAllItems = False 'Extract Maintainance Unit Dim extractDict As New Dictionary(Of XmlExtractItemPk, Boolean) Dim strMaintUnit As String = "DataExtract_Main" 'Maintenance Unit extractDict.Add(New XmlExtractItemPk(XmlExtractItemType.DashboardMaintUnit, strMaintUnit), True) 'Execute the Metadata Extract Using dbConnFW As DbConnInfo = BRApi.Database.CreateFrameworkDbConnInfo(si) Using dbConnApp As DbConnInfo = BRApi.Database.CreateApplicationDbConnInfo(si) 'Extract XML metadata to target location File.WriteAllText(filePath, MetadataExtract.ExtractXml(dbConnFW, dbConnApp, xmlOptions, extractDict)) File.WriteAllText(filePath,XmlExtractController.ExtractXML(dbConnFW,dbConnApp,Nothing,xmlOptions,extractDict,XmlLoadExtractType.ApplicationWorkspaces)) End Using End UsingSolved63Views0likes4CommentsDynamic Dashboard fails to load Embedded Dashboards via parameters
Hello, I'm using OneStream version 9.0 and have built a dynamic dashboard that serves as a container to display other dashboards. The dashboards being displayed were created in older versions of OneStream and use parameters to define embedded dashboards. When I try to open these dashboards within the dynamic dashboard, I get the following error message: #ERROR: Unable to open embedded dashboard '[dashboard to display name]' while processing component '[my embedded dashboard component]' The dashboard to display name is correct, so the parameter seems to be working. Also, when I open these dashboards directly (outside the dynamic dashboard), the embedded dashboards display correctly. Is it still possible to use parameters to define embedded dashboards within a dynamic dashboard in version 9.0?Solved21Views0likes2CommentsHow to pull a field from Custom table into a Cube view
Hi Everyone, I have a requirement to pull the data in a particular format in my cube view. I have entity dimension members in a row which gets pulled from the cube. I have to pull the respective opening dates of the stores from the custom table in the cube view as a column. I have created the custom table (with store and opening date) and used a business rule to pull the opening date from the custom table. Now I want to display this in the cube view w.r.t the stores we are pulling in rows. For ex if we have a row with Entity (store) tx0001 in the cube view which has an opening date for the store in the custom table. This opening date needs to be displayed in the column w.r.t to the store in the row. How to achieve this? Thanks, Jeevan29Views0likes3CommentsIn-Sheet Actions
In-Sheet Actions In-sheet actions enable you to quickly interact with your data directly in Excel and Spreadsheet. Creating a button streamlines the following actions: Refreshing a worksheet or workbook Submitting a worksheet or workbook Running a data management sequence When you insert an In-Sheet Action button (e.g., Submit, Refresh, or Run DM Sequence) on a Quick View sheet in Excel: It defaults to size 12 font Attempts to increase the font size (e.g., via Excel formatting) often do not persist after refresh or submission This can make the button look too small or misaligned in more styled dashboards. If you managed to format this In-Sheet Action very well, I would appreciate your input. Cheers24Views0likes0CommentsGenesis Parameters (Filters) Issue
I am having an issue with cube view parameters within the Genesis content block "Cube View Comments"? I receive one of two errors - (1) Index was out of range (parameter 'index') or (2) Parameter is not supported. However, if I put the exact same cube view in the "Cube View Advanced" content block, the parameters work exactly as expected. Is this a bug or is there something I'm doing wrong? Any help would be greatly appreciated.31Views0likes1CommentCustomSubstVars Warning Message
I am looking to upgrade from 7.1 to 8. In the process of compiling dashboard extender rules, I get the following warning message. Warning at line 50: 'Public Overloads ReadOnly Property TaskInfo As XFSelectionChangedTaskInfo' is obsolete: 'This is a temporary function used by Marketplace Solutions for backwards compatibility with old XF versions. Please change your code to use supported functionality. Use SelectionChangedTaskInfo instead.'. Question. Is there an alternative syntax that will achieve the same result? As best as I can decipher, the code in question (below) is to retrieve the value from the bound parameter LastActMonth_BDA into a new variable titled newLastActMth. Dim newLastActMth As String = args.TaskInfo.CustomSubstVars("LastActMonth_BDA")Solved29Views0likes3Comments