Hi All,
I am trying to import data into my module however, i am not able to map the date format with the modules timescale, the date is in "Week 1 FY19" format and i am not sure which time scale format will be suitable for the same.
Thanks.
@sharmagh
If your time format is like "WEEK 1 FY19" then you should keep it as "Match Name" in Import Mapping. Let us know if you are facing any issues with that
Misbah
Hi Sharmagh,
If you navigate to Import settings, you are able to select the format you need either from already excising options OR the custom one, where "?" replace characters which should be ignored - see the screenshot below.
Hope that helps,
Dmitry
The date should be formatted in - periods - custom fixed-position pattern : ???? W ??YY
Note the space must be added in after and before the question mark to match the custom date format otherwise the import won't work.
😅
Hi, I'm using the OFFSET formula, where a calculated and number-formatted field determines how many previous weeks the formula should look back. Based on this value, it retrieves the corresponding week's data into the output line item. The formula works correctly for some products; however, it fails for others. The issue…
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
I have a question about the new Expand or collapse grid rows option. Is it possible to publish a grid containing a 5-level hierarchy so that all items from levels 1 and 2 are always visible? And I do not want to use a filter for this.
