creating cubes in excel?

Post Reply
KRISHNA
Posts: 6
Joined: Fri Oct 01, 2010 11:06 am
OLAP Product: cognos tm1
Version: 9.4.1
Excel Version: 2007

creating cubes in excel?

Post by KRISHNA »

hi
1)is it possible to create cubes in excel
2 )how to create cube for data directory?
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: creating cubes in excel?

Post by kpk »

1. You can create cube with TI. You can use action button to run TI process from Excel or from websheet.
2. I do not understand the second question.
Best Regards,
Peter
KRISHNA
Posts: 6
Joined: Fri Oct 01, 2010 11:06 am
OLAP Product: cognos tm1
Version: 9.4.1
Excel Version: 2007

Re: creating cubes in excel?

Post by KRISHNA »

kpk wrote:1. You can create cube with TI. You can use action button to run TI process from Excel or from websheet.
2. I do not understand the second question.
hi,
directly cant we create cube in excel? and

my 2nd question is "i need to create cube for data directory"of TM1 server ,is it possible ?
kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: creating cubes in excel?

Post by kpk »

KRISHNA wrote:
kpk wrote:1. You can create cube with TI. You can use action button to run TI process from Excel or from websheet.
2. I do not understand the second question.
hi,
directly cant we create cube in excel? and

my 2nd question is "i need to create cube for data directory"of TM1 server ,is it possible ?
There is no Excel solution for creating cubes in Excel like XDI for dimensions or XRU for rules.
Best Regards,
Peter
KRISHNA
Posts: 6
Joined: Fri Oct 01, 2010 11:06 am
OLAP Product: cognos tm1
Version: 9.4.1
Excel Version: 2007

Re: creating cubes in excel?

Post by KRISHNA »

thanks q kpk.
lotsaram
MVP
Posts: 3661
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: creating cubes in excel?

Post by lotsaram »

Not sure I understand the question either as what exactly is meant by "creating cubes in Excel"?

With administrator privileges this can be done quite easily in Perspectives server explorer (the TM1 add-in for Excel). Just right-click "cubes" and select "create new cube". In my definition this would qualify as "creating a TM1 cube in Excel."
Post Reply