Time Range replaced by Model Time in Pivot View
We have applied a time range of "Current Year" to a module.
However when I open pivot view of the same module, we do not see this, instead we see the full model timescale applied.
(Consequently, a filter applied to a NUX grid based off this module is now asking for a time selection. The filter line item has Current Year applied on it too)
I have tested other modules by replacing model calendar with time ranges and pivot always showed the updated ranges. Can someone help explain this behavior here?
Thanks for your reply @ManjunathKN ,
Unfortunately this is indeed a true issue that we stumbled upon:) Anaplan Support Team was able to analyze and recommend fix for this issue and we were able to resolve this successfully. Fixing the time range mismatch issue automatically also fixed the UX filter issue as I had initially anticipated.
Documenting the steps here for anyone else who might encounter this glitch:
Support team analyzed the model history based on when we first encountered the issue and identified the line item that was the root cause. But interestingly, they analyzed the history of this line item and found no real difference! no edits, no change to formula/applies to..etc at all!
Anyways, we now removed all references to this line item, then deleted the line item itself. All our issues with pivot and UX filter was resolved. We then recreated the line item back. Then we sequentially updated the line item attributes [ Ex: paste back the original Time Scale, wait for Model to save the change, then paste Time Range, etc.]. All was well.
Can we catch this before it happens? Apparently not. The support team noted that since this issue was caused by a user making no actual change to the line item, it would be difficult to avoid on our own. So we will reach out to them if this reoccurs.
Thanks for your engagement @Misbah @ManjunathKN . Appreciate it!
In Pivot, Anaplan Showing TIME instead of TIME RANGES has nothing to do with your query.
If you look at your Pivot, TIME is in Pages and not in Rows or Columns. UX allows you to filter Pages/Context Selectors in their own section which is up top right hand side. You can click on settings icon next to context selector and filter it.
Other way is to use Saved View instead of Custom View, but I would recommend you to use Filter on Context Selectors in UX.
Hope that helps
Thanks for the reply,
1. We noticed it too and had tried moving time to columns and reapplying the filter, and still had the same issue, pic attached. [we do need time on columns]
2. Could you also share your thoughts on my first question please? Why would the pivot show "Time" while the module clearly has a custom time range applied to it?
1. You can not have nested dimension in Columns and Apply filter only on one dimension (Time). Keep only Time in Columns and apply the filter - that should work. SYS12 filter module in your case has to be dimensioned by TIme only.
2. I don't know, I have noticed too that it doesn't show Time range's name instead shows only Time. Ask Anaplan Support and see what they have to say.
Hope that helps,
Thanks again for your reply @Misbah,
We are using a line item subset filter over both time and line items hence the nested dimensions in columns. This is working perfectly fine in our Deployed model but both these issues mentioned above have cropped up recently our DEV environment. We have raised a support incident and will be following up on the same.
You should apply the LISS filter against Time and not against line items for Nested columns, because your filter is having dimensions like LISS and CY I believe.
I still cannot believe that in Blueprint you can see CY and in grid view pivot, you are seeing TIME instead of Ranges.
Can you please should the full Screenshot of grid view pivot and Blueprint view?
LISS filter Module;
Module with Time Range;
Interesting! Never heard of this before. Thanks for letting us know.