Page 1 of 1

Table on TM1

Posted: Wed Jan 31, 2018 1:43 pm
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

Re: Table on TM1

Posted: Wed Jan 31, 2018 6:00 pm
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?

Re: Table on TM1

Posted: Wed Jan 31, 2018 11:15 pm
by macsir
Table is just two-dimension cube in TM1. Yes, you can.

Re: Table on TM1

Posted: Mon Feb 05, 2018 5:11 pm
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