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
Table on TM1
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
-
- Site Admin
- Posts: 1453
- Joined: Wed May 28, 2008 9:09 am
Re: Table on TM1
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?
- 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
Table is just two-dimension cube in TM1. Yes, you can.
-
- Posts: 113
- Joined: Fri Jul 22, 2016 8:33 pm
- OLAP Product: TM1
- Version: 10.2
- Excel Version: 2013
Re: Table on TM1
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
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