when we should use select function . can anybody tell me with an example or scenario .
@saurabh_kumar_kunwar
SELECT is a very useful where you want to get data from a specific list element and this list is a structural data (not production data).
Let's say you have 5 plants as your business units in the production chain. This is your structural data and the plants list is non-production. There is an invertory module dimensioned by plants/products/time. It stores closing stock data. You have very different calculation logic for one of your five plants ("Plant A") and you want to create a module for this plant only. This module obviously don't need to have Plants dimensions. So to collect closing stock from inventory for this plant you will have to choose it. You can do it with the formula looking something like this: Inventory.Closing Stock[SELECT: Plants.Plant A]
Another very common use case is when you have to take top level data of the list. For example, when you want to get a percentage ratio of a value divided by top level element of this list value. Plant A / All plants, Plant B / All plants, ets. This may look like Inventory.Closing Stock/Inventory.Closing Stock[SELECT: Plants.All Plants]
One more case when you need All periods data (when you have more than one year of your time scale). - Value[SELECT: TIME.All periods]
Or when you have to calculate delta for two versions. Value[SELECT: VERSIONS.FORECAST] - Value[SELECT: VERSIONS.ACTUALS]
More you can read in Anapedia about SELECT: https://help.anaplan.com/8511de23-aafd-47c9-979d-57c4218fbc8c-SELECT
As a general rule use SELECT to 'select' data from a target that either relates to a top level item of a list or a time item such as All Periods, Year to Date, Year to Go or Current Period.
It can also be used when retrieving data from a specific version.
A few examples;
Data[SELECT:TIME.All Periods]
Data[SELECT:Versions.Actual]
Data[SELECT:Cost Centres.All Cost Centres]
As @KirillKuznetsov has stated you should only use SELECT on list items that are non Structural data ( in other words will not be updated on a regular basis like product, locations etc ). If using SELECT on these list you can target the Top Level item as this is unlikely to change.
If you need to retrieve data from a specific list item then the best approach is to use a LOOKUP function instead.
@ChrisAHeathcoteagree
Thanks for your added details!
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
