OneStream Platform Forums

Hi, I'm trying to pull in the descendants and the parent member of an account into a data buffer. e.g. something of the form FilterMembers(A#All, A#Gross_Sales.DescendantsInclusive). When I log the data buffer and examine my results, however, I'm only seeing the base member data and none of the parents. Could anyone provide me any suggestions on how to pull all of this data into a single data buffer? And can anyone tell me why my data buffer doesn't produce the results I'm expecting? Thanks!

Is it possible to use MTD & YTD in View filter for a Data Management job.It does not work if I use -  V#MTD, Y#YTD, but this format seems to work for other filters like for time if I sue T#2021,T#2022 there are no issues. But only for View filter using multiple filter seems not to work.Do anyone know of any workaround to resolve this?  thanks Kumar 

Hello fellow OneStreamers, I have a burning question that I need to get insight for in regard to environment care. We have a cloud instance of OneStream and have multiple apps on our prod environment. We would like to have a good overview of the app sizes, perhaps in a nice dashboard, so that we can preempt our need to order more storage space and prepare our release schedule. Is anyone using or has developed anything like that? Currently we have to send a ticket to the help desk to know the app sizes and would prefer to have in in our-hands more on demand to plan. Thanks!

Hello! As a EssBase previous user, do you know if it's possible to navigate without data or at least positionning row and colums dimansions without a refresh and once all is done proceed to the refresh. Because  sometimes when it makes 4 minutes to refresh a cubeview and I have to move at least 5 axis to column or row, it takes 5 x 4 minutes Thank you in advance. 

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.    

Hi all, i'd like to ask how can i get in the metadata builder view an initial complete version of the dimensions each time before adding new items?When i have to update the application dimensions,  i would always have the previous situation in metadata builder template as a starting point.Any suggestions will be appreciatedthanks you

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 OSAdmin  We have a use case where the existing base entity members will be removed from the parent entity and the data of existing base entity member or the parent entity member needs to be copied into the new base entity that will be created under it, is there a way we can achieve this within cube through Business Rules or Data Mapping after metadata updates are applied and without asking users to update/adjust manually  The above can happen with multiple parent child combinations.   Before Metadata Change Hierarchy A (Parent entity) - Data - 40      A1 (Base entity 1) - Data - 30     A2 (Base entity 2) - Data - 10   After Metadata Change Hierarchy A (Parent entity) - Data - 40      A3 (Base entity 3) - Data - 40 Orphans     A1 (Base entity 1) - Data - 30     A2 (Base entity 2) - Data - 10   Thanks, Vishal Pai

Hi,  There seems to be an issue when pulling members through GridView from the dimension library.  As shown in the screen shot below, when filtering on a specific roll up within the dimension using the parent child relationship reference the report includes duplicate members. This is because OS is pulling all the alternate roll up locations as well. We are wanting to pull just the main rollup so that we can see the members and parents in separate columns within excel. Does anyone know how to get around this or another way to pull this data from OneStream.        

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

Hi,   I have a saved report setup with XFGets. One of the dimensions on the report points to the member "Top." Is there a way to have the XFGet show Top of the dimension and exclude a base member? Thanks.

Is there a setting or option wherein users don’t have to refresh the XFSetCell based excel reports every time the file is opened?

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.

Originally posted by Aric Gresko

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)

Hey guys! Happy new year. Do you know if there is a way to use more than one dim in the lif section for a calculated field in BI Viewer?  Thanks a lot!

Hi - Is it possible to drill back to the Analytic Blend tables from the cube data? I have an CV MD adapter which pulls the data from CV, and I created a Map & Bar chart and I want to create a Drill Back to the Analytic Blend tables because it has SKU & Customer level data which is not present in Cube. I am able to create the separate but not able to integrate. Do I need to create any Connector Rule? Any thoughts on this topic would be appreciated?   Thanks 

Is there a way to set the default application for all users? I would prefer it to always default to our Production application every time someone logs in.

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