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'));
how to create a view through TI process
-
- Posts: 19
- Joined: Mon May 16, 2011 12:15 pm
- OLAP Product: tm1
- Version: 10.2
- Excel Version: 2010
how to create a view through TI process
Best Regards,
Guntupalli
Guntupalli
-
- MVP
- Posts: 2831
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: how to create a view through TI process
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.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.
-
- Community Contributor
- Posts: 132
- Joined: Thu Oct 15, 2009 7:45 pm
- OLAP Product: TM1
- Version: 9.4.1 9.5 9.5.1
- Excel Version: 2003 2007
Re: how to create a view through TI process
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.
There is no similar functionality in Cube Viewer. All dimensions part of the cube are displayed.
Ankur Jain
-
- Posts: 21
- Joined: Thu Nov 05, 2009 8:56 am
- OLAP Product: TM1
- Version: 9.4.1 9.5.1 9.5.2 and 10.2.2
- Excel Version: 2003 2007 and 2010
Re: how to create a view through TI process
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.....
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.....