Application Build

Hello good afternoon, I need to extract a specific hierarchy without extracting all the hierarchies we have in the account dimension, as you can see in the next screenshot, I just need TP9E in order to extract and import into a different app: But when clicking into the application load/extract (metadata) I see only options to extract the hole dimension: Is this possible? Many thanks in advance.  

Hi all, I currently have a dashboard that shows several cube views in it. I'm wondering, is it possible to extract through parameters the POV dimensions of the cell that the user selects, in order to use them for other processes? (my goal would be to allow the user to select a cell, click a button and visualize the drill down for that cell) Thank you in advance for any help!

I would like you to help me with this question, because I want to know how I can add a security group to a person (the section that appears in the image) and how I can remove that group in a BR.    

Having difficulty finding the source of this error. Has anyone come across this?  

Good day  I was wondering if there was a way to find out which child members of UD4 that has text 8 text in there without going through each member. Once we find that out then is there a way to see where the text 8 is being used in the application   Regards

Does anyone know if it is possible to format the XML files that are created by the application extract. In particular I want to format the Metadata extract so that there is a single line for the member definition. I want to run a compare process to check what differences there are between 2 files. I want the member name included in the difference line rather than (for example) the currency has changed without any indication of the member. So this <member name...><properties><property name...> instead of: <member name...> <properties> <property name...> Thanks

Re-posting. I hope this time it is in right community.------Hi All,We are a large OneStream shop with 700+ users.  The system is in use for last couple of years.Currently our system is hosted in our own Azure environment and managed by our own infra team.We are currently reviewing to see whether we should continue with the same or should we go for OneStream Cloud Managed Service?I would love to hear from fellow OneStreamers following:1) Are you currently using OneStream cloud or hosting it on your Azure / Data center?2) Ours is a very complicated system with multiple group regulatory reporting as well as some LBU planning & budgeting apps on the same environment.   While speaking with a colleague, he told me that from his past experience, the system performance wasn't as great on the Cloud compared to customer managed environment.  Is this the experience of all OneStream customers out there?3) How's the support experience with OneStream Managed support?4) Did yo

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) Di

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!

Update: Found out the user ID is actually supposed to be a Guid object and not a string.    I have a data table which contains a list of UserId's. Currently, I need to convert those UserId's into usernames. I have been attempting to use the variations of the '.GetUser' api. With this test, I have been unable to actually fill my variable with user info for analysis. Is there any known workarounds for this situation? I confirmed that .GetUser works with the username, just not with the UserID.  Below is an example of my scripting, the string is of the userID I obtained by testing on a username.   

Dear Community, Whenever we use the drill down in OneStream, there is a call called "Calculation Script" at the very end, which in my case is never populated. How is it used ? Are there any way to access it / populate this cell ? Regards,

When adding a new member to my dimension I received the following error message when I tried to save it.  "Error saving member.  "B4632' already exists.   I did a search on that dimension and hierarchy and got the result "no items were found".   How can I determine why it will not let me save this member?  How can I find it?

Hi there! I am trying to use Postman to run a DM job sequence. I test the DM job locally and it works fine with no parameter.I am using Azure SSO to log on the server.I can retrieve a token from microsoft for my tenant ID using : https://login.microsoftonline.com/bec456-my-t3n4nt-id-e2aba/oauth2/v2.0/token (In green in the printscreen) On my second RestApi call, I use the token I retrieved and I drop the token under Authorization > Bearer Token in Postman.Because I need to run a sequence the URL is : https://aiqos.io:50001/onestreamapi/api/DataManagement/ExecuteSequence?api-version=5.2.0 and the body is : { "BaseWebServerUrl": "https://aiqos.io:50001/onestreamweb", "ApplicationName": "GolfStreamV65", "SequenceName": "RestApi", "CustomSubstVarsAsCommaSeparatedPairs": "" } I also created an admin user in OneStream that matches the Application (client) ID found in Azure. (In red in the printscreen)The on the back end in the server config, I added the OS Werb Api Cli

Hi OS Community,  Was wondering if anyone has visibility into or can point me in the direction to update the Environment Color in an application?   I know it can be done, thinking it might be the Config Utility or SNOW request, just having trouble finding documentation on the process to update.  The guide says all you need is admin access:  But I'm finding that not to be the case in multiple environments Any help would be greatly appreciated!      

In the D&R document it is mentioned "Using Extensible Dimensionality to extend Accounts used within the Intercompany Matching process is not a recommended practice".  is there any particular reason for this? or is there any documentation showing this as an example?

The SQLTableEditor in question is used for user interactive CRUD pertaining to Rates used in a calculation.Use Case:I have a SQLTableEditor that holds rates.  When the table Save button is clicked, A BR saves the rates and runs a calculation.  The results of the calculation are displayed in an adjacent dashboard containing a DataGrid.  The DataGrid needs to be refreshed after the Save button is clicked.Question:How do I configure the SQLTableEditor to refresh the adjacent dashboard on clicking the Save Button, in a way similar to configuring the "Save Action" of other components?  

I would like additional information on the setting in Hybrid scenario for Use Input View for Adj in Calculations. This setting is currently set to True but some of adjustments booked in actuals are not flowing to the Hybrid scenario. However if this is set to False, the adjustments are reflected in Hybrid scenario.  

When i go to create time profile, i can see Months and weeks. Is there any documentation available how to create days?

Hi All, Does anyone have any good advice on what Workspaces should be created in the application dashboards screen beyond Default?  In reading the guide, workspaces seem to have a lot of focus on separating development activities or perhaps for partner place solutions(?).  I am struggling a bit to understand at what level to offer a different workspace.  We have been toying with the idea of having a separate workspace for Actuals and Planning but as 90% of our dashboards live in Planning, not 100% sure this is the best use of this split. Any practical advice on the kind of workspaces that people are setting up that adds value?  I want to make sure we are using them in their best manner. Thx, Mike

Is there a report or dashboard that will flag violations of Extensibility rules in dimensions?

When an app is copied to a different environment, first we extracted & loaded the security XML (users & groups). Then the app copy was made to this new environment using Cloud Admin tool. Even after this the artifact level security on the metadata, workflows, cube views etc. did not move. All the security groups in the artifacts showed "Not Found". What did we miss? Appreciate your response.

Hi there, From other security related questions posted in the community, I understand there are templates for creating user and user groups in OneStream. I would like to know is there a similar template to assign user into their relevant user groups as well? Any suggestions would be helpful. Thank you. JC

Cash Planning rolling forward, Capex tracking in OS: Anybody experience to share in this context?

Hello, We're building our Planning module and was wondering we have management fees that we get from our corporate office. They come in as USD. Is there a way that we can load in USD and translate them back in to Local Currency for the entities? This is a one time yearly load and didn't know if it was possible or if we have to calculate it to local currency and then load it? Thanks, Will

Looking for help to display Text data in a cube view.  I'm using the member filter below which works for every account type EXCEPT  DynamicCalc.   Account Type set under Settings in the Member Properties (see below).  U8#Acct_Text3:V#Annotation