Application Build

Hi - I'm trying to create a new application, but encountered the following error message... Unable to save 'Application Reference'. Invalid parameter.  User Interface Stack Trace: Server stack trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)at System.ServiceModel.Channels.ServiceChannel.EndCall(String action, Object[] outs, IAsyncResult result)at System.ServiceModel.Channels.ServiceChannelProxy.InvokeEndService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)at OneStream.Client.SharedUI.ApplicationAdminServiceReference.ApplicationAdminService.EndInsertOrUpdateApplicationReference(IAsyncResult result)at One

Originally posted by Kavosh Soltani Hi, Is there a document that describes the upgrade process for clients hosted in the OneStream cloud? What level of client testing is recommended and how is the testing and potential failover is handled, in case unexpected issues are encountered? Thank you    

We have two 8.2 environments with PLP SV 101. In one environment, all of the parameters for the register field lists display as expected. In the other, the same fields are blank. However, we know there is indeed a value there as the plan calculates correctly and we can see the resulting entities in the export to the cube. For troubleshooting purposes, we’ve been using the entity field (aliased as Department in our solution.) The Register Field List setup is entirely conventional: The parameter is configured the same in both environments: The function in the business rule that it’s calling is the same in both environments. I’ve tested the resulting SQL in SSMS and it returns valid values. I temporarily added some logging to make sure the method was actually hiring and returning a data table as expected; it is. The fact that it does populate the entities when calculating the plan data suggests all of this is fine and it’s just a display bug but nothing I can find seems to allow it to d

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 Matthieu

Hi everyone. I would like to see in which section I should put the name of the UD5 in an entity, since I see that it has a section for that but in the text part I see that other configurations also, so I would like to know where to put it so that they are connected, as well as about the UD5, about where the entity should go so that it is also connected. I do this because I want to try to make a connection equal to that of the IC with the entity Entity UD5  

Hello, I'm looking for a member formula, or business rule to copy data from an entity to the IC entity, where also another UD member is substituted. Example of source data: Cb#100:E#3100:P#?:C#EUR:S#May_C2:T#2024M5:V#Periodic:A#ICfreightPrice:F#Calc:O#Import:I#3342:U1#110F:U2#3100:U3#3344:U4#4002177:U5#None:U6#None:U7#None:U8#USD Destination: Cb#100:E#3342:C#Local:S#May_C2:T#2024M5:V#Periodic:A#ICfreightPrice_Pur:F#Calc:O#Import:I#3100:U1#None:U2#3344:U3#None:U4#4002177:U5#None:U6#None:U7#None:U8#USD So entity becomes IC, U3 becomes U2. To substitute 1 I can use a For each loop, but how can I add a nested For each? thanks a lot for some guidance. Ben

Hi All, I would like to create the Dashboard for the Adim which should display all the Current login users Details in the applications. Kindly help to achieve this development.   Thanks

Hello,  Let's assume we have an extensibility on the dimensions account with 2 cubes. When we need to export the dimension account, we are only able to export the accounts for the 1st cube, and the accounts for the 2nd one (two files). Is it possible to export the full account hierarchy (within a single file), with a field specifying the associated cube ? Thanks for your support, Harry

Hello, Got a question. We are trying to configure Smart Integration Connector. With respect to that can you please send us the list of IP address to whitelist for the Azure Relay of Onestream Thanks in Advance    

We are using the administrator solution tool Home Page Manager to set home pages for certain groups and it works fine when initially adding a user. When a user changes roles from one group to another, we are seeing that their home page is not updating. Shouldn't this update that users home page with the new home page of their new group?  

Hello Experts,  We have a requirement to derive account based on Data value. (If data value is Positive Asset Account , if negative Liability account)This has to be done for range of accounts. I am not sure if there a any functions to refer data value for row? (GetSource and GetTarget seem to be only for dimension data)Any ideas on how we can achieve this? Thanks In Advance,

