Selective Access and Tabular Multiple Column Exports

dameyer01 · 2023-03-14T18:18:55+00:00

There was an error rendering this rich post.

I have defined an export using the Tabular Multiple Column layout, filtering using a Boolean from a separate module. The module being exported uses a list with Selective Access. When I try to limit my access and run the export, to test how an end user would interact with the export, the model exports rows for ALL members of the list, but only the rows for which I have access have data populated. Is this an idiosyncrasy of exports with the Tabular Multiple Column layout? Or is there something else I'm not aware of?

Example: An employee list has 10 members. I have access to one employee. The export outputs 10 rows, but only one row has data.

Accepted answers

All comments

HimanshuRaj

Hi @dameyer01

Not sure what that filter is doing to your export view, but when selective access is applied to your list, then you'll only get those items in the export table that you've access to.

I'd advise checking that filter

Cheers!

dameyer01

Don't know if this is a bug to report or a known issue, but we found the culprit. Below is an example

Scenario: A module is dimensionalized by Business Unit (BU) and Region (Region has selective access). The module has a line item that aggregates revenue for every combination of BU and Region, but also has a line item that just pulls in the BU item. To reduce sparsity, the builder uses a subsidiary view and sets the ‘Applies To’ to only BU.

Problem: When an end user runs an export using the ‘Tabular Multiple Column’ column layout, the resulting export has rows for ALL combinations of BU and Region. Line items using the Region list are blank, but the line item with the subsidiary view is fully populated.

All Regions Export.xlsx

Americas Only Export.xlsx

Solution: Modify the subsidiary view by including Region (or matching the module's dimensionality).

Has anyone seen this before? I've attached a couple sample files showing the same.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
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…
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…