Focal Point
[SOLVED by IB] In olap report can we rename the dimension..

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4491097403

October 31, 2008, 06:47 AM
Santhu
[SOLVED by IB] In olap report can we rename the dimension..
In olap report, Can the dimension names be renamed ??
example:-
-OLAP ON
OLAP DIMENSIONS
-* DIMENSIONS FILE VVV
Region: SUP_MAN_REG, VVV_PRDLINE_DESC;
Time Frame: TIME_FRAME;
END

Now can we rename this SUP_MAN_REG to REGION and VVV_PRDLINE_DESC to PRODUCT LINE.

And in OLAP we have a default drop down as ALL optin is available but i am only 12M to be selected.like this(Time Frame: TIME_FRAME EQ 12M; )
Is there any option available ?

This message has been edited. Last edited by: Kerry,


WebFOCUS 8.0.0.7 App Studio
October 31, 2008, 08:21 AM
Santhu
does anybody have an idea on this??


WebFOCUS 8.0.0.7 App Studio
October 31, 2008, 10:53 AM
<HarryL>
You can reset the dimensions in the report itself (in DevStudio) and assign any names and groupings you desire. Click on the OLAP Dimension Toolbar item (4 blue boxes connected by 3 lines) to accomplish this.
October 31, 2008, 11:09 AM
Santhu
it is not possible to rename the grouped dimensions.


WebFOCUS 8.0.0.7 App Studio
October 31, 2008, 11:49 AM
<JG>
Do it as multi-step with a hold file using AS 'whatever' and ON TABLE SET ASNAMES ON

That way you can change any names you want