Hello Expert, Is it possible to make employee register fields mandatory? we want users to select certain required fields before committing save.  Let me know, thank you

Is it possible to update a users security group with a business rule? If I have them in Group A but want to add them to Group B without going to the system tab and updating their security manually can I update their groupings with a Business Rule? 

Hello Experts,I'm trying to automate an export of account hierarchy which is then used to replicate same hierarchy in another app/tool. However, when I export Metadata in XML (tried both via Business Rule or via Application>Load/Extract) , it doesn't capture information on order of arrangement among siblings.So, while loading XML extract to new app, by default all siblings are arranged in ascending order of their member names.Is there a way to capture this information when doing export? Thanks,Gaurav

Does anyone have information on how to get Data Cell Access (Slice) Security (henceforth DACS) to work when applying it to multiple UD dimensions?  The app has the entity and scenario security set.  Those are working fine.  If I put only one UD in the DACS, that also works fine.  The problem comes in when subsequent UD dimensions are added to the DACS.  It seems OneStream ignores the DACS and goes back to entity and scenario security. To add a bit more information, I have tried it multiple ways, with the multiple UDs in the same or different rows in the DACS setup.  It doesn't matter. Thank you.

Hello, We have a client who has requested the ability to use the alternate translation currency property on specific parent entities but then also to be able to pull that alternate currency in reports without changing the currency in the POV. For instance, the parent entity's currency is USD and it will be setup with EUR as an alternate translation currency in the equity pickup property section. The children of that parent entity are all EUR currency entities. In their reporting they would like to be able to show parent entity and children at the EUR without changing the Cons POV. The reporting could have multiple instances of this setup with different entities and currencies so setting the Cons to EUR wouldn't be an optimal solution. Ideally, they would like to set the consolidation to local for the whole report. We have alternate hierarchies setup but they would like to only worry about one member name for the parent and one hierarchy. Does anyone have any suggestions on how to achie

 

Now I have it in two places on the tree.  It includes children with data.  I need to delete the one I just created, including all of the children, but I'm getting an error that says it can't be deleted with data. How can I go about fixing this?  

  Given a situation, determine the correct properties for the Cube. Certification Exam.  Workflow The most common setting Is Top Level Cube for Workflow (Main Cube) = True Project requirements dictate Suffixes for varying Workflow by Scenario Type Assigning Suffix by Scenario Type allows the same Entity to be assigned to different Workflows in different Workflow Cube Root by Scenario Type The best practice is to configure a suffix early on for common Scenario Types regardless of whether they get used. NOTE: These settings cannot be updated once data is loaded to a specific Scenario Type.  Leaving blank is defining the suffix as well. Calculation Consolidation and Translation Algorithm Type Most common setting = Standard Settings based on design decisions on how consolidation and translation to be customized. Recommendation – Only change from Standard to Custom on sporadic cases. Elimination and Translation logic should be done either on the Member using O#Elimination

Hi, since I am used to set many of the programs I use during my working day to dark mode, I was wondering if it is possible to turn the dark mode on for OneStream, and if that's not possible, is it something OneStream plans to introduce in future? Thank you

I am wondering if anyone has changed the precision of the FxRate?  It shouldn't be to hard.  What I am wondering is if changing it would cause other issues ?  

Hi Community, We are trying to set up Rest API call to execute Data Management (OneStream v8.1) call from external system (e.g. Postman) I followed the document for REST_API_Implementation_Guide.pdf and I am not able to configure the Bearer Token (we are using Okta as Single Sign-on).    This is not working,  I am wondering if something need to be done on the Okta beside the steps in the document;  

With v7.4, it's now possible to create separate Maintenance Units, to isolate a "solution". But with that also the new "Dashboard Type" have arrived, including "Custom Control", but also a new Navigation Action on a button, called: "Forward Custom Control Action to Parent Event Listener" Anyone have experience in how this works, or where I can find more documentation or examples of the functionality

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?