Pasting values in Excel to DBRW

Post Reply
Lewis
Posts: 31
Joined: Thu Jul 17, 2008 6:03 pm
OLAP Product: Cognos Tm1
Version: 952 FP1 [prod]
Excel Version: 2007 2010

Pasting values in Excel to DBRW

Post by Lewis »

I think (?) this worked for me the other day but is not today .

Copied a range of data and paste as values to range with dbrw formulas -
not working today - it will work if I copy and paste to one cell .

Thanks
Lewis

Excel 2003 - Tm1 9.0 client - 9.1.0 sp3 server
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Pasting values in Excel to DBRW

Post by Alan Kirk »

Lewis wrote:I think (?) this worked for me the other day but is not today .

Copied a range of data and paste as values to range with dbrw formulas -
not working today - it will work if I copy and paste to one cell .

Thanks
Lewis

Excel 2003 - Tm1 9.0 client - 9.1.0 sp3 server
That's the way it's always been; if you copy a value and paste it into a single DBRW cell, it'll send that value to the cube and leave the formula intact. Do it with a multi-cell range and it'll overwrite the formulas. This has always infuriated me because (a) it's not documented, and (b) it's inconsistent behaviour between single and multi-cell ranges.

If you need to that kind of copy and paste, grab a copy of TM1 Tools add-in from http://www.tm1forum.com/viewtopic.php?f=21&t=2515
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Lewis
Posts: 31
Joined: Thu Jul 17, 2008 6:03 pm
OLAP Product: Cognos Tm1
Version: 952 FP1 [prod]
Excel Version: 2007 2010

Re: Pasting values in Excel to DBRW

Post by Lewis »

Alan

This is great ! just what I need + the extra tools

Thanks again

Lewis
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: Pasting values in Excel to DBRW

Post by mnasra »

Hello,

I have the exact same problem - I need to do a Paste to multiple cells and it override the formula.
I saw the suggestion about grabbing an extra add in, but the hyperlink is not working.

"If you need to that kind of copy and paste, grab a copy of TM1 Tools add-in from viewtopic.php?f=21&t=2515"

THANKS a lot

Micheline
Thanks
Micheline
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Pasting values in Excel to DBRW

Post by Alan Kirk »

mnasra wrote:Hello,

I have the exact same problem - I need to do a Paste to multiple cells and it override the formula.
I saw the suggestion about grabbing an extra add in, but the hyperlink is not working.

"If you need to that kind of copy and paste, grab a copy of TM1 Tools add-in from viewtopic.php?f=21&t=2515"

THANKS a lot

Micheline
That link was posted before we changed names from OLAPForums to TM1Forum, and the change broke it. I've edited it to include the current link; try it again now.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: Pasting values in Excel to DBRW

Post by mnasra »

THANKS,
It worked perfectly.

Micheline
Thanks
Micheline
Ernie
Posts: 1
Joined: Thu Mar 28, 2013 8:53 am
OLAP Product: Congos Express
Version: 10.1
Excel Version: 2010

Re: Pasting values in Excel to DBRW

Post by Ernie »

Hello

Unfortunately, the TM1 tools paste function doesn't work in Active Forms. At least for me.

regards

Ernest
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Pasting values in Excel to DBRW

Post by Alan Kirk »

Ernie wrote: Unfortunately, the TM1 tools paste function doesn't work in Active Forms. At least for me.
OK, I know why that is. The cube reference for the active form is created using a TM1RPTVIEW() function rather than ye olde traditional VIEW() function. As a result the value that it returns is the name of the active form within the sheet rather than just the cube; for example rpo:RevenueAndStats:1 or rpo:RevenueAndStats:ARPT1. DBRWs are fine with this. DBSW's (which are used by the Bulk Paste function to send the numbers to the cube) are not, though DBS's are... if they are evaluated cell by cell and not via the normal [F9] functionality. Whether or not this constitutes a bug in the Excel client is in the eye of the beholder, and how charitably disposed one is to IBM.

{Dead silence aside from some crickets chirping...} OK, I'll say it then... :evil:

Off the top of my head I can think of a couple of different ways that I can fix that but I'll need to play around for a bit and see which one will be the least expensive in terms of processing time.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
tobtm1
Posts: 19
Joined: Tue Feb 17, 2015 1:01 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2010

Re: Pasting values in Excel to DBRW

Post by tobtm1 »

Hi Alan,

I have just completed the installation of TM1 Tools and the customer is really happy with (almost) everything... ;)

What is really crucial is that they need to be able to do the "bulk paste" in active forms and I found this thread and read your last post... Did you come up with a solution?

Sorry, I just have to ask so I know if the customer needs another way of working or not.

Thanks for any answers.

BR
chewza
Posts: 146
Joined: Tue Aug 17, 2010 11:51 am
OLAP Product: TM1
Version: 9.5
Excel Version: 7

Re: Pasting values in Excel to DBRW

Post by chewza »

Hi Guys

Any further news/developments RE pasting into an Active Form?

Many thanks!!

Chris
Post Reply