How to remove a dimension from a pivot?

juanacevedo

Hi,

Does anybody know how to remove a dimension from a Pivot?

I need to remove "time" from the "Pages" (See below).

Thanks

Juan

Accepted answers

All comments

AntonMineev

Hi @juanacevedo!

You need to delete list from module. For time you need to change Time Scale to "Not Applicable": Снимок экрана 2021-07-21 в 17.17.30.png

Ranjitha

Hi @juanacevedo

Yeah, as @AntonMineev suggested you will have to change the Time Scale to Not Applicable.

Here are the detailed steps

i) Toggle from Regular view to Blue Print View. Click on highlighted button.

ii)Move your Horizontal bar towards right to see "Time Scale", Click on the arrow to see the dropdown.

iii) Select "Not Applicable" to remove the Time Scale from your existing module.

iv) You will get a popup message soon after the selection. Click on "ok"

v) If you want the remove the Time Scale even for line items, you can just copy and paste it.

Billings523

To remove a dimension or metric, click its delete icon. The dimension or metric is removed from the table and added to the available list. To add a new dimension, drag the dimension from the available list to the appropriate location in the row or column groups.

paycheckrecords

Quick Links

Can you help?

Unanswered questions

ADO - On Premise MSSQL Server Connector
I’m trying to understand how Anaplan Data Orchestrator (ADO) connects to an on-premises SQL Server. In Anapedia, I found this: An MSSQL instance hosted on a cloud platform, such as Amazon Web Services (AWS), Azure, Google Cloud Platform (GCP), or any other cloud provider. The solution is compatible with on-premises SQL…
How to get most recent actual year value into a non-time (staging) module and use it for forecast ca
Title: How to get most recent actual year value into a non-time (staging) module and use it for forecast calculations? Question Body: Hello Anaplan Community, I am working on a financial model (Higher-Ed long-range planning) and need guidance on a best-practice pattern to retrieve the most recent actual year value and use…
Access model data outside of assigned workspaces?
I'm using the Integration API 2.0 to list workspaces https://anaplan.docs.apiary.io/#ListUserWorkspaces /workspaces "Retrieves all workspaces a user has access to within the user's default tenant." I'm only assigned to 2 workspaces (which are the only ones visible in the UI also), but this endpoint is returning everything.…