LEVEL 1 MODEL BUILDING : PART 12 DASHBOARDS

Svint Park

I am on Part 12 Activities : Create Saved Views.

On Create Saved Views for REP02 module,

I was trying to make a new view for REP02: Chart DB just as guide shown below.

Saved View Name: REP02: Chart DB

Filter: n/a

Pages: G2 Country, Line Items

Columns: Time

Rows: n/a

I am having a problem with item 'Size'.

If I go to Blueprint Mode and modify 'Applies To' to remove Size, I get this warning message.

MSG : Datatype mapping used for aggregation doesn't match any dimension of the result

How do I remove Size?

1_55382.PNG

2_55382.PNG

Accepted answers

Misbah

@Svint Park

It will not allow you to remove the Size List because it is aggregating the values based on Size list. See first two line items

Revenue ----Source[SUM: Size]

Cost of Sales----Source[SUM:Size]

If you remove the formula from these line items it will allow you to remove the Size list from the module. However I am not going into details why do you want to remove it

Happy Planning

Misbah

All comments

Misbah

@Svint Park

It will not allow you to remove the Size List because it is aggregating the values based on Size list. See first two line items

Revenue ----Source[SUM: Size]

Cost of Sales----Source[SUM:Size]

If you remove the formula from these line items it will allow you to remove the Size list from the module. However I am not going into details why do you want to remove it

Happy Planning

Misbah

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…
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…
Exports with anaplan using informatica connector
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…