TM1 Forum

hi ,
i have 5 dimensions (base_month_dates ,measures_machines_capacity ,base_years, ssr , fd ) in 'Sample' cube.

i want to creeate a view named 'Current' with first 3 dimensions using below script.

after creating a view , i am able to see the current view with all 5 dimensions, is there any way to restrict with 3 dimesions as per the script.

ViewCreate(Sample','Current');

ViewTitleDimensionSet(Sample','Current','base_month_dates');
ViewTitleDimensionSet(Sample','Current','measures_machines_capacity');
ViewTitleDimensionSet(Sample','Current','base_years');

ViewTitleElementSet(Sample','Current','base_month_dates',DIMIX('base_month_dates',vDate));
ViewTitleElementSet(Sample','Current','base_years',DIMIX('base_years',vYear));
ViewTitleElementSet(Sample','Current','measures_machines_capacity',DIMIX('measures_machines_capacity','WIP DH Lots'));

guntupalli wrote:after creating a view , i am able to see the current view with all 5 dimensions, is there any way to restrict with 3 dimesions as per the script.

I'm not sure what you mean by "restrict" but if you mean to not show those dimensions in the view then the answer is no. A cube is a collection of dimensions with data stored, and/or calculated, at each intersection of the dimensions. If you don't include a dimension in the view then you have no intersection with all the other dimensions and thus no data. Think about it for a minute.

In TM1 WEB, you can hide dimensions to not display in the main screen, but they are still part of the view.

There is no similar functionality in Cube Viewer. All dimensions part of the cube are displayed.

tomok is write...you need to have atleast one dimension element of remaining dimensions.
If we have this sort of issue we generally have some element added into dimension which will have no meaning in dimension and then create a view by having that element in the SUbset for that dimension.....