About Ivan_lo_servian

Ivan_lo_servian · ‎08-26-2020

This issue has been reported to Support team and they have confirmed it is a bug and will work on it. @Misbah Thank you for your help.

Ivan_lo_servian · ‎08-24-2020

I have retry it today on Chrome and Firefox web browser. It has been tested on two worksheets, one is build a week ago and one is brand new. The same issue happen in both web browser, so I think it is not the browser's issue. It is noticed the below behaviour: In edit mode, go in "Select View". I have swapped the dimension of the view and then click "Next" -> "Update". The Context Selectors do exist. Then, I click "Select View" and no change. Click "Next" -> "Update". The Context Selectors disappear. @Misbah Could you help to verify it? Thanks.

Ivan_lo_servian · ‎08-24-2020

When I start the edit mode in worksheet, I can see the selector setup on the top. However, once I use the "Select view", no matter change has been made or not. After I click "Next" follow with "Update" to come back to the main screen. The selector setup on the top disappear. I found it is very annoying that I need to firstly publish the worksheet, then go back to edit mode to change the selector setup and re-publish the worksheet again. Could anyone confirm whether it is a glitch or not? Thanks.

Ivan_lo_servian · ‎07-07-2020

Hi All, If the optimizer failed due to unbound issue, the below error will prompt. I don't think my issue is due to unbound. I have built a simple optimization model for checkng. It is verified that the min/max setting can be empty and the optimised value of variable can be negative. The issue that happen on my optimization exercise model should be some other reasons. I will continue my investigation. Thank you for all your reply.

Ivan_lo_servian · ‎07-06-2020

Hi @ArunManickam , It is interesting to find out it works if I remove either one of the min setting (as below). It seems the optimizer still need some sort of boundary to work. Thanks.

Ivan_lo_servian · ‎07-06-2020

Hi @ArunManickam , Here are the details: 1. It is a minimization problem. To minimize "Total SKU Cost". 2. & 3. the expression of constraints and objective function are as below. (a full set of blue print are attached) Thanks.

Ivan_lo_servian · ‎07-06-2020

Hi @Ingilavicus , This issue happens while I am doing the optimization exercise which I believe is built by Anaplan. I have followed the instruction to build the formulas. Are there any optimizer configuration that only tenant admin or Anaplan can do? Thanks.

Ivan_lo_servian · ‎07-04-2020

Hi, From the optimizer user guide v01, for variable section, it states the min/max configuration are optional (as below and see the attached full document). So the optimizer has been configured without min/max. However, it flows an error when execute. Then, I configured the Min as zero and it executes successfully. If the variable can be negative value, how should I configure it to get it run? Could anyone help to confirm the min/max configuration is optional or not? If we don't know the range of the variables, any default setting we can use? Thanks.

Ivan_lo_servian · ‎05-28-2020

Thanks @naushad786

Ivan_lo_servian · ‎05-28-2020

Hi, Is the "Configure Worksheet Actions" feature, which can be used to define forms and export / process actions, only available when the worksheet page is created in Apps and not available if the weeksheet page is created under My Pages? Is there any way to enable "Configure Worksheet Actions" in My Pages? Thanks

Ivan_lo_servian · ‎03-01-2020

@JaredDolich Thanks for confirming the functions required such setting to be turned on. I have done a work around to create QTD and HTD index in Time Attribute module. Then, in my calculation module, use TIMESUM() to populate the QTD and HTD value. In this case, I don't need to turn on the Quarter Totals and Half Year Totals which the client doesn't need to see.

Ivan_lo_servian · ‎03-01-2020

Hi, I would like to calculate the QTD and HTD in a module. It is noticed that the QUARTERTODATE() and HALFYEARTODATE() function are not working when the Quarter Totals and Half Year Totals been disabled in the time setting. An error message is prompted when the formula is saved. After the Quarter Totals and Half Year Totals are enabled, the formula using these functions are saved without issue. I think the function should work regardless of the time setting. However, it looks like the time setting is the pre-requisite for the functions and it didn't mention in the Anapedia. Could anyone confirm it? Thanks.

About Ivan_lo_servian

Re: New UX - Worksheet Main Grid Edit Mode Issue

Re: New UX - Worksheet Main Grid Edit Mode Issue

New UX - Worksheet Main Grid Edit Mode Issue

Re: Optimizer - Variables min, max setup

Re: Optimizer - Variables min, max setup

Re: Optimizer - Variables min, max setup

Re: Optimizer - Variables min, max setup

Optimizer - Variables min, max setup

Re: NUX: Configure Worksheet Actions Not Available...

NUX: Configure Worksheet Actions Not Available on ...

Re: Pre-requisite for QUARTERTODATE() and HALFYEAR...

Pre-requisite for QUARTERTODATE() and HALFYEARTODA...

Re: New UX - Worksheet Main Grid Edit Mode Issue

Re: Pre-requisite for QUARTERTODATE() and HALFYEAR...

Re: Pre-requisite for QUARTERTODATE() and HALFYEAR...

Pre-requisite for QUARTERTODATE() and HALFYEARTODA...

Re: Pre-requisite for QUARTERTODATE() and HALFYEAR...

Pre-requisite for QUARTERTODATE() and HALFYEARTODA...

Re: Pre-requisite for QUARTERTODATE() and HALFYEAR...

Pre-requisite for QUARTERTODATE() and HALFYEARTODA...