Skip to main content
December 2, 2024
Solved

Cube Dimension Assignment - Excel template / Metadata Builder

  • December 2, 2024
  • 2 replies
  • 0 views

G'day,

Pls share if there is an Excel template for Cubes like the Metadata Builder for Dims and Workflows.
That will help us update OS Dimensions in many Data Cubes with various Scenario Types.

TY.

Best answer by rhankey

Not an Excel template, but I usually setup one cube through the User Interface, then export the Cube to XML, then simply copy/paste in XML to define the other cubes.  Once done, I import the XML.  The CubeDims section is pretty darn easy to understand and work with.

2 replies

rhankeyAnswer
December 2, 2024

Not an Excel template, but I usually setup one cube through the User Interface, then export the Cube to XML, then simply copy/paste in XML to define the other cubes.  Once done, I import the XML.  The CubeDims section is pretty darn easy to understand and work with.

December 2, 2024

There is none but you could develop your own, generate an xml and upload through Load/Export.

You can see xml format by exporting cubes.