COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: newuser on 21 Jul 2010 05:31:02 PM

Title: Creating new Cube in TM1
Post by: newuser on 21 Jul 2010 05:31:02 PM
I am trying to create a new cube in TM1.  Was wondering if I have to create the dimensions first, then choose those new dimensions for the new cube?  I already have several created dimensions for the old cube which I would like to use.  Can I just use those and not mess up my old cube & data.  If you have a step by step instruction manual on how to create a cube in TM1, please send to me.  My email address: viviannq73@hotmail.com.  Much thanks in advance for your help and time.
Title: Re: Creating new Cube in TM1
Post by: OLAPBPMguy on 21 Jul 2010 09:42:26 PM
Assuming you have already created dimensions ....

Step by step guide follows:
1/ right-click "Cubes", select "Create new cube"
2/ select dimensions to include in cube and order of dimensions in cube
3/ click "create cube" button
4/ done.  ;D

No more to it than that.  Maybe a quick read of the manual is in order??
Title: Re: Creating new Cube in TM1
Post by: raviB on 22 Jul 2010 02:08:34 AM
Also you need consider the order of dimension.

-include measure dim last
Order dimension from

-Smallest/Sparse
-Largest/dense

And then,

To Transfer the data into a cube, perform the following steps.
Connect to the source and preview the data.
Create and map variables contents.
Indentify cube, dimensions and measures
Save and execute process.

Regrads,
Ravi
Title: Re: Creating new Cube in TM1- Create new dimension
Post by: newuser on 22 Jul 2010 06:12:04 PM
Thank you and for your help.

Can you show me how to create a new dimension with multiple layers (children / child level) or a very complicate "hierarchy"?  We already have a similar hierarchy created and I like to modify that hierarchy and save as a new hierarchy dimension.  This new hierachy dimension is to be used in my new cube.  Any short cuts you can suggest?

Thanks again for your help

Title: Re: Creating new Cube in TM1
Post by: raviB on 22 Jul 2010 11:07:14 PM
Hi

Do u have the training material?

If not i will send it to u today
pls give me ur mail id
ravi
Title: Re: Creating new Cube in TM1
Post by: RAJ251 on 23 Jul 2010 12:49:46 AM
Hi Ravi,
          can you send the training material to me
          my email id is <email address removed by a muppety moderator to protect you and the site from nasty spammers>
Title: Re: Creating new Cube in TM1
Post by: MFGF on 23 Jul 2010 05:09:56 AM
Quote from: raviB on 22 Jul 2010 11:07:14 PM
Hi

Do u have the training material?

If not i will send it to u today
pls give me ur mail id
ravi

Just be aware that if you are referring to the official Cognos/IBM training course materials, they are copyright and you are not allowed to share them.

MF.
Title: Re: Creating new Cube in TM1
Post by: babjee on 12 Mar 2011 05:36:41 AM
Hi ravi

can u send me cognos tm1 meterial
Title: Re: Creating new Cube in TM1
Post by: jayanthhyd on 01 Oct 2011 02:12:32 AM
Hi Ravi,
Can you send me TM1 material <email address removed by a muppety moderator to protect you and the site from nasty spammers>
Thanks,
Jayanth.