Time Range replaced by Model Time in Pivot View

Hello Everyone,

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?

Thank you!

Accepted answers

nikmg

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!

Best,

Nik

All comments

Misbah

@nikmg

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

Misbah

Miz Logix

nikmg

@Misbah

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?

Best,

Nik

Misbah

@nikmg

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,

Misbah

Miz Logix

nikmg

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.

Best,

Nik

ManjunathKN

Hi @nikmg,

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?

Thanks,
Manjunath

ManjunathKN

@nikmg

For Reference,

LISS filter Module;

Module with Time Range;

Thanks,
Manjunath

nikmg

Thanks for your reply @ManjunathKN ,

Documenting the steps here for anyone else who might encounter this glitch:

Thanks for your engagement @Misbah @ManjunathKN . Appreciate it!

Best,

Nik

ManjunathKN

Hi,

Interesting! Never heard of this before. Thanks for letting us know.

Manjunath

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…