About andre.lie

Hi All,   I have a model with Week General time settings.  Module 1 uses Day timescale and Module 2 has Date formatted line item.  How can I lookup line item in Module 1 using Date formatted line item in Module 2?   The Day timescale in Module 2 appears as 10 Apr 2019 while Date line item in Module 2 appears as 4/10/2019.  I think I need to convert 4/10/2019 to the format of Day timescale.  However, I do not find that I can format a line item as Day timescale.   Thanks, Andre     ... View more

Hi,   I have role A and B in the model.  Both roles have Write access to module 1, which has line item 1-5.  However, for line item 5, role A should have read access, while role B write access.  How can I assign roles to line litems access?   Thanks Andre   ... View more

Hi,   I have module '1' with a line item which is list 'A' formatted published to a dashboard.  I also have list 'A' published as page selector, as it will drive module '2'.  How can I synchronize my line item in module '1' with the page selector i.e. if list item 1 is selected on page selector, line item value in module '1' is defaulted to list item 1 as well   Thanks Andre  ... View more

Hi Everyone,   I have a view that I want to export into a file via action.  The view has 2 lists as column and 3 line items across. The module itself has 7 line items.  However, the export always output all 7 line items.  Is there a way to limit the export to the selected line items only?   Regards, Andre     ... View more

Hi,   I understand we can use Anaplan Connect to download file that has been uploaded.  Can we also do this via Action that is published to a dashboard?  I do not find Action that can download a file.   Regards, Andre ... View more

Hi,   I have a module with a numbered list.   Among the module line items are Submit and Approve boolean, which I use for some kind of worlflow.  When I use Copy Branch action to copy a particular numbered list, both booleans are also copied.  On the other hand, I just want to copy other line items but the Submit and Approve boolean.   Is there any workaround to use Copy Branch action just for selected line items?   Regards, Andre    ... View more

Hi All,   I am trying to use Anaplan Connect to import data from MS Access table to Anaplan list.  The table has only one column containing list values.  I have created Anaplan import action based on text file with similar structure i.e. one column file.   I create jdbc.properties file as below jdbc.connect.url= "Jdbc:Odbc:Driver={Microsoft Access Driver(*.mdb); DBQ=C:\Data\Anaplan\301 Anaplan Connect\Database1.mdb};" jdbc.username= jdbc.password= jdbc.fetch.size=10 jdbc.isStoredProcedure=false jdbc.query=” SELECT * FROM Table1”   Database1.mdb and Table1 are my access database and table name   I use this Operation in Anaplan bat file, where I put the name of the import action after -file, and location of the jdbc.properties after -jdbcproperties. set Operation= -file "Prospects from Prospects.txt" -jdbcproperties "C:\Data\Anaplan\301 Anaplan Connect\anaplan-connect-1-3-3-5\jdbc.properties" I downloaded MS Access JDBC driver for MS Access and copy the jar file and other extracted folder to Anaplan Connect folder.  However, when I run the bat file, it gives message that it cannot find lib directory   Do I miss anything or set incorrect parameter in the .bat and jdbc.properties configuration?   Regards, Andre ... View more

Hi All,   What is the budget rejection mechanism in Anaplan? Is there a way to reject budget submitted by cost center user, reviewed by manager and rejected, which then notifies user via email for instance   Regards, Andre ... View more