OneStream Platform Forums

Originally posted by Cosimo Palmisano6/19/2019 I've got a dashboard button that, when clicked on, needs to prompt the user to select an item from a bound list parameter and this selection is then used within a business rule.

Originally posted by Cosimo Palmisano3/5/2020 Could this be done using a basic chart component or would I need to write a data adapter BR to set this up? 2nd screenshot is the cube view / data set that I'd want to use for chart data.

Originally posted by Eric Osmanski 11/5/2019 Anyone got a new version of the auto add member extensibility rule?

Originally posted by Eric Osmanski4/15/2019 If I create this as a Dashboard I don't believe I can get it like this in a Report ... is the only way to go to Studio?

Originally posted by Chris Briscoe9/30/2019 IS there a way to set up OS to launch a PDF report (or book) from a Dashboard button? I searched but cannot see any? I understand you answer above tho.

Originally posted by Eric Osmanski1/20/2020 Has anyone come up with a clever solution to multi select members via a parameter on a CV?

Originally posted by Christian Wetterwald8/29/2019 I'm building a dashboard with a cubeview and some drop downs. For the parameters, I need to specify the workflow cube, but when I select U3#Top.base, it is showing the lowest base members of the complete dimension and not the base member of the selected cube dimension. Is this expected behavior? And if yes, how else can I get the base member of an extensible dimension?

Originally posted by Christian Wetterwald11/1/2019 I like to use the Literal Parameter values in a project (no presales activity) to pass parameters to a business rule.Looking at it from a business rule, the Dashboard object has an accessible property but it is just a string. Dashboards Literal Parameter setting.

Originally posted by Mike Kral Can you have a Workflow where you load data for all entities but then have other Workflows where you disable the Import Channel but use the Forms Channel? We are attempting that but once you disable the Import on the other Workflows then the Central Import data will not validate as it states there is not a open Import Channel for a specific entity.  The entity is assigned to the other Workflow so that those users can complete Forms.

Originally posted by Celvin Kattookaran8/2/2018 Can dashboards to valid intersections. Selection of one drop-down automatically redraws valid selections from another drop-down.

Originally posted by Catherine MartelDoes anyone know about a report that will show closing status in task manager on prior months that we could give to our external auditor as a proof of internal control? thanks    

Originally posted by Celvin Kattookaran12/20/2019 In LRP cube Entity is at upper level. However, that is not true for all entities it is a ragged hierarchy.How do you handle this scenario.Create separate hierarchies for both cubes with a prefix? Now how about the data movement? DM job to pull parent data, again some entities are base at both cubes. Swap entity to a UD and extend it, now what is implication for this - client is not happy with changing entity Add a field which says which entities to extract How can i handle data entry for LRP at Houston and other base entities (some could be base in Finance cube and some are parents) and move Finance data from Finance to LRP.

Originally posted by Celvin Kattookaran4/24/2018 I'm trying to create a copy of UTM_HelperQueries, I created a copy of UTM_SolutionHelper and trying to reference that in my new helperquery (UTMR_HelperQueries). It'll not allow me to do reference the main class. Dim utmHelper As New OneStream.BusinessRule.DashboardExtender.UTMR_SolutionHelper.MainClassSaysError at line 141: Type 'OneStream.BusinessRule.DashboardExtender.UTMR_SolutionHelper.MainClass' is not defined. If I edit UTM_HelperQueries same thing happens (changing to DashboardExtender.UTMR_SolutionHelper.MainClass) Is there a way to do this, I don't want to change the default helperquery.

Originally posted by Cameron Lackpour6/15/2018 I have a terminate-with-extreme-prejudice calc that clears data and the client has asked that there be a, "A you really, really, really sure you want to do this?" message.

Originally posted by Andy Moore2/26/2020 does anyone have any good admin dashboards they could share for admin activities ?

Originally posted by Barry Nuckolls 3/3/2020 I am trying to come up with an Analytic Blend example with the client's metadata/data on the UPS project. I have put Building and Division as Attributes 1 and 2, respectively. I did not put aggregation points for either of them in the BI Blend workflow however. I did put aggregation points well below the dimension tops for some but not all dimensions.  

Originally posted by Andy Moore 5/31/2018 How can I call a Dashboard Extender function, from an extensibility rule ?

Originally posted by Andy Moore5/24/2018 Does anyone know the process for activating mobile dashboards/cube views?

Originally posted by Andrea Tout11/14/2018I know you can have a dashboard that lets you click a cell in a cube view and refresh a chart in the other panel, can you do it with the studio report?

Originally posted by Darryl GerrowDoes anyone have an example of how to use VisualBasic in Excel to call the OneStream XF functions, specifically the "Refresh Workbook" and/or "Submit Workbook" API functions?   Thanks,

Originally posted by Felipe Alcorta Hello: We'd like to incorporate variance explanations into our cube views.  If the cube view shows one periodic comparison (e.g. Jun YTD CY vs June YTD PY), we have a corresponding dynamic calc that calculates the variance and we can use the (out of the box) variance explanation from the View dimension in order to have comment/explanation functionality. However, if we have multiple comparison period in the same column template/cube view, we are unable to.  If we take the same approach as one periodic comparison, the same comment would appear in both comparison columns since there's nothing to distinguish which periodic comparisons are being explained against.   We tried using a placeholder UD8 elements (no formulas) in addition to the variance explanation from View dimension but OneStream says it's an invalid cell.  Advice?

Originally posted by Rob Gaughran6/11/2020 I have a 6 tab Data Explorer dashboard.Can I specify a default tab rather than it always defaulting to the first tab?

Originally posted by Christophe JelskiHello all, I am building up graphical reporting (charts) and I am kind of stuck, lacking features I am used to in XL. I could not find any how to guidance on the subjects, like : - trend lines - combo charts displaying components in stacked columns (AR, AP, INV) and total (working capital) as a line - regression line on scatter. I am attaching quick displays comparing OS (what I managed to do) and XL (what I am aiming at in). For the moment, I am sticking with cube view dump in XL, but if I could make it available online, this would be even better. Anybody facing the same issue ? Anybody found a solution ? Thx for your feed. CJ    

Originally posted by Geoffroy des Dorides4/27/2020 Import data on multiple scenarios within the same workflow and without changing the scenario in the POV: If scenario ACTUAL is selected I am able to import in my workflow only files of Data for Actual scenario. During the Actual process, my client is loading ACTUAL data and restatement on other scenarios such as ACTUAL_LY (actual comparable last year).

Originally posted by Sean Hogan 10/11/2018 Remove a user's ability to input data within a workflow where they have access to Workflow Execution Group? They require access to the workflow for Certification purposes only but must be part of the Workflow Execution Group to actually execute that Certification step