About yqian

yqian · ‎03-14-2019

Thank you Sayontan for your advice, really appreciate it.

yqian · ‎03-14-2019

Hi Jesse, Thanks a lot for your suggestions. I do like the option 1 which will be pretty useful for us. Yiping

yqian · ‎07-23-2018

Hi Everyone, Anyone knows why each time when I open the Excel, my Anaplan Excel Add-in check box is lost? I have to manually add it back in, by clicking the below check box "Anaplan Excel Add-in"? How can I make it there always available by default? It worked for me in the past, but did not work now since I upgrade to Windows 10. Thank you, Yiping

yqian · ‎03-22-2018

The temp solution we received from Anaplan Support is: 1) edit Dashboard 2) set all "Initial Page" to "Default" 3) exit "Edit" and go back into "Edit" mode 4) Re-set to the initial page that we want to see Thanks everyone! Yiping

yqian · ‎03-22-2018

Thanks Brendan. I think it is a bug as well. We also submitted ticket to Anaplan Support. Yiping

yqian · ‎03-19-2018

Thanks a lot David for your suggestion. Hope Anaplan can consider to add the push function in future. Yiping

yqian · ‎03-15-2018

Hi Everyone, We set up a Data Hub and would like to use it for multiple models, because there are lots common lists that we can use for various models. When we build connections among Data Hub model and other output models, we can set up actions in output models, by importing connecting "Data Hub" model's lists, to push data into output models. But is there a way to pull Data Hub's data, which means exporting connecting to output models? Let's summarize the data flow as following: Output models <= Data Hub model: OK (by importing connecting Anaplan Data Hub model) Data Hub model => Output models: ??? (by exporting Data Hub model) Right now it seems the export function is limited to export to csv, xls, txt files, but not export directly to Anaplan connected models. Does anyone know about the Data Hub exporting functions to Anaplan connected models? Worst case we can pull Data Hub's lists within output models, but we would like to see if it is possible to push Data Hub to output models, so it can save our time. Thanks in advance! Yiping

yqian · ‎03-15-2018

Hi Paul, Thanks for looking into that. Yes, we did not have any experience like that in the past. We were able to adjust the intial page regardless if it is a list or a line items. I am not sure if it came with the new release of the dashboard feature and this does not work all time any more. Sometimes we are able to switch the initial page, sometimes are are not. Ie: 1) we can switch FY18 to FY19 in the intial page in Dashboard 1, but we can not switch FY18 to FY19 in the initial page in Dashboard 2, all locked. 2) we can not switch product A in Dashboard 1, but we can switch product B in Dashboard 2 in intial page settings. It seems a bug that never happend to us before. Thanks, Yiping

yqian · ‎03-14-2018

Hi Everyone, When we set up our dashboard, we use "initial page" to put the default landing selector. It worked in the past. But recently we noticed that "initial page" can not be changed any more, after you publish the first time the dashboard. The yellow highlighted section is fixed to the "..." and can not be selected any more. We tried to re-publish the same content to a brand new dashboard and still got the same result, not be able to change the "intial page". But this did not happen on all selectors, some lists / line items work in one dashboard, but don't work in other dashbaord, all random. Is it a bug in the recent released version of Anaplan in Dashboard? It never happened in the past to us. Does anyone have the same experience? How we can solve it? Many thanks in advance! Yiping

yqian · ‎10-12-2017

Thank you so much Leo. BTW, how many months should I have in the Time Dimension, in order to let this App work? Yiping

yqian · ‎09-11-2017

Thanks David. We will try your suggestions by using the "fake" time dimension as a list. Hope Anaplan can release the new updates with an adjustable time dimension soon.

yqian · ‎09-08-2017

Hi Everyone, Is there any way to set up a rolling 18-Months in Anaplan, as time dimension? Right now we are able to set up 2 full fiscal years, to get 18-Months for forecasting. But at the 7th month of the current fiscal year, we need to have 1 more fiscal year, which will lead us to have total 3 full fiscal years in Anaplan's time dimension. That will definitely blow up the size of entire model. We have currently just one fiscal year's data, if we have 3 fiscal years, then our model size will be 3 times of our current model. That is why I would like to see if there is any possibility to have a rolling 18-Months settings in Time, and we could reduce our sparsity. Thanks everyone! Yiping

yqian · ‎07-27-2017

Yes, I have the same question on numbered list data import from 1 model to another. Does anyone have the solution?

yqian · ‎07-12-2017

When we export data from Anaplan, sometimes we want to keep a customized name instead of the default module name. If we save an action with our preferred name, although the Export Name is changed, when we click "run" actions, it will still be exported by the default module name. To solve this problem, we can create a process (under "Processes"). We customize the file name in "Exports" actions. But when we run the actions, instead of clicking on "Exports" actions, we click on "Processes" actions, we run direcly the "Processes". Then we can get the right file name we want. Below is the demo.

yqian · ‎07-04-2017

Thanks everyone, it is now solved! Due to Anaplan new release of Jun.24 2017, now the solution is: select the order in the table at first, then the chart published will be based on the order that I choose in the table. Thanks again for all the posts that you helped me.

yqian · ‎06-09-2017

Thanks Lokesh, I tried the sequence, it did not work to change the order of the stacked column. I also tried to move the order of line items in blue print view, and did not work neither.

yqian · ‎06-08-2017

I tried different methods: - by alphabet - by clicking order - by amount It doesn't work.

yqian · ‎06-08-2017

I have a dashboard with 2 charts, as above. How can I create the stacked chart in the order I want? Right now "Gap to Plan" and "Gap to Budget" are all at the top, but I want them to be at the bottom. There doesn't seem to be an option to specify this. Thanks for help!