Application Build

We are on V8.2.2 Cloud and we need to change the Zip File Protection settings. ManageSystemConfiguration is enabled so we can change the settings. The Installation and Configuration guide mentions Zip File Protection settings after Task Activity. Task Activity is there but no Zip File Protection section: Anyone know where they are or do I have raise a ticket with support? Thanks    

Hi All, We are implementing some updates to the security model in our application, and we are coming across some unfamiliar territory, so we're looking for some input. We are using OneStream version 7.2.4. We are trying to prevent the user from seeing data for certain Flow members based on information in the Text1 value of the Flow member. Because we don't want the user to be able to see the data for certain Flow members, we decided to use Data Access Security on the cube, with the idea being that if the user tried to access data they weren't supposed to see, it would return "No Access" in the cell. However, the Text1 values for the Flow members vary based on the scenario and time, so we aren't able to use a simple member expansion formula in the Data Access Member Filter, like F#ParentMember.Base.Where(Text1 Contains 'Valid'). We couldn't get XFBRs to work either, leading us to use a Member List BR. We determined that we can get the Data Access security to call the Member List BR... b

Hi, we see some of our automated tasks cancelled by the system (e.g. task status = Cancelled by System in task activity) every now and again, and don't really understand why this occurs. Can someone shed some light on why this happens and how to prevent it?Thanks!Alex

Hello OneStream Expert: We are going to to convert one Hyperion Planning application to OneStream Application. In Hyperion application we have SmartList type of Datatype, for example we have an Account Member call  Display_Flag 1, Yes 2. No In web form, it will display Yes or No and data will be saved to Essbase as 1 or 2. But I cannot find the SmartList type of Datatype in OneStream for me to display Yes or No in the Cubeview. I wonder what kind of solution can be applied. Thank you in advance.

Good Day All: What table would contain the intercompany rule profile.  I see source value and target value in the grid.  But I want to see all mapping. On target value, I just see entity name, how do I confirm accounts (A#)? Thanks, Steve P.

I'm trying to better understand the best process for moving large Dev dimension changes from to Prod.  I've extracted my Dev and Prod Metadata and have it in the Dimension Comparision utility.  Now I know my differences which I have changes in Prod that aren't in my Dev and of course vice-versa.   I'm looking for feedback, do you edit the xml file or make some changes in Dimension portion of Onestream and re-extract.  The best practices process is what is stumping me or is the answer "it depends"

How can I edit my GLOBAL POV?  

We are implementing a consolidation solution where customer will need the ability to analyze data by each Project. Currently they have 12000 projects, and the list grows every year/month. Some Projects may deprecate however we need to retain them to maintain history. Is it advisable to setup 12000 Project members in the cube considering the potential to grow every month? Appreciate any advice to solve this requirement.    

Hi,  We are thinking of implementing People Planning module. As this has been floated as plug-n-play solution, we want to see if we can build it ourselves or build majority of it. What is the best way to know more about it? I see some documentation but is it good idea to download the People Planning module and look at the design of that? We have GolfStream demo but not sure if it has latest version of People planning. Any info on this is appreciated.   Thank you, PM

Hello, When we configure a linked CV from a source CV and that we input and save something in this linked CV, by default when we close this pop up window, updated or added data does not show in original CV. We need to manually refresh the source CV to see update of input done in linked CV. Does anyone know of a way to automate the refresh of the source CV upon closing the linked CV's pop up window? Thanks for your help!

Seems I have found a bug, not sure if this is the right place to get it solved. We have a calculation where we use text3 on the customer, which is the country code to find the freight rate on the country customer with that name. In the latest forecast the calculated numbers were lower than expected. While checking there is no value calculated for customers with text IN, Indian customers. The Cubeview I created now to check gives below message: Text in the Cubeview is: U3#39939, U3#30612, U3#Customer.base.Where(Text3 = 'IN'), I tried also Text3 startswith IN and Text3 = IN, all give the same message. When I change to IT (for Italy), there is no error. Somehow IN is invalid for this purpose it seems. Any idea how to solve, I can give it a different text, but would not be consistent.   Thanks in advance Ben

hello team, new in OS , i need help if someone works on this tool.i am wondering if there is an equivalence of the hfm functionality "org by period" in OS ?is it possible in OS to manage the structure on a “Time sensitive” basis, and to have effective dates for changes ? i am aware that it's possible to do the changes of % of ownership or even change of type of ownership (full Conso, equity...) by period but am wondering if it will be possible if a change of the parent of the entity and having two hierarchies existing on the same cube/app thank you in advance

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

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