Hello,
It has been long that I have shared any article / topic in my blog. Actually I was too busy with my current projects / assignment.
However, few days back I found an interesting utility while building UNICODE DIMENSIONS for Essbase ASO cube.
When you use Essbase Studio to build Unicode ASO cube dimensions, the in-build features of Essbase Studio take cares of building Unicode ASO Cube dimensions while connecting Relation Database with Essbase Cube.
However, when you are suppose to build Unicode ASO cube dimensions using ASCII format files via MaxL command, you are in trouble. You get dimension build errors (Command Failed. Return Status = 1054036).
However the same MaxL runs perfectly on the EAS MaxL editor.
There are few ways to make this run using MaxL on command.
Option 1 : Create the MaxL using EAS MaxL editor. While saving the MaxL into a file, check the "Unicode" check box which appears at the bottom of the Save File option window. Use this file to run on MaxL Command
Option 2: Use ESSUTF8.sh /ESSUTF8.exe utility stored at the path arbor path(Essbase Server Path)/bin
It has been long that I have shared any article / topic in my blog. Actually I was too busy with my current projects / assignment.
However, few days back I found an interesting utility while building UNICODE DIMENSIONS for Essbase ASO cube.
When you use Essbase Studio to build Unicode ASO cube dimensions, the in-build features of Essbase Studio take cares of building Unicode ASO Cube dimensions while connecting Relation Database with Essbase Cube.
However, when you are suppose to build Unicode ASO cube dimensions using ASCII format files via MaxL command, you are in trouble. You get dimension build errors (Command Failed. Return Status = 1054036).
However the same MaxL runs perfectly on the EAS MaxL editor.
There are few ways to make this run using MaxL on command.
Option 1 : Create the MaxL using EAS MaxL editor. While saving the MaxL into a file, check the "Unicode" check box which appears at the bottom of the Save File option window. Use this file to run on MaxL Command
Option 2: Use ESSUTF8.sh /ESSUTF8.exe utility stored at the path arbor path(Essbase Server Path)/bin
essutf8 -b -s
and use this MaxL file to run on MaxL command. you can find more details of using ESSUTF8 utility in the link
Hope this helps.
Happy sharing
