OneStream Platform Forums

It appears to be possible to set the SiblingID in RelationshipPositionOptions, so it exists as a property.   How do I "read" it to see what it is for a member? Thank you in advance for any assistance.    

All rules in business rules page must be written in Visual Basic.. Question Credit: Andrea Tout Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello,I hope you're all doing well, this is my first time posting in the forum.I recently built a cubeview that contains one Row, I was wondering if there is a way to automatically generate blanks after each member - in my case after each Entity of the hierarchy - and considering that i have multiple member expansions.In order to clarify my request, please find below an overall of how do blanks should be automatically generated (1st Screenshot), you will also find a screenshot of the members used in my cubeview.Thanks in advance, wishing you all a blessed day

Hi, I have a CV Form where the input is a "Date" Cell Type.  I need to use the date to translate to a OS Time Period.  I am struggling with using the Date value in a Business Rule.  It only returns an Integer and I can't seem to convert the integer to a Date in the BR so I can grab the Year (Dim strYear As String = Date.ToString("yyyy")).  Any help with this? thanks, Greg

In looking at the dashboards page, the first item that needs to be created is the dashboard maintenance unit. Question Credit: Andrea Tout Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

When creating a loadable xml format for bulk user creation using internal authentication, we face issue while signing in using the created users (the password encryption and decryption might have caused it)Is there any way out to solve this?For eg. : We created a user TestOS with password as Welcome1 using xml, but when this user tries to log in using the same credential, the user faces sign-in issues.

Hi the community! Do you know the way to proceed to retriev in a cubeview a specific UD where the text of it is set on a specific value? For example I want at the finest level all my UD1 which contain as a Text4 "Long_Lines" I write this as a formula : U1#Shipping_Trade.Children.Where(Text4=Long_Lines) But nothing appears as a result. Did I missed something? Thank you.

Hello all, This one is a bit of a doozy, so bear with me. In this specific instance of an application, we have multiple cubes that share identical hierarchies, except one cube uses the Entity dimension, and one uses the UD2 dimension. Ex. below: Cube 1 = E#10001 Cube 2 = U2#10001 Our goal is to have a cube view that compares the actuals from Cube 1 to the Forecast of Cube 2. We have tried many ways to work around this, resulting in our most recent endeavor of using UD8 dynamic calculations to return a data cell value from a member script in Cube 2. Our issue is that while the UD8 shows the proper data, it does not allow end users to properly drill down from the data cell. It also does not allow a user to see the proper cell POV of the data being presented. Is there a better approach to this? Essentially, the goal is to have the row dynamically switch between the dimensions, UD2 and Entity, based on each column. Other constraints to note are that this cube view needs to be created using

Is there a good resource that people use to explain what is contained in each version of OneStream. I read the release notes but I am looking for perhaps a good blog to help explain these features in detail. I typically meet with our Finance users before we upgrade to let them know any features that may be useful to them.

We are trying to load txt file to custom table using LoadCustomTableUsingDelimitedFile but when it runs we receive a "Data load file is invalid or missing" error. The file is manually selected from a folder.  The file is correct, the number of fields in the file and in the table match, the values and the field type match and the field separator is correct. We are uploading the file from a Dashboard button component which calls a Dashboard extender BR. This is the BR code:   Dim filePath As String = args.NameValuePairs.XFGetValue("FilePath") Dim tableName As String = args.NameValuePairs.XFGetValue("TableName") Dim loadResults As TableRangeContent Dim fieldTokens As New List(Of String) fieldtokens.add("field1") fieldtokens.add("field2") ... fieldtokens.add("fieldn") loadResults = BRApi.Utilities.LoadCustomTableUsingDelimitedFile(si, _ SourceDataOriginTypes.FromFileUpload, filepath, Nothing, ";", _ "Application", tableName, "Replace", fieldtokens, False)

Hi all, I am working with navigation links in my cube view. However, when I open the 'linked cube view' through my 'main cube view,' I get the member filter to show in the title of the dialogue box that opened. These are the bound parameters that I used in the 'main cube view.' Is there a way to remove the member filter from the title bar in the dialogue box? I've included below what I mean with the title bar and my issue.  I appreciate any help you can provide. Kind regards, Floris van der Poel

