Issue 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,3.1KViews0likes12CommentsEvent Listeners / Custom Control in a Dynamic Dashboard
Hello, To standardize the look and feel of my dashboards, I would like to create a reusable dashboard template for a toolbar. The Menu component seems well suited for this purpose. However, some actions (for example, Save) cannot be defined at the menu item level and are only available at the menu component level. As a workaround, I am using Event Listeners: each menu item sends a parameter value, which is then used as the Event Listener name. This allows me to have one menu item that performs a Save action, another that launches a business rule, another that opens a dialog, etc. This approach works fine until the Custom Control dashboard is embedded in a Dynamic Dashboard. The issue can be easily reproduced by embedding the dashboards described in this blog post into a dynamic dashboard. Any help or guidance would be greatly appreciated. Thanks in advance.59Views0likes2CommentsDynamic Cube Views and Workspaces
Dear community, I was reading the documentation about cube view services, which implies that the dynamic cube views that are accessible by Dynamic Cube View Services need to be in the same workspace. Do you know if this is mandatory to have dynamic cube views in the same workspace (as it seems a like a real issue in production) or is there a workaround to address dynamic cube views that are outside of the assembly's workspace ? Many thanks,66Views0likes3CommentsHierarchical display in BI Viewer
Hello All, Is there a way to obtain hierarchical view of dimension(s) in BI Viewer components (like pivot grid) when you use Cube View MD as a source ? In other words not to have all members of dimension(s) as flat but still to have the parents of the dimension displayed as totals (as it would be displayed in a CV) Thank you MatthieuSolved1.8KViews0likes2CommentsButton Parameter Not Resolving in 8.4.4
Our two environments are currently on different OneStream versions. DEV is on 9.1.1 and PROD is 8.4.4. We have an upgrade scheduled to get them in sync soon. However, currently facing a parameter resolving and passing issue while trying to migrate some functionality from DEV to PROD. All setups are now equal between the two applications for the workspace that I moved over to PROD. However, I believe version 8.4.4 is having some trouble resolving parameters being passed to a button click that I have on the same dashboard. I have a button whose "Selection Changed Server Task" is set to "Execute Data Management Sequence" and "Selection Changed Server Task Arguments" is set to "{FilteredForecastRollforward_ButtonRan}{SelectedContracts=[|!param_SelectContracts!|]}". Within 9.1.1 DEV this data management sequence runs no problem an receives the value of "Contract1" upon logging. However, in 8.4.4 PROD this parameter is not resolving properly and comes as "|!SelectedContracts!|" in the error log even though the setups are identical. Upon checking the 9.1.1 release notes I noticed that there was a fixed issue number "PF7-9772" under "Dashboard Components" that states "Button Component: The Button dashboard component respects the Selection Changed Server Task value, ensuring that Business Rules are run on the designated servers as configured. (PF7-9772)". Could that fix number be related to my problem? Does version 8.4.4 have a known issue with resolving these parameters. And if so, is there a workaround or do I need to wait until our upgrade for this to be resolved? Button: DM Sequence:119Views0likes4CommentsExtract dbo.vStageSourceAndTargetDataWithAttributes data to csv or txt
Hi everyone, I need to add a button to a dashboard to allow users to export to csv or txt some data from the staging area, specifically from dbo.vStageSourceAndTargetDataWithAttributes I tried multiple approaches using a dashboard extender but cannot find the right way to do that. Has anyone done that before and has any suggestion or best practice to do it (even without using a BR)? Thank you for the help!45Views0likes2CommentsDynamic Parameters in Dynamic Dashboards
Hi everyone, I'm curious if there is any information on how to use the dynamic parameters in the dynamic dashboard service. I've created a form is dynamically generated from a SQL query - essentially the query results contain the text I want to display next to the component, the type of component, the bound parameter for the component, etc. I also have a field for "list of values" that I'd like to use as the display and value items for the bound parameter for Combo Box components. Here's a screenshot of the table that holds this information: Right now when I generate the form, parameters bound to text boxes don't have to exist in the maintenance unit and I can use these parameters to collect data and save to a table I created on the database. For the combo box parameters, however, I currently have to create those in the maintenance unit. It feels like there should be a way I can fetch the display and value items based on my List of Values column for a dynamically generated parameter, but I'm not quite connecting the dots. Any information on this would be much appreciated!632Views1like2CommentsReturning text from a BR# inside GetDataCell — possible?
I'm building a cube view column that shows combined annotations from descendants. I'm calling an Finance Cell Service BR from inside GetDataCell so I can pass dashboard params needed for the logic. GetDataCell(T#|CVTime|:BR#[BRName=..., FunctionName=CombinedComment, Flux_ID = {fluxID}]:U8#{ud8}):Name({ud8} Combined). I need to the UD8 POV member because that distinguishes what type of comment it is (CMvsPM, CQvsPQ, CMvsPYM, Ect...). The BR returns a String, but GetDataCell expects a numeric amount so the text doesn't render in the cell. Pointing the column at V#Annotation doesn't help either. Has anyone gotten BR-returned text to display in a GetDataCell with full POV/param context? Thanks, Ben56Views0likes0CommentsSICResults Table Name
We are having an issue with many of our Data Adapters. The Results Table Name continues to return as "SICResults". They are using a DataSet BR. Not all of them have this issue, even though others are using the same DBConn Connection. This does not happen when using the External SQL Connection This is an issue when we try using 2 adapters on the same Report Component. We cannot have 2 data sources with the same name. Of the 4 ways to change this name: 1) Place the table name in the call of a New DataTable() 2) Use the TableName property after a new DataTable is made 3) Name the query result "Select .......... AS TableName" 4) Use the Results Table Name within the data adapter. Our code has no reference to "SICResults" anywhere. None of our code does. We just upgrade to 9.2Solved35Views1like1Comment