TM1 Forum

I have the problem about sharing Dimension. There're many developer to work on this project and we have to use some Dimension together.
So if we need to modify something on any sharing Dimension, we need to know which Cube concern with the Dimension.
How can we find out easily, with out checking on every Cubes. (There're a lot of Cubes)

Thank you very much

mangphung wrote:I have the problem about sharing Dimension. There're many developer to work on this project and we have to use some Dimension together.
So if we need to modify something on any sharing Dimension, we need to know which Cube concern with the Dimension.
How can we find out easily, with out checking on every Cubes. (There're a lot of Cubes)

Thank you very much

If you can wait a week or so this will be part of the documentation functionality in the next release of TM1 Tools, along with checking for "orphaned" dimensions.

If not, I suggest that you write yourself up a quick and dirty TI to iterate through the cubes. Off the top of my head...

(a) Use the "All" subset of the }Cubes dimension as your data source;
(b) Have the name of the dimension that you want to check for as a process parameter;
(c) In the Data or Metadata tab (doesn't really matter which) use a While loop for the values 1 to 16 (or the maximum number of dims that you have in your cubes) to check the result of the TabDim rules function against the process' dimension name parameter. If they match, write the name of the cube out to a text file via an AsciiOutput function.

Sorry if I missed it, Alan, but what do you mean by TM1 Tools?

If Alan can plug then I guess so can I ...
This functionality has been available in the Cubewise Extend toolbar for quite some time. (google it, but the web page is not very up to date ) Disclaimer. I am associated with Cubewise (at least for the immediate present).

comma wrote:Sorry if I missed it, Alan, but what do you mean by TM1 Tools?

That's TM1 Tools:
http://forums.olapforums.com/viewtopic.php?f=21&t=2515

We charge a lot less than Cubewise, but of course you get what you pay for.

(It also explains why it's been so long since the last release...)

lotsaram wrote: Disclaimer. I am associated with Cubewise (at least for the immediate present).

That sounds ominous...

Set }Dimensions subset all as datasource, label the variable as mydim name and Other data type, put the following into data -

used=0;

# Cycle through all the cubes

count = 1;
while (count <= dimsiz('}Cubes'));
cube = dimnm('}Cubes', count);
cubeIndex=1;

# If dimensions are only used by control cubes they are still classified as unused, hence second part of if statement

While(cubeIndex <=16);
if(myDim @= tabdim(cube, cubeIndex));
asciioutput(pathway, myDim, cube);
endif;
cubeIndex = cubeIndex + 1;
end;
count=count+1;
end;

as long as you declare the pathway in prolog, this will give you a list.

You can find a worked TI solution here (with downloadable .pro file)
Cubewise tech tip - which cubes use which dimensions?

You can also do it dynamically with a cube that has rules. That way changes will show immediately without the need to run an processes.

Cube - AuditCube
Dimensions - }Dimensions, }Clients, CubeDim, CubeDimMeasures

CubeDim looks like this:
Top level parent name "All_Cube_Dims" with following children 1,2,3,4,5,6,7,8,9,10,11,12... (maximum numnber of dims in model), all N elements

CubeDimMeasures looks like this:
Exists (S element), Position (N element)

Rule Code:
['Position']=n:IF(TABDIM(!}Cubes,NUMBR(!CubeDim)) @= !}Dimensions,NUMBR(!CubeDim),0);
['Exists']=S:IF(['Position']>0,'X','');

lotsaram wrote:If Alan can plug then I guess so can I ...
This functionality has been available in the Cubewise Extend toolbar for quite some time. (google it, but the web page is not very up to date )

Capture.JPG

Disclaimer. I am associated with Cubewise (at least for the immediate present).

Could you please tell me how can I get this tool ??

mangphung wrote:

lotsaram wrote:If Alan can plug then I guess so can I ...
This functionality has been available in the Cubewise Extend toolbar for quite some time. (google it, but the web page is not very up to date )

Capture.JPG

Disclaimer. I am associated with Cubewise (at least for the immediate present).

Could you please tell me how can I get this tool ??

See Cubewise's posting in the Partners' group:

http://forums.olapforums.com/viewtopic. ... 3288#p3288

Links are at the bottom of it.