Import and Export Availabilities in Sheets
We now enable you to import and export availabilities for quick updates to your cube and modeled sheets. You can also export a simple and scannable presentation of what's currently available on the sheet. This enables you to then make changes to the spreadsheet and import it.
Watch the video:
4m 19sCube Sheet Import and Export Availabilities
Release: 2022-03-12
In the Dimensions, Attributes and Levels section on the cube sheet building area in Modeling, we add new import and export links in the settings for the Level column and columns for accounts, attributes, and custom dimensions.
In each column type, we enable you to use a new template or your updated export to indicate the levels, accounts, or dimension and attribute values you want to appear on the sheet.
In the template for custom dimension values, we also enable you to confirm that you are deleting data when you remove custom dimension values.
Modeled Sheet Import and Export Availabilities
Release: 2022-03-12
In the Columns and Levels section of the modeling sheet building area in Modeling, we provide new import and export links in the settings for the Level column and dimension columns.
In each column type, we enable you to use a new template for your updated export to indicate the levels or dimension values you want to appear on the sheet.
In the template for custom dimension values, we also enable you to indicate how to handle the data if you remove a dimension value from the sheet:
- Delete: Removes the data.
- Move to next available ancestor: Adds data to the rollup.
- Set to none: Adds the data to the uncategorized dimension value.
Sheet Availability API
Release: 2022-03-12
We deliver the new Sheet Availability JSON formatted REST API, enabling you to import and export sheet availabilities.
This new endpoint supports GET and POST, enabling query parameters for:
- sheetName
- columnName
- columnCode
- columnType
- instanceCode
- limit
- offset
See Sheet Availability.