Hi, Do we get to see the member updates made in Dimension Library in the Task Activity? I don't see a Task Type related to this in the Task Activity. It gets recorded when I use an XML file to update the dimensions, but not the manual changes made there. Is there any setting that needs to be made to get this information in Task Activity or should I be checking somewhere else? Please let me know. Thanks in advance, AK  

Is there a way to get the list of components on the calling dashboard on load? Trying to use:args.ComponentInfo.Component.Name results in nothing, even though I have multiple components on my dashboard. I want to get a list of all components, particularly a label or 2, and based upon user settings/access/Text fields, set labels

When a translation or a consolidation is run, the AdjInput entries are rolled into the AdjConsolidated member. This rollup occurs as the data is moved along the Consolidation Dimension. Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Dear Community, There is a possiblity to retrieve parameters currently available in a dashboard using for instance :      Dim str_myParam As String = args.SelectionChangedTaskInfo.CustomSubstVars.XFGetValue("MyParameter")     However, this means that we need to know the names of the CustomSubstVars currently in the dashboard (in that case, I need to know that the parameter MyParameter is indeed available in the dashboard). In my use case the user can open several cube view hence the parameters will change from one Cube View to another.  Is there a way to list all current CustomSubstVars available in the dashboard ?    Regards,

I have created a Dashboard Dara Set BR and I am attached in the data adapter. When I am trying to execute the rule am getting 0 data. See below the entity is always passing as None but when I add a log message in the code the variable is passing based on the selection and printing the correct entity. in My CV i also have the FDXentity parameter. Any Idea why it is happening ? Original Query  {FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=Data,entityDimName=E#|!FDXEntity!|} Substituted Query  {FDX_CUbeView}{ExtractCubeViewTimePivot}{cvNameToExtract=Data,entityDimName=E#None}   Thanks Krishna    

Happy New Year Everyone! I am hoping someone has an example of how to use the formatting rule in OneStream Dashboard Reporting to change the style of any row in table oContent where label13 (field OFCvRAVAR in my dataset) is not zero. I think it's also possible via a script ... Have been looking in Golfstream for an example, but no luck. Thanks!

Hi All, We are looking for a way to put a currency override on movement flow member (ex. dividends, redemptions, etc...). The current override logic which was provided was OneStream is leveraging the flow dimension to conduct the currency overrides so I am having trouble in determine the best way to work around this. If anyone has come across this before please let me know. I'm looking forward to hearing from you. Cheers!

I can drill from the Journal report Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

If I like to migrate a HFM rules file, is there an equivalent to the HS.con function?

Hello All, How to add validation for an account while importing TB. Condition is that, number should be > 0 then allow. If  'account code'  < 0 then throw error and validation should fail or show error message  Thank You. Regards, Yashwant

Hi all, I'm receiving the error in the subject when executing a MemberList. This is the ML code, it should retrieve base member of "TF" in the flows dimension with SwitchType attribute set to True. Dim objMemberListHeader As New MemberListHeader(args.MemberListArgs.MemberListName)Dim objFlowList As List(Of member) = api.Members.GetBaseMembers(api.Pov.FlowDim.DimPk,api.Members.GetMemberId(api.Pov.Flow.DimTypeID,"TF"))Dim FlowMemberID As IntegerFor Each FlowMember In objFlowList   FlowMemberID = api.Members.GetMemberId(api.Pov.Flow.DimTypeId,flowmember.Name)   If api.Flow.SwitchType(FlowMemberID) Then objFlowList.Add(flowmember) NextDim objMemberList As New MemberList(objMemberListHeader, objFlowList)Return objMemberList Any advice, really appreciated Thanks and regards Massimo

Is there an easy way to traverse with in a cube view like ctrl home, ctrl end, ctrl + up arrow, ctrl + down arrow in a Data explorer view. Need help.

Hello!  Looking for some feedback on how your company records and reports on both IFRS and GAAP standards. Do you use a UD as a sort of data type to record adjustments where they differ between IFRS and GAAP? Or do you use different accounts with an alternate hierarchy? Or something different?  Interesting in hearing from anyone with any suggestions - thanks!

Hi, Can anyone help me how I can use this Selection Change server task I know how to run a DM Sequence from button but if I can directly run a custom calculate without a sequence that will be great. I tried these syntaxes, but it is not working.   Thanks  Omkareshwar