}CubeProperties

Post Reply
rsulsona
Posts: 2
Joined: Fri May 06, 2011 12:56 pm
OLAP Product: Don't know
Version: 9.4.1
Excel Version: 2007

}CubeProperties

Post by rsulsona »

As a production shop using TM1, how do we automate the process of getting this cube to update.
We have "copied" a new cube from our DEV environment to our UAT environment. However, the contents
of this cube is not part of that copy for rather obvious reasons.

How do othe shops handle this when the IT staff is not suppose to "update" at UAT or Production?

Do you have a special person in your user community that is responsible for this function?
The same issues exist with the }HierarchyProperties cube.

Thanks

Robin Sulsona
cycleman83
Posts: 8
Joined: Mon Apr 13, 2009 2:36 pm
OLAP Product: Tm1
Version: 9.5.2
Excel Version: 2007

Re: }CubeProperties

Post by cycleman83 »

Once you copy the .cub file, you need to bounce the instance.

After bouncing the instance the }CubeProperties cube and more specifically, the }Cubes dimension will be updated and now contain the new cube.
rsulsona
Posts: 2
Joined: Fri May 06, 2011 12:56 pm
OLAP Product: Don't know
Version: 9.4.1
Excel Version: 2007

Re: }CubeProperties

Post by rsulsona »

We bounce all of our instances every night. However, in our DEV instance I had set the properties to know that
Measure was the Measures dimension.

This did not get populated in our UAT environment and I had to go into the cube and set the properties manually.
Is there some automated process that would have done this. What do we do now.....
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: }CubeProperties

Post by Alan Kirk »

rsulsona wrote:We bounce all of our instances every night. However, in our DEV instance I had set the properties to know that
Measure was the Measures dimension.

This did not get populated in our UAT environment and I had to go into the cube and set the properties manually.
Is there some automated process that would have done this. What do we do now.....
The Measures dimension is meaningless to TM1; it only exists for compatibility with other applications that may be querying it, which is why it has to be set manually. The other option that you have is to create a housekeeping chore which runs some time after your server reboot and updates cube and dimension properties.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Post Reply