Preventing YTD true up for Attribute Member?
Hi, I've set up Attribute Members in my application. They are using Text fields in my UD3 dimension and the Attribute Members are in my UD6 dimension. For default Text values, it works great. However, if I want to make a time-dependent change, it does a YTD true-up on any values. For example, let's say I have a member "Member1" with the default value "Smith" and 1,000 per month. If I want the Text value to be "Jones" starting in M4, I make that change in the Text field for that period. When I view the data, the Smith row will have 1,000 for 3 months and then -3,000 in month 4 and the Jones row will have 4,000 in month 4 and 1,000 per month after that. Is there any way to prevent that YTD true up? I just want the amounts to stop for Smith and start for Jones without the true up?3KViews2likes6Commentsusage of Aggregated member from Consolidation dimension
At the moment the Aggregated member uses the IsConsolidated property to aggregate or not. Do I have any option if I wanted to aggregate a member but not consolidate it? With the introduction of the new member Aggregated, is there going to be a IsAggregated property created or will it always work with the IsConsolidated property? Thanks1.6KViews2likes1CommentData Copy from Application 1 to Application 2 (Different Environment hosted on Azure)
Hi Team, We would like to understand how to copy data from some specific tablesfrom appsuite(appsuite-prd.onestreamcloud.com) to appsuite_dev(appsuite-dev.onestreamcloud.com) for some specific tables.1.8KViews1like1CommentSearch for member usage in cube views
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 MatthieuSolved1.3KViews1like5CommentsCan a Data Mgmt Data Extract step be saved somewhere other than under that user's folder?
When running a Data Mgmt Data Extract step, you can chose where you want the file saved: However, the name you provide always starts under the File Share\Applications\[App Name]\DataManagement\Export\[User Name] folder. So, the above extract would show up as File Share\Applications\MyApp\DataManagement\Export\Phil\20211202\CubeData.csv We need these extracts to be available to users who do not have access to the individual user folders on the File Share (i.e. - they aren't Admins) Is there a way to have the Data Extract saved to a truly user defined location, like Application Database\Documents\Public\DataExtracts? How could this be done? If you run the extract from a business rule are there arguments you can pass into the data management call to override the export path? Or is there a way to programmatically move the file after it's been created? Thanks,2.5KViews1like1CommentCarryforward V#Annotation Inputs
Hello, Wondering if there was a way to carryforward V#Annotation inputs on BalanceRecurring Account Types (or any other Account Types) similar to how a V#Periodic input is carried forward on BalanceRecurring. For example, we have the users selecting a text string in a data cell and would like that data cell to be carried forward when saved. When we click save on this BalanceRecurring Account, the text string doesn't carry forward months because no value is being stored at V#Annotation. V#Annotation: However, we can change the parameter to have the value of a MemberID (Integer) which stores the value at V#Periodic and displays the String. At V#Periodic, this carries forward that string which is our end goal. V#Periodic: Due to the nature of the tables supporting these custom dropdowns, we would prefer to be at V#Annotation and carrying forward text strings that way. Has anyone encountered this or have solution to carryforward V#Annotation inputs?755Views1like1CommentEdit member properties in Bulk
I need to update the properties (Constraints/Texts) of 20.000 UD members based on transformation rules. The script runs in 10 seconds, but once I add the 'SaveMemberInfo' method it surpasses 2h ... I tried both 'MemberInfo' & 'WritableMemberNoCache' with no performance enhancement Dim ListofU1Stores As List(Of MemberInfo) = BRApi.Finance.Metadata.GetMembersUsingFilter(si, dimensionName, myStoreFilter, True) For Each oStore In ListofU1Stores 'MemberInfo ''Dim myStore As MemberInfo = BRApi.Finance.Metadata.GetMember(si, DimType.UD1.Id, oStore.Member.MemberId, True) ''Dim StoreUDVMInfo As UDVMProperties = myStore.GetUDProperties() 'WritableMember Dim objWritableMember As WritableMember = BRApi.Finance.Members.ReadWritableMemberNoCache(si, DimType.UD1.Id, oStore.Member.Name) Dim objVaryingMemberProperties As VaryingMemberProperties = BRApi.Finance.Members.ReadMemberPropertiesNoCache(si, DimType.UD1.Id, oStore.Member.Name) Dim StoreUDVMInfo As UDVMProperties = objVaryingMemberProperties.GetUDProperties() StoreUDVMInfo.Text1.SetStoredValue(ScenarioType.Unknown.Id, DimConstants.Unknown, text1ToAssign) StoreUDVMInfo.Text2.SetStoredValue(ScenarioType.Unknown.Id, DimConstants.Unknown, text2ToAssign) BRApi.Finance.MemberAdmin.SaveMemberInfo(si, True, objWritableMember, True, objVaryingMemberProperties, False, Nothing, TriStateBool.FalseValue) 'BRApi.Finance.MemberAdmin.SaveMemberInfo(si, myStore, True, True, False, TriStateBool.FalseValue) Next oStore Is there any faster way to modify properties in Bulk mode ? Within method 'SaveMemberInfo', when I switch the booleans SaveMember to False and SaveProperties to True, the code is fast but values aren't savedSolved1.8KViews1like5CommentsExporting List of Entity Orphans
Is there any way to export a list of orphaned entity members? We pull in hierarchy information from SAP and recently over 1000 entity members were blocked in SAP. This resulted in them going into orphan status in our OneStream instance when we updated our metadata. The issue is that some of these orphans had data and that is causing reconciliation issues. If I could export a list of the orphans, I could match them against all of the SAP entities that have data to determine which orphans needed to be restored. Thanks!Solved2.2KViews1like5CommentsPerformance Decisions - Dynamic Vs. Stored Calculations
💎 OneStream consultants and administrators must make the correct decisions during the design phase of YOUR project. Top on the list: Deciding which one (Dynamic or stored Calculations) to use is a fundamental consideration of a project. Dynamic Calculations are an in-memorycalculation that runs on demand (when necessary). Stored Calculations are calculations that run as part of the Data Unit Calculation Sequence (DUCS). All alternatives should be considered before storing calculated values in the application. Dynamic Calculations do not store a value in the cell. Instead, a numerical value calculates and displays when the Member is referenced. Stored Calculations result in data records and data cells being stored in a database table. For further details: OneStream Foundation Handbook and Implementing OneStream course. Exam QUESTION:What are the three ways to runCalculations? Cube View cells​ Workflow Process task​ Data Management Jobs635Views1like0Comments