TM1 Perspectives and the clipboard error

Post Reply
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

TM1 Perspectives and the clipboard error

Post by Wim Gielis »

Hello,

Could someone indicate me what I'm doing wrong in the below description ?
Or what I could do to improve this very sad "behaviour" ?

Excel 2013, 32 bits
TM1 10.2.2.4
Win 7, 64 bits

I have a Period dimension in TM1 (elements P01 to P12 let's say) and I want to add the month name (Jan ==> Dec) as an alias - without typing the names but rather copy/paste from Excel.

1. Open up Excel from scratch, including the TM1 Perspectives add-in. No Excel sheets are open.
2. Log on to a TM1 model
3. In Excel, I hit Ctrl-N to open a new empty workbook.
4. In cell A1 I type: Jan, and fill down 12 cells to have the short month names. I want to copy these to an alias on a Period dimension in TM1.
5. I press Ctrl-C to copy the 12 cells, I get the well-known error message: "We couldn't free up space on the Clipboard. Another program might be using it right now."

Any comments on this ?

Thanks !
Clipboard error.PNG
Clipboard error.PNG (14.29 KiB) Viewed 3706 times
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
deepakjain2020
Regular Participant
Posts: 152
Joined: Sat May 25, 2013 10:32 am
OLAP Product: TM1
Version: 9.5.2; 10.2.2
Excel Version: 2007

Re: TM1 Perspectives and the clipboard error

Post by deepakjain2020 »

Hi Wim,

Can you please try option shown in below url

http://superuser.com/questions/703767/e ... am-might-b

Regards,
Deepak Jain
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 Perspectives and the clipboard error

Post by Wim Gielis »

Thank you, I will have a look at it.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
MVP
Posts: 3240
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: TM1 Perspectives and the clipboard error

Post by Wim Gielis »

That simple change appears to be working... Me happy :-)
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply