Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Sage MAS Partner
cherylr
Posts: 23
Registered: 12-02-2008
0

Exporting from BI

Does anyone of a microsoft patch that will allow Business Insights version 7.2 export to excel when using Office 2010?  I know with prior versions of MAS, when you used Office 2007, you just needed to download the Office web components.  I tried downloading the Office web components, but that still would not allow the BI to export to excel.

 

Thanks.

 

Cheryl

Sage MAS 500 Customer
Ralph
Posts: 553
Registered: 10-29-2008
0

Re: Exporting from BI

Just out of curiosity, does Exporting offer any benefit compared to Ctrl-A>Ctrl-C>Ctrl-V (SelectAll>Copy>Paste)?  For example, does Copy&Paste bomb when the amount of data in the BI report exceeds a certain percentage of RAM?   I'm just trying to understand why someone would use the Export function as opposed to Copy&Paste.  I'm guessing there is at least one reason and I just haven't encountered the particular situation yet.

Sage MAS 500 Customer
oyama
Posts: 236
Registered: 05-19-2009
0

Re: Exporting from BI

I am curious too. The export function seems to be slow comparing with the Copy + Paste.

Sage MAS 500 Customer
DGill
Posts: 218
Registered: 11-06-2008
0

Re: Exporting from BI

Copy + Paste is faster and you get the columns you selected instead of every column in the view.

Sage MAS 500 Customer
Ralph
Posts: 553
Registered: 10-29-2008
0

Re: Exporting from BI

After watching the What's New In 7.4 video today, I now know of a reason to use the export function instead of Copy&Paste... in 7.4.    It looks like if you export to Excel in v7.4, it will include the alternating row shading that is seen in BI for appearance and ease of reading.

Sage MAS 500 Customer
DGill
Posts: 218
Registered: 11-06-2008
0

Re: Exporting from BI

Oh Ralph, stop drinking the Koolaid.

 

I'll still go with <CTRL><C>.....<CTRL><P> into Excel...Format As Table option

Sage MAS 500 Customer
Ralph
Posts: 553
Registered: 10-29-2008
0

Re: Exporting from BI

Well dang it, Dan, I'm tryin'!  :smileyvery-happy:  There has to be some reason why the "Match data in BIE display when exporting to Excel" suggestion has 40 votes, right?.  :smileywink:

Sage MAS Partner
cherylr
Posts: 23
Registered: 12-02-2008
0

Re: Exporting from BI

Thanks everyone. 

 

I suggested that they use the copy and paste for now, since they are not upgrading, and it is working.  Not sure why I didn't think of it. :smileyhappy:

 

Cheryl

Sage Employee
manookian
Posts: 84
Registered: 07-06-2009
0

Re: Exporting from BI

The row shading was removed from the 7.40 GA release cause some beta customers indicated the shaded rows were difficult to read.

Sage MAS 500 Customer
DGill
Posts: 218
Registered: 11-06-2008
0

Re: Exporting from BI

Told ya Ralph!!!