Introduction
An additional prism shell command is now available using the attached cubeconverter.exe
This exe file will enable us to convert ecube files to xml and vice versa.
Usage & Benefits
This will enable us to easily modify many ecube parameters such as data source name and location, table names, dimension names and more. This can be easily done by converting an .ecube file to xml, editing it as an .xml file using any word editor, and then simply converting it back to an .ecube file.
Example
Here we will convert the Northwind.ecube to Northwind.xml and back.
Following, please see the Cubeconverter.exe parameters:
In order to convert an .ecube file to .xml simply state the file name and extension, i.e. cubeconverter.exe Northwind.ecube
Same goes for converting from .xml to .ecube, i.e. cubeconverter.exe Northwind.xml
Steps:
The following are steps in order to convert from .ecube to .xml
1. Download the attached zipped folder and place it in C:\Program Files\Sisense\Prism
2. Save your .ecube file in the following location:
C:\Program Files\Sisense\Prism
3. Open the cmd prompt 'as admin'
4. Browse to C:\Program Files\Sisense\Prism
5. Run the following command:
CubeConverter.exe Northwind.ecube
Note: Run the following command in order to convert the .xml file back to .ecube
CubeConverter.exe Northwind.xml
For more on the Prism shell commands, please see:
https://support.sisense.com/entries/20175731-Prism-Shell-PSM-EXE-
***3/25/2016 UPDATE The attached "CubeConverter.exe" below is to be used with versions prior to V6.2. In versions 6.2 and above, the converter capabilities are available in the Sisense Shell as described here****
Download: