Issue in Tabular Multiple Column Export Format

CommunityMember131357
New Contributor

Issue in Tabular Multiple Column Export Format

Hi All,

 

I am facing an issue while exporting data from a dashboard by selecting Tabular multiple column export option. Although the table on the dashboard has been published by creating a saved view(i.e. by selecting 'Show Selected Line Items only' option). However, while exporting the data in tabular multiple column(.csv) format the other line items which are not visible on the dashboard or the saved view are also getting retrieved.

 

Further Information: The grid view format retrieves the desired line items only but do not suffice the user purpose.Hence a solution is required around tabular multiple column export format and the data can also not be retrieved in(.xls)  format as it shows too many rows error therefore it can only be obtained (.csv) format.

 

Please help me around this.

 

Thanks

 

 

13 REPLIES 13
YukieM
New Contributor

Hi @CommunityMember131357 , I also encountered this issue however looks like this is how export works. Here we can find out how export works. https://help.anaplan.com/en/98017f9d-8fb9-4143-8420-5c4ed33c883b-Export-from-Anaplan If you look at "Module and dashboard export options" you can find out what supported options are and this situation "Show/hide or data filter with only line items on columns" there is no check with Tabular Multiple Column which means it is not supported. Once I tested this with additional items on columns (so line items is not the only item on columns) I got expected result (only filtered data was exported)
Soumyajaiswal
Occasional Contributor

Hi, 

 

But how do I apply any filter to the view? I am facing an issue where I am applying filter - having the filter line item in different module with same dimensionality. And can not add those filter line items in the same module as I don't want them in the Export. So how do I apply the filters?

ryan_kohn
Certified Master Anaplanner

@Soumyajaiswal You can apply a filter to a tabular multiple column export in the configuration of the export. The filter can be in another module, but the line item needs to share the same dimensions as the module you are exporting from. See here for more info: https://help.anaplan.com/e6151196-8b4a-46de-a18f-59338c3ff6b0-Export-filters.

Anilkumarch
Certified Master Anaplanner

Hi @CommunityMember131357  you need to recreate the export action if you have changed the ealier saved view. If the export action is not recreated then the export will have the line items as per previous saved view.