[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