About Ernie_Goff

Hi Ernie, this is something (or something similar) that our company has been crying out for for a while! We supposedly have segregation of duties, but our 'Access Admin' person in theory has the ability to do anything to a model in Production. Also, with an increasing number of Model Builder/Workspace Admin users in our company, there is the risk that they can change individual settings (or their own) such as turing off their SSO functionality or changing their role to see data which they shouldn't have access to. If the 'User Admin' role was separated out to a different person, then this risk would be stopped, rather than relying on us to set up processes internally to manually review user access changes etc.   Thanks, Andrew. ... View more

I may be taking this idea in a different direction than @Ernie_Goff originally intended, in which case I can raise a separate feature request.  Customer Scandinavian Airlines (SAS) has requested a second option for multi factor authentication than just Single Sign On.   The business case is that the customer would like a limited number of users from a supplier (so, external to SAS) to be able to log in, but with a multi-factor authentication protocol.  As that supplier's users are not internal SAS they are not in SAS's Active Directory and thus the SSO approach will not work.  They wish that the Anaplan Platform allowed for another approach (like, sending an SMS to the person logging in, with authentication code, to verify the user, in addition to the user name and password).  ... View more

Hi Ernie,   Thanks for the response.    My initial intention was to test Anaplan Connect with database.  So, I used Access as I thought it was the easier one to test on my local.  As there was problem with Access, I decided to test it using MySQL.  The connection worked as I expected but I included the JDBC connection information in the Anaplan batch file instead of using a separate JDBC properties file.  It still did not work with separate properties file though.   Here is the working set Operation in my batch file.   set Operation=-file "Anaplan_Demo_Sql" -jdbcurl "jdbc:mysql://localhost:3306" -jdbcuser "username:password" -jdbcquery "select distinct name from world.city where name <> 'San Miguel'" -import "SQL from Anaplan_Demo_Sql" -execute -output  "C:\Data\Anaplan\301 Anaplan Connect\anaplan-connect-1-3-3-5\error.txt"   Regards Andre ... View more

Hello -   License management is currently conducted as a dialog between the Anaplan account team and a customer. Every Anaplan customer has an assigned Customer Success Business Partner who has access to user activity on their customer's workspaces.   Ideally, the activity is monitored and shared with the customer on a quarterly to monthly basis. Anaplan does not have 100% self-serve reporting on user activity for customers at this time. You may want to connect with your business team to see if they can share this data with you as they receive it.   Best,   Ernie ... View more

Cathy -   I'm just following-up on this topic... Did you receive the information from Anaplan Support that you needed?   Functionally speaking Paul is correct. At present, we typically configure Anaplan Modules, Actions, and Processes to inherit changes from a customer's identity management systems. There is a design example on the App Hub.   Please do head over to the Idea Exchange on Community and let us know if this is a feature/capability that would be useful to you.   Ernie ... View more

 Hi -   Much of the technical discussion and collateral around Hyperblock is provided by the Anaplan technical PreSales team. Your fastest path to any public-facing assets on Hyperblock would be through the Sales team associated with a shared customer.   Do you know the Account Executive assigned to the customer?   Best, Ernie ... View more

Hello Product Team -   It would be very useful in large enterprises that have moved away from email address as a unique indentifier to be able to capture the assigned login code and to have the email address stored as metadata.   At present, our capabilities in this area result in excessive testing when SSO is deployed to ensure that the appropriate external email address has been in stored on Anaplan. In many cases, users provide incorrect email addresses prior to SSO deployment which results in confusion and re-work during SSO testing. It would be much more effective to be able to use the same authentication criteria as the customer from the onset.   Thanks!   Ernie ... View more

Hi -  I just wanted to post a quick follow-up to this issue. There is a complicating factor in my use case which underscores the need for a modified approach. The use case I'm working on considers NPV of 100 years of cash flows. This makes adapting the current 'Time' dependent NPV formula impractical due to the length of the time considered in the use case.   A workaround was put in place where the individual period NPV values were calculated in a stand-alone module for all 1200 'months' and then aggregated into the results module via formula.   (Note: the periodic discount rate was calculated using the POWER(1+ annual rate,1/12)-1 formula in order to match Excel's NPV formula) ... View more