Application Build

Hi everyone, Can someone explain how the UD Member property "Is attribute member" works? I would like to assign to my UD5 members some attributes and be able to create CubeView base on the attributes. As an example, my UD5 could be Customers and the attribute I would like to assign to each Customer is the type of Customer (Retail, non-retail etc).  I thought I would use the "Text 1" property of my Customer members to input the type of costumers. I would then create a separate UD5 dimension "CustomerAttributes" and list all the attributes. Finally, enable the "Is attribute memeber" property of my "CustomerAttributes" dimension members and do a comparison between the value in the Text 1 of my Customer members and the value in the "Comparison Text 1"  of my attribute members.

What is the best way to design and implement constant fx rate analysis?  We want to apply a budget rate to all months for actual/fc/budget.  Entities are loaded in local currency and I thought it would be simple to use an entity hierarchy in which I'd put the custom rates at the parent level so during consolidation it would use the set fx rates.  Unfortunately this is not working as I had hoped, I'm not seeing a difference at the parent level between the "real" hierarchy and the constant rate hierarchy. Thank you.

Happy "end of forced masking" everyone!    Why can't we log in as user administrator recently? We get message "invalid user or password" Maybe Our user administrator is locked out due to too many attempts to login with invalid password. How do I unlock ? (ps. I read OS Design and Reference guide about enabling users - I see that user Administrator is enabled. 

Hi  We have set up a line of business attribute in our UD3 dimension based on cost centres. It has become clear that in several reports we need to aggregate some of these members. I think the easiest way to do this would be if we could introduce a new layer between the current parent and children. My questions are a) is it possible to do this and if so how? and b) how would this impact reports that are already in circulation? I have tried to illustrate what I'd like to do in the picture below. Thanks

Hi all,   We've recently implemented RCM and I have one issue I'm trying to figure out. Certain accounting teams want to do reconciliations (for SOX controls) on certain accounts that have always had 0$ balances in the account month ends. I'm currently lost on how to get these into discovery - since it seems there has to be a balance at least one time for it to be populated there.   Is the a manual way to add a couple of all-time 0$ balance accounts that way there will be a reconciliation option for it?

Happy end of Ukraine war (hopefully)?? We have 9 Windows on-premise servers. 1) How do I know Which one is our OneStream app server, Data Management server etc? 2) I am running Parcel services which writes to OneStream's C:\OneStreamShare\Fileshare\Applications\Will that write to OneStream's application server or DM server?  Parcel services kicks off a Data management job that exports files/reports to that C:\OneStreamShare\Fileshare\Applications\ folder. Thanks for your help.

Where can I find attachments to posts (in community)? Happy Spring everyone!! How can I direct message to community Admin? Our community Admin gave an excellent hint on how to send email notification in link below: https://community.onestreamsoftware.com/t5/Office-Hours/With-respect-to-e-mail-notifications-in-Task-Manager-are-the-pre/ta-p/1453 He claimed to have attached  UTM_EmailLateTasksHelper Business Rule to his answer, but I don't see it.I would like to direct message him and request that he posts his business rule.Thanks.

Happy Spring!!Silverlight no longer downloadable nor supported by Microsoft. However, when it is needed to run OS in IE 11 web browser.  How do I run OS in IE 11 web browser without silverlight? I'm on OS 6.1.1.  I am using OS windows app, but like to run OS in IE 11 web browser simultaneously

We are exporting batches of reports using "Parcel service" - each report is exported to a folder with "2022_March" in its name. At the beginning of April (and every month) I had to go into each report's path and manually change the path to "2022_April" of each output filename-report to reflect the new month.  I think the solution is to extract (export ) the Parcel reports parameters to XML file, change the paths manually, then re-import the new XML file. However, I exported all Dashboards and application - I was not able to find Parcel report parameters.Any idea where to extract them?We Clicked on System> Environment under the Tools menu. - Click on an App Server within the Application Server Sets menu. -On the Configuration tab, there is an entry for FileShareRootFolder; but that's not where the path is defined. 

