OneStream Platform Forums

Hi - I'm trying to create a new application, but encountered the following error message... Unable to save 'Application Reference'. Invalid parameter.  User Interface Stack Trace: Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)at System.ServiceModel.Channels.ServiceChannelProxy.InvokeEndService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)at OneStream.Client.SharedUI.ApplicationAdminServiceReference.ApplicationAdminService.EndInsertOrUpdateApplicationReference(IAsyncResult result)at One

Hi, I know I can choose on which server to run a data management sequence but setting it in its Application Servers property, or leave the property blank to let OneStream determine on which server to run it. However, when launching a  data management sequence from a business rule, using the BRApi.Utilities.StartDataMgmtSequence() command for example, the Application Servers property seems to be ignored. Is this the expected behaviour? Is there any other way to force a data mgmt sequence to run on a specific server when called from a business rule? Thank you

Hello every expert: I am not able to reference a different scenario member in custom calculation business rule. I tried the following api.Data.Calculate("S#Forecast=S#Actual","A#10100" ...........) in the finance business rule I created. When I run the rule through Data Management Step, I have to specify Scenario and I select Forecast, I got error S#Actual is not valid dimension member when I run the business rule through custom calculate step. I really appreciate any helps from you. Thanks in advance.

hi, I am having trouble keeping the percentage sign for my percentage columns when running a report book from a CV. the percentage sign is working when it is in CV but not when it is exported to excel or when I run it in a report book. I did change the cell formatting for reporting as suggested in another post, which is changing ReportUseNumericBinding to True and set ReportNumbericBindingFormat to percent sign. But it is still not working for me. this is the formatting I am using for the column: BackgroundColor = White, ExcelNumberFormat = 0.00%, ExcelRightBorderColor = Black, ExcelRightBorderLineStyle = Thin, ExcelWrapText = True, ReportNumericBindingFormat = [#,###,0\%], ReportUseNumericBinding = True, ShowPercentSign = True

Hey everyone, Is it possible to display either a text field or any other member filter in BI Viewer Dashboard? When using a CubeViewMD data adapter, I notice that even if the cube view being referenced uses :Name(XFMemberProperty(DimType=Account, Member=|MFAccount|, Property=Text3)) in the cube view it will display the dimension name in the dashboard instead of Text3 the way it does in the cube view? thank you.  

Hi, we would like to build a report with two columns with comments Annotations/AuditComments/VarianceExplanations). Each column needs to be filled in by a different team. The two teams need to be able to read each other comments. I am using UD3 to distinguish these two type of comments (as the requirements ask for variance explanation from more than 4 teams) The problem I am running into is that the varianceexplanaiton column is open for everyone to edit as long as that person has access to that cubeview. I have not found a way to make one column read-only and the other read-and-write depending on the security group. The "Can Modify Data" setting in the cube view does not seem to do anything. Anyone who can help on this?            

We have two 8.2 environments with PLP SV 101. In one environment, all of the parameters for the register field lists display as expected. In the other, the same fields are blank. However, we know there is indeed a value there as the plan calculates correctly and we can see the resulting entities in the export to the cube. For troubleshooting purposes, we’ve been using the entity field (aliased as Department in our solution.) The Register Field List setup is entirely conventional: The parameter is configured the same in both environments: The function in the business rule that it’s calling is the same in both environments. I’ve tested the resulting SQL in SSMS and it returns valid values. I temporarily added some logging to make sure the method was actually hiring and returning a data table as expected; it is. The fact that it does populate the entities when calculating the plan data suggests all of this is fine and it’s just a display bug but nothing I can find seems to allow it to d

Hi all, I was not able to find a detailed guidance on how/when to use different view dimension members, so I would like to seek for advice here. In a cube view, I have a member formula which return either a text or number based on different conditional. For example, if conditional A is met, return a calculated value (sum of Account A and Account B), else return "Not applicable" text.  I notice that we can utilize V#Annotation to display the text, but then it cannot display the number. So, I would like to know if there is a view member to allow display of both number and text.  Thank you so much!  

How do i specify in a  data management task to extract the data to the cube\scenario/workflow step folder and not the user's folder under file share.    

Hello, Could you tell me if there is a way to search in which cube views a certain member is used/referenced ? I thought of doing a export of XML and do a search in notepad++ but maybe there is a better way/more user friendly for administrators which are not technical (which is the case for my current client) Thank you Matthieu

I would like to give my users the ability to launch the DM sequence from the workflow step. I have the dashboard with the button that passes the parameters to the DM package and launches the package. The last step in the DM sequence runs the Extensibility BR that completes the workflow step. Everything seems to work except that the workflow step window does not refresh after the sequence completion. The workflow step appears incomplete even though it is. The click on the "refresh Application" icon is required. Is there a way to address it? My Extensible BR is below:  

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.    

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.  

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?

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?

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      

  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

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

I am trying out a complex expression in Time Data Source. The issue is the next: I have a Forecast scenario type with input frequency monthly and on the other hand I have a Long Term scenario type with input frequency yearly. Therefore, the colum time in the file is yearly, so I developed a complex expression where I can load depending on neither scenario type year 2024 or WFTime (forecast for this case) or scenario type year 2024 + M12 or WFTime + M12 (Long Term for this case). This is my complex expression (that is not working): Dim vYear As String = args.Value Dim scenId As Integer=api.CurrentDataClusterKey.ScenarioIDDim scenType As ScenarioType = BRApi.Finance.Scenario.GetScenarioType(si,scenId) If scenType=ScenarioType.Forecast ThenReturn vYear + "M12"ElseReturn vYearEnd If I appreciate all your comments, Thank you.

Hi, This formula is working, but it's returning 100% for each Entity. Is there something I'm missing regarding Entity? Will this work in a member formula or only in a business rule? Dim entity As String = api.pov.entity.NameDim entityID As String = api.pov.entity.MemberIDDim OwnValue As Decimal = api.entity.percentOwnership(entityID) If ((Not api.Entity.HasChildren()) And (api.Cons.IsLocalCurrencyforEntity())) Thenapi.Data.Calculate("A#NCI_IS:V#Periodic:F#EndBalLoad:O#None:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None= "& _"RemoveZeros(A#Income_Loss_before_Noncontrolling_Interests:V#Periodic:C#Local:F#EndBalLoad:O#Top:I#Top:U1#Top:U2#Top:U3#None:U4#None:U5#None:U6#None:U7#Top:U8#None * ( ("& OwnValue &")))")End If

What is the difference between WorkflowUnitClusterPk vs WorkflowUnitPk? When would you use one over the other?   Thanks, Scott