OneStream Platform Forums

Hi, in reference to the code sample below.  Is it possible to visualize the consolidated comments on separate lines in a cube view?  They start running together and get hard to read.  I tried inserting Environment.NewLine or {vbNewLine} into the code but that did not seem to work.  Any suggestions? Finance Dynamic Calc: Annotations Consolidations thanks, Greg

Hi, I'm trying to build a cube view having a list of Entities on the rows. I'd like the row label to be the entity description followed by the entity currency. I was trying to use the Name function to do that. I am able to display the entity currency like this for example: E#Tot_Entity.TreeDescendantsInclusive:Name(XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Currency)) Similarly I can use the XFmemberproperty function to retrieve the member description, like this: E#Tot_Entity.TreeDescendantsInclusive:Name(XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Description))   However, I have been unable to combine the 2 things. How do I concatenate strings within the Name function? Thank you

Hi  Do we have any process or procedure which helps in migrating OneStream application from one environment to the other.We are aware of application load or extract. Do we have any another best process which can help in migrating to adopt only recent changes to application. ThanksChand

I currently have accounts tagged with a text value within Text1 default. There are rules which refer to the text value.  My question is, if beginning in 2022M6 (for example), how can I set this text value to blank to make sure the formula no longer runs on this account. Let me know if there are any thoughts outside of entering spaces or a different value.  Thanks for the help. Cheers!

Hi all, Does anyone know how to easily overview changes in the EntityDim in terms of Percent Consolidation and Percent Owenership between periods and years? Can this be extracted in a prebuilt report or built in a cube view? For example if I would like to get a snapshot of one hiearchy in the EntityDim including percent ownership and percent consolidaiton for period 2020M10? Thanks, Fredrik

Hi, I have created a dashboard which contains multiple BI viewer components. Each BI viewer component is composed of a data grid and a set of list box filters. Is it possible to setup the BI views so that the selection done on the filters by a user is retained when switching to a different BI view within the same dashboard.If an user select the Cost center "0002 Internal Audit" in the first BI view, and the same user then select the second BI view, the selection on the Cost center filter (which is available on both BI views) is not retained and the filter defaults back to "Select All". Is there a way to change this behavior? Is there something I should have setup to have the filter shared between the multiple BI views?Thank you

Hello, In another post user KarlT suggested the use of the UD defaults available for UD1.  I manually updated members, and the functionality is exactly what I need. I need to update the field through a data load.  UD1 members (Projects), will always have a single UD4 value.  In the current TransformationEventHandler rule I am updating text fields in my UD1 members.  I thought I could just duplicate the code an update UD4Default.  However it is not working.  I know it is trying to update the UD4Default value, because if I manually assign a value, it gets cleared when I load. My 2nd thought was that since it is a member selection and not a text field I needed the member id.  Which is my attempt below.  Any thoughts or suggestion? 'A3 is the department (UD4) example 189 'UD1Attr1 is the project (UD1) example 14123 'D1_Defaults MembersDim DeptId As Integer = BRApi.Finance.Members.GetMemberId(si,dimtypeid.UD4, A3)Dim UD1Dept As MemberInfo = BRApi.Fina

We recently upgraded from 6.8.1 to 7.1.3 and I have about 5 users who are having issue with Excel add-in.All of them are getting below error once they login. I tried disabling all other add-in etc but it’s not working.Any ideas?Saurin

Hi all,  In a CubeView we want to see selling and buying members in one row. So for Column 1 is sales where the Entity is the selling entity and IC is the retrieving entity. in the same CubeView Column 2 is stock where the Entity is the Buying Entity and IC the selling entity. So for Column 1 i want to see E#Entity:I#IC and for column 2 E#IC:I#Entity. This is straightforward in an xfGetCell in excel but then i cannot do row suppression. I haven't found a way (yet) to get the current row's Entity and populate the IC dimension with that value using e.g. an xfbr rule.   Thanks in advance,  Marc

Hi,I'm trying to create a dynamic calc script that will increase this column's value by 1 for each member in the adjacent column. For some reason, my script is not doing it instead it is returning the same number 2, Would you guys be able to assist with this?  I'm trying to do it in a cube View. Thanks. In reality, I just need to increase each row number by 1 and I believe it may be possible. Ideally, I want it to be a Dynamic Calc over an XFBR. Has anyone done this before? Can it be done in the UD8 Dimension?

Hello,   As my title indicates, I am trying to create comment columns within my CV's that utilize the V#Annotation and V#VarianceExplanation members and am stuck at a roadblock with this error: Error saving data attachment. The intersection is read-only. Is this something handled within security? Any help is appreciated.   EDIT: I have heard that one possibility is that this is not a base level member that I want to make a comment to. Could that be the reason why? And if that is the case, is there a way to get around this?

Hi All, I am very new into the OneStream world. Wondering for those OneStream Functional Administrators out there, do you have the “Administrator” role or it is just for the IT team? I have been a techno and functional guy in the HFM world for many years, so I am not used to lose the admin rights. Just want to see whether it is a common practice out there that I need to adjust. Thanks in advance! * This post has been migrated from Champions

