OneStream Platform Forums

Originally posted by Dominic Arblaster2/13/2020 Can we add and name colors? It could be just one custom?

Originally posted by Dominic Arblaster12/2/2019 I am trying to refresh my dashboards knowledge with the Boston Services Summit Exercise 4 and the last step on page 5 needs BarFormat and LineFormat indicators according to the selected chart in the drop down, or at a minimum what constitutes a Bar Chart {BarFormat}:{SS2019_HelperQueries}{|!ParamChartType!|}{profileEntities=|!ProfileEntities!|, selectTime=|!selectTime!|,dataAdapter=da_SalesProductChart}What is the syntax to get the formatting correct? "Now go to your Data Adapters to the data adapter BR and specify the Param Chart Type where “BarFormat” is.""

Originally posted by Patrick Victory Let's say we have ten thousand vendors in the source system. Most (~6k) of the vendors are minor and we don't need to maintain detail about them but we still need to load all of the data. We've built out the dimension to have our "important" vendors in the appropriate hierarchies but I'd like to map all other vendors to an "Other Vendors" member. The problem is that the only way I can think to do with transformation rules is create a 1:1 map for every vendor in the dimension (~4k rules) and then a final *:* to map the rest to Other. This seems like a really terrible solution; management would be a hassle and it just looks bad. I've tried to brainstorm around some kind of connector BR logic that uses a descendants function to return a list of all vendors in the dimension and then write logic based on that but I'm not exactly sure how to implement it and it would destroy the vendor IDs themselves so drilling back would be problematic. The other soluti

Originally posted by Craig Rowe 9/23/2020 I am working with Relational Blending and pulling data from Stage into a dashboard. I am trying to format the value of my data into currency. When I use the query in SQL Server, I can see the correct format, with commas. When I put the same query into my business rule, see the format change the number of decimal places but I don't see the commas.

Originally posted by Cosimo Palmisano7/19/2018 I've got a SQL Table Editor component in a dashboard that queries an SQL View that outer joins two tables. The user can update some fields in a record within the SQL Table Editor component and when they hit save, I call a Dashboard Extender rule that processes the dirty records within the component. The rule starts off by creating an XFSqlTableEditorSaveDataTaskInfo object but not sure where to take it from here. There's the property XFSqlTableEditorSaveDataTaskInfo.EditedDataRows which I assume is a collection of dirty records from the Table component. I'd like to get the ModifiedDataRow values on fields that were updated in the table component so I can write them back to one of the source tables used in the SQL view. Anyone have an example on how to get the value from a modified field?

Originally posted by Barry Nuckolls 3/13/2020 Short of joining to a dimension table to get a member's description, is there a way to configure the blend table build process to use a member's description (alias) instead of the member name?

Originally posted by Eric Osmanski 1/15/2020 Can a large data pivot grid pull from multiple tables?

Originally posted by Haaris Uddin

Originally posted by Jon Kunert I am trying to pull the value of a parameter, =XFGetDashboardParameterValue("IVL_Enabled",True) but it just shows the default value I put in.  If I leave it blank I get #value!.  I guess I am using it wrong but without an example in the documentation I am stuck

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.