Best Of
Re: Import Character Error
Hi @TimothyThomas this did the trick, it worked!, thanks a lot for the help. It's funny how this little errors can be hard to figure out.
Monpero
Re: How to get Current Fiscal Year from Time, as a number, when Current Period is not set in the model
Oh, it has been requested (having a line item figuring out what today is), but it is a bit more complex than what people think. You have to take into consideration time zones as well as what is the date if you restore a model (is it still todays date or is it the date of when it was restored, etc.). With that said, it is on the roadmap, hopefully it will come out in the near future.
Rob
Re: How to get File IDs for a specific process and then download Via Azure Logic App.
Hi Anirudh, did some research and came to the same conclusion, as for chunk part will have to see what i can do with available utilities.
Thanks for the reply guys, means a lot.
Re: Enhanced NUX Drill Down
Any update on this? We just discovered the lack of Alt+F8 functionality in the NUX comparable to classic and it greatly impacts our ability to use the NUX for certain things.
kjochim
Converting numbers to text without losing decimals
Hi!
I am trying to create a reporting module with mixed line items (numbers and percentages) so I am converting the numbers to text for display purposes only.
We need 1 decimal and have very small numbers eg. 0.0001 which should then be displayed as 0.0 however during the process the decimal is lost.
Same issue with integers: they are displayed as 3 instead of 3.0
This is how it is in Anaplan currently:
- ACT is text using TEXT(ACT1)
- ACT1 is in number format
Thank you for your help in advance!
Re: Latest platform releases
We launched several new exciting updates in July, including updates to Management Reporting and Polaris. Read the full article here
VickiA
Re: How to get File IDs for a specific process and then download Via Azure Logic App.
Hi,
Easiest way is to check from Anaplan modelling experience the actions included in the process and then to which files are linked to these actions. Then you can find file IDs for these specific files.
From article below you can find python example on how to import and export files in single chunks
Re: 【質問】Timeの小計列を前に持っていきたい
こんにちは
ColumnがTimeだけであれば、任意の行をクリックした後Totals Positionで変更ができそうです。
添付いただいた画面だと、Timeとは別に「台数」という項目で2つディメンジョンがネストされているのでソートがうまく働かないのではないかと思いました。下記のようなエラーが出たりしませんでしょうか？
Pivotの構成を見直していただけるとよろしいかと思います。
ご確認くださいませ。
Amaya
Amaya
Re: Import Data Module and List at the same time
A few points to consider;
- Firstly import the data file. If the data has a unique key then first create a list using this key and then import the data into a module. Create line items to capture the data, formatting these as text with the exception of numbers and dates. This will be your new data module where the result of the import will be stored.
- Use FINDITEM to create mappings to all the relevant list in your D | Fruits module.
- Use this data module to create list build views that will form the basis of creating / updating all relevant lists. You can use the select levels to show to remove summary items and ISFIRSTOCCURRENCE. Create a saved view for each list that will be updated.
- Use SUM to pull the data from the new data module into your D | Fruits module.
- Finally, combine the data import and list build actions into a single process.
