Time Filter Based on Versions

Hi Team,

I have a scenario where I want to apply a filter on time (page selector) based on the Version which is also a page selector. I tried creating a time filter module and applied filter but it is not working.

Example:

If I select Forecast Version then the time page selector should show me FY21, FY22, FY23

If I select Budget Version then the time page selector should display FY 20

If I select Actual Version then the time page Selector should display FY19, FY20

Thanks,

Aish

Accepted answers

All comments

rob_marshall

@aishabhy05

What does your filter module look like? I would create a module dimensionalized by Version and Time (at the year level) with on line item named Show? which is a boolean. Then you can use that for your filter.

Rob

aishabhy05

@rob_marshall the filter module was by time(year) dimension and version and with display (boolean ) line item. The filter applies for only one version, however, I tried changing the summary methods yet it didn't work.

rob_marshall

@aishabhy05

Can you send a picture so we can get more information? I was thinking of this:

aishabhy05

@rob_marshall I tried the same filter, this is not working in UX Filter. If I select Result then

Version is customised version ( Not anaplan Standard version)

Thanks,

Aish

rob_marshall

@aishabhy05

I don't believe you will be able to do that, you will need to put Time in the grid.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
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…