Application Build

Hi All, I have a bit of an extreme question here.  Is there any limit, whether system or logically, that there are too many cubes in an application?  My example (which I have simplified here for illustrative purposes) relates to UD1 for Cost Centers where we have 150 entities all having unique and different cost centers.  Since they each have 20 unique Cost Centers, that's potentially 3,000 Cost Centers in one dimension which feels big and very sparse.  Thinking through options for how to approach, one option we are weighing is to add a separate cube for each entity and assign a separate UD1 dimension to each cube / entity so they would only have 20 Cost Centers to contend with.  As it rolls up the entity structure, it would consolidate to a Summary cube that has one member called 'Total Cost Center' thereby shrinking the data unit in the top cube. Has anyone dealt with these high numbers of cubes before?  My gut tells me be that this could be troublesome

Is there a way to configure the system so that it will check if a consolidation is already running before allowing another user to start a consolidation?  If so, how do we configure the system to do this?

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.  

We load the GL data with YTD View. Data was loaded for 2024M2. There is no data loaded for 2024M3. For some reason after the consolidation/Force consolidation is run for 2024M3, the M3 P&L accounts are appears to reverse the M1 and M2. I do not expect to see any numbers for M3 and we haven't loaded any data for M3. It appears, I am missing something.  

Hi all,  I try to paste new records to SQL Table Editor from Excel spreadsheet. It allows me to paste the data, it seems right, but it does not allow me to save it. It behaves like there is no data at all. What am I doing wrong? Thank you!

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?  

Is there a way to get the prior workflow period's amount ('Am' field in sourcestageData table)?My use case is subtracting the current period's amount from the prior period's amount to derive the periodic value so I can apply Fx translation to just the periodic value instead of YTD value within a Derivative Transformation Rule.I can easily get the current period's amount with this syntax:  Dim amountValueCurr As Decimal = args.GetNumericValueUsingColName("Am") I can also get the current and prior Workflow Time Key's, but unsure how to leverage the prior Wtk to get those amounts from the prior period.

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

Users have been receiving the following error when trying to access various dashboards:"'GridItemThemeKeyExtension_DefaultBackgroundColor_OneStreamBlue' resource not found."The error has occurred for multiple users on multiple dashboards, within Production and Sandbox. We have found that the error does not reappear if the user logs out of OneStream and completely closes the application before logging back in and attempting to access the dashboard again.Has anyone else seen this error before and been able to determine the root cause?

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

Hi, After the reporting units have reported and certified their workflows. We need to post a group journal that affects almost all reporting units (this cannot be done earlier in the process). How is this possible without having to un-certify all companies and unlock descendants etc. There must be a simple way to post a group journal without touching the certified status of a reporting unit.  Please advice. Thanks!

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!

💎 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-memory calculation 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 run Calculations?  Cube View cells​ Workflow Process task​ Data Management Jobs

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!      

Hey all - does anyone know the best practice to securitize the drill back functionality based on Entity (or other group) access?  My use case is that we have users who can see entire company financials (actuals and planning) but should not be able to drill back to the People Planning registers unless they meet a certain criteria (in a specific security group and have a specific entity group access).  Thanks for any assistance!

Hi there, I have a dimension with 10 000 members under a TOP member.I can delete all of the relationships below TOP running :  BRApi.Finance.MemberAdmin.RemoveRelationshipsHowever, it is extremely slow as it does it one by one, so it takes hours.The same thing with the XML load is a load faster.  <relationship parent="TOPTOP" child="XXXX" action="Delete" /> Any BR to upload the XML or other clever ideas? Thanks One Team ! 

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?