TM1 Forum

Hi All,

i am using tm1 10.2

I need to combine data from two cubes and load it into a third cube. but the two cubes have a one to many relationship.

any help is highly appreciated.

Thanks,
Yogi

yogin wrote: i am using tm1 10.2

I need to combine data from two cubes and load it into a third cube. but the two cubes have a one to many relationship.

any help is highly appreciated.

I think that you would need to be a lot more specific than that. You haven't indicated whether you want to do this through Ti or through rules, or what the relationship is between the data in the first two cubes and the third one. You haven't given an outline of the cube structures and their dimensions, nor what the level of granularity (dimensionality) is in the three cubes.

More info below

Cube 1:
Dimensions:
- Project name
-Project type
- Status
Measures:
Project-golive date
Project profilename
Project profile shirtsize

Cube2:
Dimensions:
Project profilename
Project profile shirtsize
Serverclass
Measures:
No of servers needed

Cube3:
Dimensions:
Project name
-Project type
Project-golive date
Project profilename
Project profile shirtsize
Serverclass
No of servers needed

For a project in cube 1 users can pick one project profile and shirtsize. Each project profileand shirt size in cube 2 can have multiple rows one for each server class.
For eg if Project A in cube 1 has a project profile that has 2 rows in cube 2 , i would need to load 2 rows in cube 3.

I am trying to write a TI process .

Appreciate your help

This is not going to be a straightforward task in TM1. If this was SQL you could do this quite easily with UPDATE..SET..WHERE logic. Unfortunately, this does not exist in TM1. You have to update every single cell individually using a CellPutN command. What you are going to have to do is have TWO processes. In the first process you will have a view of cube 1 consisting of all the projects you want to process. For each project you process, you will need to create a view on cube 2 that filters to only the project and server classes you want, then shell out to the second process, which has that newly configured view as it's data source, and write to all applicable server classes.

FYI, you're not going to be able to do this with the TI wizard. You'll have to do it manually.

Thanks Tom !

i am not clear on one part. I do need some dimension elements from cube 1 to be loaded into cube 3.
Once i create a dynamic view of cube 2 based on the projects from cube 1 how do i grab some of the dimension elements from cube 1 to be loaded into cube 3.

Could you please clarify.

Please read what Tom has said again:

What you are going to have to do is have TWO processes. In the first process you will have a view of cube 1 consisting of all the projects you want to process. For each project you process, you will need to create a view on cube 2 that filters to only the project and server classes you want, then shell out to the second process, which has that newly configured view as it's data source, and write to all applicable server classes.

Thanks Tom!, Thanks Abdul!. i got the idea.