}DimensionAttributes Issue

[mlorini]

I am trying to set DIMENSION_TYPE attribute to Geography but I do not have the }DimensionAttributes in my cube. Does anyone know how to find/enable such dimension? I am on IBM® Planning Analytics Workspace 2.0.62

Thanks

[declanr]

The cube is created automatically if you use Performance Modeler, when you don't you can just create it with a TI process and it will work absolutely fine.

However based on your instructions it looks like you are trying to set it so you can work with map charts, I *think* in PAW 62 you no longer actually need to define the Dimension as being GEOGRAPHY and PAW just works that out for you after you select the Legacy Map chart.

Also... according to the roadmap, within the next couple of releases we should have the new map chart type available to us which will allow for much better details etc. (Similar to Maps in Cognos Analytics)

Code: Select all

#-----------------------------------------------------------------------
 # P1/ Set Constants and Variables
 #-----------------------------------------------------------------------

 cDimName = '}Dimensions';
 cDimAttr = '}DimensionAttributes';
 cCubeName = cDimAttr;

 #-----------------------------------------------------------------------
 # P2/ Create Control Cube and Dimension
 #-----------------------------------------------------------------------

 # Create Dimension
 DimensionCreate ( cDimAttr );
 DimensionElementInsert ( cDimAttr, '', 'DIMENSION_TYPE', 'S');
 DimensionElementInsert ( cDimAttr, '', 'Caption_Default', 'S');
 DimensionElementInsert ( cDimAttr, '', 'Caption', 'S');
 DimensionElementInsert ( cDimAttr, '', 'DIMENSION_INFO', 'S');
 DimensionElementInsert ( cDimAttr, '', 'CORRECT_EXPR', 'N');

 # Create Cube
 CubeCreate ( cCubeName, cDimName, cDimAttr );

[mlorini]

Thanks so much for your help and advise.