Application Build

Originally posted by Chul Smith 8/3/2017 Has anyone implemented a security model where they grant access to all admin tasks except security? I told told this customer to just assign the users to Administrators and then have a report each month that shows that they're not adding users, etc.

Originally posted by Michael Malandra 8/15/2017 Member list driven by security - we need to build review CVs based on entities users are responsible for, i.e. John Doe is responsible for 3 entities that do not have a common parent. He needs a report with his entities by total revenue without selecting the entities. Does anyone have the BR to do this?

Originally posted by Chul Smith 8/15/2018 What's best practice for slice security - Start wide open and gradually restrict or start restricted and gradually open?

Originally posted by Chul Smith 3/28/2019 Specifically, who can unpost - I'm guessing that if you have Post security, you can unpost. We just don't know if you have Approve or Create Journal, can you unpost? Basically, they want to disable the Unpost functionality.

Originally posted by Rob Dessureault 7/31/2019 We have a process whereby when a workflow is certified, a data management job kicks off and copies specific Actual accounts into the Flash scenario.However, with the Manage Data Group set to Administrators, the users are encountering this error message.  . If I change it to Everyone, all works well

Originally posted by Kyle Nelson 9/5/2019 I have a business rule question regarding interaction with security groups. So the background is, we have hundreds of security groups that we thought we would need. We found another solution and want to clean up the security groups by deleting all of these extra groups. Has anyone ever used BRApi.Security functions before to pull a long list of identifiable groups and delete them? Or have you tried something else that achieves the same result?

Originally posted by Cosimo Palmisano 9/27/2019 In OS, we're seeing "label5" under the User Member column when running the Security User By Group Report / System Dashboard. Anyone know what this means?

Originally posted by Geoffroy des Dorides 3/10/2020 Hi, I have this weird situation where a user can input on an entry "form" but not launch a calculate or a force calculate. I guess the form is properly implemented as the administrator can launch a calculate or a force calculate from the same form. Which security role would prevent a user to calculate? (the user is able to input so I guess is has the proper access right on Entity and Scenario).

Originally posted by Karen Blackmon 4/1/2020 Do we share the Utility that allows us to clean security information from an extracted database with partners? I'm working with a partner and need for them to take a copy of client system and install on partner's system. Also, if we do share this kind of thing, how do we share it? We are prevented from emailing the exe, and they are prevented from receiving an exe. Is there a shared drive that we can leverage with partner collaborations? Thanks!!

Originally posted by Craig Rowe 9/23/2019 Hi All, I am working with Relational Blending and pulling data from Stage into a dashboard. I am trying to format the value of my data into currency. When I use the query in SQL Server, I can see the correct format, with commas. When I put the same query into my business rule, see the format change the number of decimal places but I don't see the commas. Does anyone have any idea how to show commas in my dashboard grid view?

Originally posted by Chul Smith10/31/2018 Can you load two cubes (extended or not) from one central import? Gotta define data source by cube so that's why I'm asking…

Originally posted by Matt Ha 11/12/2019 So I know it's possible to write a BR to override FX rates like this: Does anyone know if it's possible to do this in a specific scenario member formula?

Originally posted by Rob Dessureault5/15/2019 In a confirmation rule, I need to get the Account dimension that is attached to the cube based on the WF that is in the POV

Originally posted by Laura Garcia 7/18/2018 Security question: is there a way to prevent someone from creating a new user account, but still allow them to provision a user to a group?

Originally posted by Rob Dessureault 2/8/2019 What is the best way to stop a Flow member from translating? I have this and it works, but is there a better way?

Originally posted by Jon Golembiewski 4/9/2019 For those that have used the Flow Processing rules for multi currency input... if you have calculated data that you write to the currency flow members, does the calculation sequence still pick it up to reverse translate it back to the entity currency? My thinking is that any member formulas or business rules would run after the flow processing rules and thus wouldn't get picked up. Basically, in the sequence below, anything running after step 3 would not get translated to the entity currency. I could not be lazy and test it but just wanted to see if anyone had run into this before.

Originally posted by Andrea Tout 9/23/2019 Has anyone ever extended on the scenario? We have on division that has it's own cube, and they have a lot of versioning and no one wants to deal with it in the other cubes. Display security doesn't exist for the scenario dimension. 

Originally posted by Andrea Tout 8/22/2019 Hey! When people typically handle entity security, do you nest the parents security group in its children security group? So when you have access to a higher level parent, you just add them to that parents group, instead of adding the user to like 100 groups. I have always wondered what is better! I feel like it depends on the size of the client

Originally posted by Pascal De Schryver 7/23/2018 I would like to prevent input for certain users on a specific UD4. Can I use Data Cell Access Security for this or am I supposed to avoid this?

Originally posted by Rich House 5/13/2020 Is it possible to grant the ManageTransformationRules and TransformationRulesPage security roles to a non admin user, then by using security groups on the Transformation Rules Profiles only grant them access to specific areas?I tried on a fake user and failed. The user was able to amend other profiles. Is this observation right?

Originally posted by Rich House 6/4/2019 I am trying to translate my F#OpeningBalance at an opening rate. It is naturally translating at average rate. I have managed to get to translate at closing rate but I'm now trying to figure out how to change it to looking at my opening fx rate

Originally posted by George Waddell3/2/2020 Can someone give me some info...guidance on data-transfers between cubes? I started off extracting the data via DM from a Sales cube. I need to import that data over to a Finance cube...how do I import the Sales Cube data file (in file Share DM folder) into the Finance Cube? Then I noticed this DM Export Sequence..

Originally posted by Henning Windhagen 1/14/2020 Hi All, I can't apply no input rules using a Cube's Data Access setting. I need to clock data load and input for certain account-flow combinations (in addition to using the account constraints). This needs to include admin users. I used Data Cell Access Security and Data Cell Conditional Input. I enabled Use Cube Data Access Security on an entity for testing. I checked Golfstream as well. I do have a PPT describing what to do which I followed... But I still have input access to my test cell. I do not have a working application with such no input settings that I can use as a template. I am sure I am missing a setting that is very obvious, but I just cannot figure it out... Can anyone here share a few screenshots from a working application that I can use to replicate that in my own app to see if I can get this to work. please?

Originally posted by Patrick Kiernan 8/22/2019 I'm trying to use the SecurityRemover.xml but am getting "Must select file with .xml or .zip extension" Any thoughts? I have tried both the zip and .xml file extensions to no avail.

Originally posted by Kathie Strell 10/12/2017 WF setup question: we have 2 sign off groups1 - base entity, month for the base entity, region parent2 - after group 1 has signed off corporate needs to sign off2a - reviewer 1 signs off on a group of entities2b - reviewer 2 signs off on the consolidated total2c - reviewer 3 signs off on the consolidated totalI'm good with the setup for group 1, but how do we setup the 2nd set of reviewers? Do we setup a corporate review WF? And then how do we get the levels of sign off? Group 2 only needs to certify, they don't need to run any confirmation rules or verify forms or reports. The challenge is that corp rev 1 has several people who sign off on different entities, but they don't match the regions that are set up