Table on TM1

Post Reply
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Table on TM1

Post by Jorge Rachid »

Hi all,

I need to replicate a table from excel on cognos tm1. Most part of data is just copy and paste, but I don't have any column of this table that could be used as "key" for a dimension considering that many fields need to be repetead.

In this case the best option to replicate those rows of the table is creating a dimension with sequential numbers?

Thanks in advance guys,

JR
David Usherwood
Site Admin
Posts: 1453
Joined: Wed May 28, 2008 9:09 am

Re: Table on TM1

Post by David Usherwood »

You can certainly use a sequential dimension to capture your data. But since your content doesn't seem to work well in TM1, can you explain what you are going to do with it?
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Table on TM1

Post by macsir »

Table is just two-dimension cube in TM1. Yes, you can.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Jorge Rachid
Posts: 113
Joined: Fri Jul 22, 2016 8:33 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2013

Re: Table on TM1

Post by Jorge Rachid »

hi,

tks for the reply. My content works well on tm1. The only point is that I do not have any filed that can be used as a key information to build the rows, so I will create a sequential dimension.

Thanks,

JR
Post Reply