Hi,Is it possible to extract one dimension member instead of total dimension members from one environment and load the same into another environment? Regards,Madesh K

Hi,Is it Possible to extract any metadata (For Example Account) from one environment and upload the same into another environment? Thanks,Madesh K

We are looking for ways to reduce the data unit size in one of our cubes in order to increase reporting performance without having to do a redesign.  We currently have +20k UD1's and +10k accounts in this cube and 16 years of historical data.  Would updating the "In use" tag to false for inactive accounts and UD1's reduce the data unit size and help improve data pulls and reporting performance for current years?  We aren't able to completely remove these accounts/UD1's because we are going back 16 years for historical purposes.

Account dimension member "In Use" property (Vary by Scenario Type and Time) set to Scenario Type = "Control" and Time to "2022M2", Stored value "False" However when I try to grab the InUse value via a BR it always returns "True"   Dim varyByScenarioTypeId As Integer = ScenarioDimHelper.GetIdFromName(si, "ActCon") Dim varyByTimeId As Integer = TimeDimHelper.GetIdFromName("2022M2") Dim boolInUse As Boolean = BRApi.Finance.Account.InUse(si, memberId, varyByScenarioTypeId, varyByTimeId)   But works fine if I set the Scenario Type = "Actual" or "Budget". Doesn't work if Scenario Type = "Control" Any ideas?

Dear Community,   We're trying to change our hierarchy structure for the new year. That means creating new rollups (D22_xyz), and inserting members within those structure. It's the exact replica, but we're just copying the hierarchy from D21 and changing it to D22.  However, I'm curious if their a BR to compare between the old hierarchy v. the new one. It would help to compare and know if we have missed anything.  Any ideas or suggestions will be appreciated.  Thanks!    

Happy New year Y'all,  Is their a way to extract entity dimensions and load inside a dev environment? I don't want the entire application extracted. Any ideas will be appreciated.  Thank you!

Hi community 🙂We have created a new scenario (not actual or forecast) for manual KPI accounts ( no formula on them), e.g Market share. We would like to create a input form where the submitter should populate e.g. market share for the specific month, for the specific QTD and YTD. I asked a question earlier regarding the account setup for this and I got the answer that they should be Account type Balance.  From my understanding you need to say Periodic or YTD on the Scenario settings (default view, input view for adj etc). But what to put when it´s regarding these kind of accounts?  Also, regarding the input form. Now we have built YTD and monthly in the same form. For QTD in a separate form. But when populating an amount in monthly, the YTD is automatically updated with the same amount. Any suggestion on setup in the CV to not make them "talk" to each other? 

Hi. Question regarding accounts. We would like to create an input form templates for KPIs. An example is Market share. We don´t want it to be summarized (month+ month=YTD), is the best to put it as Balance on Account type then?

Hi community, We are doing some changes in the legal structure and we would like to move an entity from one EntityDim to another EntityDim. Best would be to copy the entity to the new structure  and put in a "to date" in the old structure and a "from date" in the new structure under "In use"-parameter I guess to keep the history. Does anyone know if that is possible? The entity will have the same ID.   Or do I have the rename the old entity and create a new with the same name in the new structure? Or any other ideas how to move an entity to a new mother?

Hi All!  Our computer have recently been updated with the latest Microsoft patch and my colleagues and I have noticed we have lost copy and paste functionality within OneStream. For example, when I copy a cell from a cube view the following error occurs:In addition to this, we have lost capabilities to copy and paste members within dimensions. Has anyone seen this type of error before? Thank you all!  

Hi experts, I would like to get some feedback on an issue that I am facing with the current build. I was unable to submit data for the Actual scenario via forms. I had tagged the scenario with the scenario type 'Actual'. After checking all the usual areas, I changed the scenario type to 'Administration' and assigned the same dimensions to 'Administration' scenario type (that I had selected with the 'Actual' scenario type) from the 'Cube Dimensions' screen. And, I was now able to submit data for the scenario via the same form! Could this be something related to a scenario type corruption and how do we go about fixing this? Regards, Sou