TM1 Views and TI

[Jon]

Hi all,

I'm currently working on my first full TM1 system across multiple cubes. I've currently got a problem where I'm trying to transfer data from one cube to another.

I've come across a problem with Turbo Integrator where I'm trying to pull all the information from one cube and CellPut it into the other one. My main issue is reading the data out. I assume I need to create a view which has the lowest level of all elements to get all the information out? When I try to create a view via the Cube Viewer I get it down all down to the lowest level and when I try to save it errors out saying "View may be too large. Operation Aborted". To be fair there are 10 dimension with a lot of elements within there.

Can I create a view without doing it through Cube Viewer or is there another way of pull all the data?

Thanks in advance!

[jim wood]

Hi Jon,

You have 2 options:

1) If you right click on the cube you can create a view by selecting export as text. Make your changes to the dimension selections within this interface and save your view. The view must be public not private. In the past I've used a specific naming convention to stop users trying to use these views.

2) Use the ViewCreate function in TI. If you do this in the prolog you can combine it with SubsetAssign functions and varioud other functions that you can find in the help to create your view. Then epiloge get rid of the view using ViewDestroy.

Option 2 is cleaner but you'll need to work at the TI in stages if you haven't done it before. May be start by using a TI script to create a view. Then try to adapt it by adding subsets etc.

I hope that helps,

Jim.

[Jon]

Many thanks Jim! Thats exactly what I'll do!