OneStream Platform Forums

This is a doubt with the rest of the questions I have, and is that in the new workflow I created, when I hit complete worklfow there are two data management that are not executed (COPY_PLP_TO_PLN, PROCESS_PLP), which are below, but I try it in other workflows and it works correctly. Then I wanted to know how I can solve this in the new workflow, so that when I complete the workflow it also runs those data management as in the others.    

I got this validation error in plp's Export to cube, and I know it's because I don't have that entity associated to the workflow, but I would like to know if there is a way to solve it without having to remove that entity from the other workflow in which it is.  

Is there any way I Can enter a +ve or -ve value based on the text property if a Flow member in a form. I think a Save Data Event Handler can, but I will throw an error if the only after the form is saved. What if the cell color will change (Just like in Excel) if the value enter on the form  should  +ve or -ve value based on the text property if a Flow member. is this achievable.   TIA, Nik

Hi everyone. I would like to see in which section I should put the name of the UD5 in an entity, since I see that it has a section for that but in the text part I see that other configurations also, so I would like to know where to put it so that they are connected, as well as about the UD5, about where the entity should go so that it is also connected. I do this because I want to try to make a connection equal to that of the IC with the entity Entity UD5  

Hi Everyone. I wanted to know if there is a way to send emails that are made with parcel service automatically, for example, to send a certain number of days at a certain time, I would appreciate if you could help me to do something like that.  

Hello, How can I seamlessly integrate SAP with Onestream in such a way that I can pull specific data for specific intersection? For example, let's say I want to only pull data from SAP that has entity as ABC and account as 123. How can I do that? It should be completely user driven and minimal intervention from administrator. Thanks

I keep receiving this error when attempting to run my dashboard that has a BI viewer component attached to it. I made a bi viewer component and assigned a cubeview MD data adapter to it. created my BI viewer and everything works fine. However, when I assign it to my dashboard I get this error. I've tried attaching other cubeviews to the data adapter and making other BI viewers but I keep getting the same error. Has anyone else run into this issue?    

Hello, We are currently seeing slow consolidation times after we copy data from one scenario to another. If we run a force consolidation in the source scenario the full year takes around an hour or so. When running the consolidation in the target scenario it is taking 4+ hours to complete. Both scenarios are using the same scenario type.Anyone have ideas on what could be causing this issue? Seems odd that the same data set would have such huge deviations in run times. This is the second quarter we have seen the issue.  Thanks for your help! Tim

I want to run a DM job from a dashboard (with the task popup showing progress, so no background running) and then when finished have the originating dashboard refresh after updating a parameter used in the dashboard.   If I call the DM job directly from the dashboard I am not sure how to return a task result that will update the parameter value in the dashboard.  I tried using a BR that called a DM job and then updated the parameter and refreshed the screen. However, when running it this way the popup did not appear and it just froze the screen, sort of negating the value of using the DM job.  Has anyone successfuly tried to do something like this before?

Hi all,  I use the dashboard to trigger data import from external database. After successfull import I want to make the workflow step (type Workspace) complete by calling SetWorkflowStatus. Strange thing is that is does work when I directly call the Extensibility rule from Button, but it does not when I call the same rule from data management process. Do you know why this happens and how can this be bypassed?  Thanks for help! Pavel  

Hello All, Any ideas how I can remove these "0's" from the background in the Cubeviews? Is there any property that will make it disabled?

In developing applications, I prefer to group objects intuitively using standardized naming, alphanumeric sorting, and hierarchical grouping.  Dashboard parameters use the "Sort Order" property to sort, which for me adds unwanted cognitive load to a development process.I developed the code below to automatically sort and group parameters the way you would expect them to be sorted to get around the need to specify Sort Order. Implement as an extensibility rule and run it from the editor.  After the rule is run, copy, paste an existing parameter, then delete the pasted parameter to force a refresh of the list from the server.  Be sure to remove this code from your production applications. C# using System; using System.Data; using OneStream.Shared.Common; using OneStream.Shared.Database; using OneStream.Shared.Wcf; using System.Linq; using System.Text.RegularExpressions; using System.Threading.Tasks; using System.Collections.Generic; namespace OneStream.BusinessRule.Extend

Hi Everyone, These tables house information about the Environment tables, and also the Application Tables.  It would be ideal to have not only know information on the fileds in these 2 tables mainly are the fields in GB or Tera Byte, but also the best place for information about the tables that come with OneStream. Thanks in advance of your help

Hello, I'm looking for a member formula, or business rule to copy data from an entity to the IC entity, where also another UD member is substituted. Example of source data: Cb#100:E#3100:P#?:C#EUR:S#May_C2:T#2024M5:V#Periodic:A#ICfreightPrice:F#Calc:O#Import:I#3342:U1#110F:U2#3100:U3#3344:U4#4002177:U5#None:U6#None:U7#None:U8#USD Destination: Cb#100:E#3342:C#Local:S#May_C2:T#2024M5:V#Periodic:A#ICfreightPrice_Pur:F#Calc:O#Import:I#3100:U1#None:U2#3344:U3#None:U4#4002177:U5#None:U6#None:U7#None:U8#USD So entity becomes IC, U3 becomes U2. To substitute 1 I can use a For each loop, but how can I add a nested For each? thanks a lot for some guidance. Ben

