Can't get my export right

LouiseBourgonjon_*46808

Hi community members,

I have created a saved view in which I enable a filter to filter out any rows which have a CIP value (kLOC) = 0.

The filter uses a boolean line item in the module itself, which defines if the value is different than 0.

When I look at my saved view, it looks good.

However, when I export the view, the rows with CIP value (kLOC) = 0 are still included in the export.

I don't understand why. I have first created the saved view and then ran the export action.

Can anyone help?

Another strange thing: when I open the filters of my saved view, a number of filters seems to be added automatically, without me selecting it. Maybe this is messing it up? But how do I get rid of this automatic additions?

I have attached some print screens to make it more clear.

Thank you for your help!

filters_of_saved_view_123095.PNG

Result_in_Export_file_all_rows_are_included_however_they_are_0_123095.PNG

saved_view_in_Anaplan_123095.PNG

Accepted answers

LouiseBourgonjon_*46808

I checked this with Anaplan support and they came back to me with the following answer:

After further investigation by our Product team, it has now been decided that we currently do not plan to fix this issue.
The workaround for this issue is to remove the existing filters, export data the way you normally do and then apply the filter in Excel. This issue has also been documented on the Known Issues page on Community and can be found here .

All comments

Misbah

@LouiseBourgonjon

Are you using Tabular Multiple Column option while exporting it out. If yes, then saved view filters are not supported.

Try using Tabular Single Column option

Misbah

LouiseBourgonjon_*46808

Hi @Misbah ,

I am actually using the Grid layout, because I want a separate tab for each page selector item.

Misbah

@LouiseBourgonjon

In that case you will have to check if the export action has been created by using the saved view. I doubt it.

It must be using some other saved view or the default view. Go to Saved View, Run Export and see if it throws similar results

Misbah

LouiseBourgonjon_*46808

Hi Misbah,

That is what I did.

I delete any other existing export action on that module, I go to the save view and I click data, export and I save the export action.

Misbah

@LouiseBourgonjon

Strange!

Raise a ticket with Anaplan Support

LouiseBourgonjon_*46808

@Misbah , I raised a ticket. I will keep you posted on the outcome.

LouiseBourgonjon_*46808

I checked this with Anaplan support and they came back to me with the following answer:

Quick Links

Can you help?

Unanswered questions

Not Able to Join the Level 1 Model Building Course
Hey Everyone, I was trying to learn about the Level 1 Model Building Course, when i log in to my system and click on "Start the course" option its showing training unavailable, Can anyone please help me with this @Dikshant and all?
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
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…