Publish Line Item as Page Selector to Dashboard

Hi team,

Are you able to publish a Line Item from a module to a Dashboard as a Page selector that will act in the same manner as the dimensions published? e.g. the line item will change with the line item selected?

Each time I attempt to 'Publish the Selected Line Items to Dashboard' the value of the line item is published, not a drop down selector

Thanks

Accepted answers

All comments

ashish.banka

@MarkTurkenburg Could you please check the format of the line item which you are publishing to the dashboard? It has to be a list line item so that the drop-down appears when published to dashboard.

Hope this helps.

AWhitworth

Yes you can do this, instead of publishing selected line items use the option publish page selectors to dashboard with the line items pivoted to the pages

abhay.kanik

@MarkTurkenburg

As I can understand you want to filter the line items on be basis of the item selected in the selector. You have to crate a custom filter to achieve that.

If that is the case you can do it with the steps below -

Create a line item subset(LISS) of the line items .
Create a system module dimensioned by user list and add a line item 'Selector' which will be formatted by the Line item subset you created.
Create a filter module which will be dimensioned by the LISS ad User list, Create a boolean line item and put formula Selector = item(LISS)
Use the boolean to filter the line items in module ,save and publish the view
Publish the selector line item on dashboard and it will act as a filter.

This will also help you in NUX

Thanks

Abhay

MarkTurkenburg_*56377

Hi @AWhitworth ,

Thanks but this does not work. It was the methodology I used initially but it will only publish the Dimensions excluding Line Items to the dashboard (even when the Line Items are pivoted to Page Selector on the module)

Also I never realised that it publishes all dimensions to the Dashboard regardless of whether they are a Page Selector in the dashboard or not

Mark

MarkTurkenburg_*56377

Hi @abhay.kanik ,

Thanks very much for the detailed response but I feel this is a prime example of why Anaplan can sometimes make what should be simple very difficult. Effectively all I am wanting to do is replicate the Page drop-down selector functionality from the module to the Dashboard but using the 'Page Selectors' as the UE is better than just the native selector attached to the module

I think I will just use the native functionality but thanks very much for your help

Mark

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…