Originally posted by Vignesh MohanHi, I am trying to import data from Snowflake using JDBC / ODBC connection. In the Snowflake side a view has been created with the correct data set for the import. The connectivity as such works as I tested the same through the Data Adapter in the Dashboards. I am able to retrieve data for the same query that I am using in the connector rule using this test method. The data structure type in the data source section in OneStream is setup as Matrix data as I need some of the column names to be mapped to the Accounts dimension members. When I run the data import from the workflow, I get the following error, No valid DataKeys (Scenario / Time) found in data source.  Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source. All dimensions are mapped appropriately in the transformation rules. I am also using few attributes to import

Hello all, I need to create a dashboard based on a cube view where I have accounts on rows, and MTD and YTD view in columns for actual, actual vs budget, actual vs PY. The request is to have in the dashboard the report with the rows displayed between the MTD and YTD view columns.  Is there any way I could achieve this in OneStream? Thank you! Adina      

We are currently building a simple form for Shipping Days that allows a user to input an entire year's worth of shipping days all at once. We want this to be a Periodic view to align with how the client thinks about shipping days for each month. We are entering the data into our Actual scenario, which has a Default View of YTD. The below screenshot shows the basic form structure and the YTD row is there for reference. The initial data entry worked great. However, if I go back to a previous period to change a periodic value, I want the new periodic value to update for that month and keep the remaining periodic values the same. However, changing a periodic value squeezes the difference into the next month to keep that month's YTD value the same. In the below screenshot, Cell (1) was changed from 23 to 18 in March 2022. The March 2022 YTD amount updated accordingly. However, the periodic amount in April 2022 (Cell (2)) automatically changed from 20 to 25 so that the YTD amounts for April

  Hi, I am trying to use Cube View (already added in Data Adapter as Cube View MD) within the Report Designer of the Report component. However, I am unable to see the row-wise values for Entity and Account, and the column-wise UD8 for Text consolidation. I have checked various Data Adapters and Report components in different MarketPlace solutions but have not found a similar case. There also appears to be a lack of comprehensive video tutorials or study materials on using the Report component. Could you please assist me with this? Thanks

I have a column where I'm using a GetDataCell formula and I want my Time Row Header to show a date different than that of the Pov.  I've had a solution that uses a Business Rule but wanted to see if an out-of-the-box solution is available. 

Hi all I like to check a manual data entry during save. Is this possible?  

Hello, I have a list of segments in WFText2 that I use as UD2 dropdown selection for my cube view.    So whenever I open my Form/Cube View I can see all segments excluding GBA_021, GBA031, GBA_032 and GBDP_001,  in UD2 Dropdown selection. My dilemma is, I am creating a confirmation rule that will loop for each UD2 that were not stated to be removed. I use this to get Text2: Dim WFText2 As String = brapi.Workflow.Metadata.GetProfile(si,si.WorkflowClusterPk.ProfileKey).GetAttributeValue(ScenarioTypeID.ScenarioType1, SharedConstants.WorkflowProfileAttributeIndexes.Text2) And the entire UD2: Dim GBA As List(Of Member) = api.Members.GetBaseMembers(api.Pov.ud2Dim.DimPk, api.Members.GetMemberId(dimtype.ud2.Id,"gba")) I initially used this GBA in my confirmation rule but it also includes those that were removed in WFText2 in the loop.   Any advise would be helpful.

Hello I am trying to create a type of dashboard that will contain multiple reports. I want that whatever report has data, only that should appear and report with no data should get suppressed along with its rows and columns too whenver I execute a dashboard? Can this also be achieved via a Cubeview? Please suggest?

Hi Experts, I am trying to use a member filter based on the Text property. Here are the sample text property values: Member1  = PASSTHRU~[False]|IPL~[False] Member2  = PASSTHRU~[True]|IPL~[False] I wanted to filter the members that have " PASSTHRU~[True] " in the text property, i tried the filter below but it returned no results: U4#Top.Base.where(Text8 Contains PASSTHRU~[True]) I do get results if i use U4#Top.Base.where(Text8 Contains PASSTHRU~), but as soon as i add  " [ " character, it doesn't pull any members.  Any suggestion would be helpful. I tried all the below formats, nothing worked: U4#Top.Base.where(Text8 Contains 'PASSTHRU~[True]') U4#Top.Base.where(Text8 Contains [PASSTHRU~[True]]) U4#Top.Base.where(Text8 Contains PASSTHRU~[[True]])

I am looking to create a FX Rate finance rule or calculate to go get the planning scenario's last actual month's closing rate from the ClosingRate FX table. I am using the consolidation member C#Aggregated in the planning scenarios.  I know that C#Aggregated executes business rules at the base level only. Is there a workaround here or if I use C#Aggregated am I stuck creating FX rate tables for each planning scenario and copying last actual month rates forward to the planning periods? Appreciate any help or guidance.  Thanks 

Hi All, Is there a way to set up default workflow POV period each month for users instead of them going into the tool and changing the period .     Thanks in advance.