Hi,
How can we publish Year only as the page selector in new UX to synchronize the monthly view?
Thanks,
Tom
Hi @tompatrick.ting ,
You can use the 'Show / Hide' , in the context selector to open a menu of options. And then, you can choose to switch off 'Time (Details)'.
Below are the screenshots which might help you!
@Vinay VaradarajM, thanks for replying. I don't have that option in our time dimension. Please advise what I am missing.
@tompatrick.ting
Go back One more step until you reach the module views (custom module View in NUX). There you can show/hide your levels. However keep one thing in mind that once you use "Show/Hide" option hierarchy sync doesn't work.
Thanks @Misbah ,
Its really not showing on my page. Instead, i decided to create a module for year selector and applied the filter to show the monthly phasing.
The reason you do not see 'Show / Hide' is, if you do not have Time dimension in your Page/Context selectors in the Pivot.
- In such cases, you can adjust your pivot to have Time dimension in context selector, which will enable the 'Show / Hide'
- Then, you can choose to disable the Time(Details) to only show years
- And then, again return back to your required pivot (where you wanted Time to be showing as Columns possibly), and publish it
This should help!
If you would like to show months in the table and allow the user to filter the view by selecting only a year then you need to create a module filter using a time property module.
The hierarchy filters which you have enabled can not be filtered to only show the parent as @Misbah has suggested.
Create a flat filter selector module with a time period formatted line item. Change this to years and publish to the relevant page using a field card.
In a time properties module set to months create a line item called FY and format this as year time period. Use the following formula to set this as the financial year for the respective month.
=parent(item(time))
Create a new line item called year filter. Format this as boolean. Use the following formula to check all those months whose FY matches the filter selector module.
=Time Properties Month.FY = Year Filter Selector.FY
Use this filter line to filter your table in the UX.
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…