Hi Team, I would like to understand how you are managing the Entity changes on a monthly basis. For eg: the Entity name in 2021 M6 is San_Jose_213 and it is changed to SFO_213 in 2021 M7. If I choose the rename option, then 2021M6 cube data will override but custom tables created for our requirement will remain with the old MEP name. On the other hand, if I chose to create a new entity how to intact both the entities for future reference

Question on how to loop UD#1 children using the member filter type, UD#1 loop definition and a POV parameter. I get only the first child’s data on all of the multiple pages. If I same my select department I am able to see the different pages but no data is coming into the Cube View. Posted by Carol Vredeveld Migrated from Champions

Hi All, We are exploring an option to extract the system log from System database table. Table names are “TaskActivity” and “UserLogOnActivity”. If any one of you can guide me, what would be the best way to achieve it. Thanks & RegardsMayank Posted by Mayanka Bhusan Migrated from Champions

I am testing an update from version 5.1 to 6.4. In our current version, when I select a workflow form that opens an Excel file with an embedded Cube View, the form opens with the Excel menu set to “OneStream XF”. This was good because the user can input data and hit the Submit Sheet button with a single click. Now in version 6.4. the form opens and the default menu item is “File”. Requiring the user to first change the menu to submit data. Is there a way to set which menu item opens by default? Thank you…Bill Posted by Bill Walke Migrated from Champions

When building CubeViews there is the .remove string that you can use to exclude a member from a hierarchy that you are pulling. Is there a way to replicate this with =XFGetCell formulas? Or in general, a way to include more than one member in an XFGetCell formula? Posted by Dylan Cox Migrated from Champions

Hi Team, Can Tableau Connects to One Stream ( on Azure Cloud ) ? Best Regards and Thanks Darpan Bhansali

Hello Friends,does anyone enabled paging controls on Cube Views?that will be a nice feature to use when we have more number of rows.  Capture.PNG.jpg3288×1118 310 KB got this info from release note.Under the theme of Performance and Scalability , we have continued to enable faster performance on large data sets by allowing users to manage paging controls on Cube Views and by enabling Sparse Data Suppression on Excel Quick Views. This feature increases performance for ad-hoc analysis on large data sets within Excel Quick Views.ThnxKP Migrated from ChampionsPosted by Khirod PAlai

Hi all! Having a copule of questions about consolidation method input and storage:  - Could you please advise on any way to input consolidation method, except changing it directly in Application-> Entity Dimension -> Entity member property? - Why the consolidation method property, when retrieved through the Cube View, is seen only at C#Share level? The consolidation method account is a DynamicCalc member one, and there is no any restriction on the level of consolidation it should be calculated on fly: Select Case    api.Entity.OwnershipType()Case ownershiptype.FullConsolidation    Return 1Case ownershiptype.Holding    Return 2Case ownershiptype.Equity    Return 3Case ownershiptype.Custom1    Return 4Case ownershiptype.Custom2    Return 5Case Else    Return 0    End Select       

Is it possible to dynamically set the Bound Parameter of a Supplied Parameter? I have tried to use and xfbr rule to do this but the supplied parameter but this does not work.

Hello - I am am trying to produce the parent for an entity under Gathering_Processing segment node. However, because this entity is shared, the parent entity returned by the VB below is not the one I need. The parent returned is RRC_STXGasUtility which is flat hierarchy and includes the entity in question. Can you please advise?   Dim ggpelimftr As String = "E#Gathering_Processing.Descendants"Dim ggpList As List(Of MemberInfo) = api.Members.GetMembersUsingFilter(api.pov.EntityDim.DimPk, ggpelimftr, Nothing) For Each ggpe As MemberInfo In ggpListDim parentIdstring As String = String.EmptyDim ParentList As List (Of Member) = api.Members.GetParents(api.Pov.Entitydim.DimPk,ggpe.Member.MemberId,False)Dim ParentMember As String = ParentList.First.ToStringDim ParentArray() As String = Split(ParentMember)parentIdstring = ParentArray(2).Replace(",", "")parentId = Convert.toInt32(parentIdstring) Next

Hello,    I am trying to create a hierarchy for cubeview reporting that is based on a series of metrics that are extracted from the Journal Line Item application database table.  The metric is based on one half of the JE, but it is only applicable if a specific account is used as the other half of the JE.    For example, if I have two journal entries, one using accounts A & B and one using A & C, I need the data from account A, but only for the first entry because the other half of the entry was to account B.  Because the second entry used account C I don't want that value captured in the metric.   I have been able to compile the SQL extract for this, but was wondering if there was a function in the business rules that would allow me to populate a dimension member, similar to a Finance member rule or api.data.calculate.getdatacell, that could be used in a loop, based on the row values extracted, each row being a combination of dimension base m

Hi !We are trying to figure out ways to automatically upload data using either Business Rules / Data Management / Task Scheduling. Is there a way to automatically upload data from flat files or databases using these three components ?Data Management seems to provide only Export functionalities. Regards,

I can have less detail in a base cube. 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