Reinhard Erb
  • Male
  • Brisbane, Queensland
  • Australia
Share

Reinhard Erb's Friends

  • Stephen Coull
  • Brynn Furmidge

Reinhard Erb's Groups

Reinhard Erb's Discussions

Power View Woes
4 Replies

I have been having issues getting power view to work. I am running Excel 2013 (32-bit). My raw data is just under 100k rows with 20 columns. (Please note this is a summarised as I can get it without…Continue

Started this discussion. Last reply by Shwu Hua Gan May 27, 2014.

Power View - Not a valid Data Source
2 Replies

How can I select my entire data tab created from SAI without getting the above error. The only way I can see is by selecting a subset of rows and columns. IF I select the RawDataCol range nothing is…Continue

Started this discussion. Last reply by Reinhard Erb May 23, 2014.

SQL Time Out Error
4 Replies

Does anyone have any idea how to get around a SQL time out error when running a report from a newly created connector?Continue

Started this discussion. Last reply by Reinhard Erb May 21, 2014.

SQL Expression being interpreted as Date in Excel - How to stop it
2 Replies

I have a SQL expression in my container as followsCAST([ICHIST].[TRANSTYPE] AS CHAR(2)) +'-'+ CAST(isnull ([LSADJ].[LSADJTYPE],'') AS CHAR(1))This will produce a text field such as 10-1On running the…Continue

Started this discussion. Last reply by Reinhard Erb Apr 4, 2012.

 

Reinhard Erb's Page

Latest Activity

Peter Scully replied to Reinhard Erb's discussion Pivot Table Issue on saving as a template in Alchemex
"Thanks Gabriela."
Apr 26
Gabriela Yates replied to Reinhard Erb's discussion Pivot Table Issue on saving as a template in Alchemex
"I also got Error Number: [1004] SaveAs method of Workbook class failed . This happened when trying to save the template back to Report Manager. It turns out that my Report Name had a slash in it. This was automatically putting a slash in the…"
Apr 25
Reinhard Erb replied to Michale Frogge's discussion Max number of databases for consolidation
"I have written reports consolidating 58 datasets in Sage Intelligence. The only issue I have run into is ensuring that the users use Excel 2010 or above to ensure they have more than 64k of rows."
Sep 2, 2016
Peter Scully replied to Reinhard Erb's discussion Pivot Table Issue on saving as a template in Alchemex
"Hi Francois. FixTemplates.exe can be found in C:\SageIntelligenceReportingXX\UR I found the following KB articles on error 1004. The one suggest repairing Excel which you may want to try…"
Dec 8, 2014
Francois Tremblay replied to Reinhard Erb's discussion Pivot Table Issue on saving as a template in Alchemex
"Hello Tyrone, I have the same error 1004. I went on the knowledge base and it doesn't tell where to get  the fixtemplate.exe file. My customer uses Excel Professional 2010, even when saving in an Excel Workbook 97-2003, we still get the…"
Dec 5, 2014
Reinhard Erb replied to Melissa C's discussion Creating OE Weekly Activity/change report
"This info does not exist in the standard accpac tables. You would need the Audit Logger program from Pacific Technology."
May 30, 2014
Shwu Hua Gan replied to Reinhard Erb's discussion Power View Woes
"Hi Reinhard, Which version of Sage 300 are you on?  I thought the latest service packs does work with 64 bits for Sage 300 ERP 2012."
May 27, 2014
Reinhard Erb replied to Reinhard Erb's discussion Power View Woes
"Yes I do have 32-bit Excel - unfortunately Sage 300 will not work with 64bit. Any ideas on how to get the 32bit working? "
May 27, 2014
Ruth Gray replied to Reinhard Erb's discussion Power View Woes
"Hi Richard It could have something to do with 32bit Excel that it is hanging. If you’re seeing query execution failures when you try to work with Power View in Excel, it might be because you’ve installed the 32-bit (x86) version of Excel…"
May 26, 2014
Candace Dixon replied to Reinhard Erb's discussion Power View Woes
"Have you tried doing a power view on a separate workbook using a smaller range. if it stills hangs could be excel issue, try repair it"
May 26, 2014
Reinhard Erb posted a discussion

Power View Woes

I have been having issues getting power view to work. I am running Excel 2013 (32-bit). My raw data is just under 100k rows with 20 columns. (Please note this is a summarised as I can get it without losing the detail I need to report on - un summarised I have over 1 million rows) Extracting to the raw data sheet from SAI only takes 2 minutes)When selecting my RawData range and clicking Insert - Power View, I get a dialog box OPening Power View saying Working on opening Power View sheet. Excel…See More
May 26, 2014
Reinhard Erb replied to Reinhard Erb's discussion Power View - Not a valid Data Source
"I am still not getting it - that is on 3 different excel installations. Selecting the columns or the RawDataCol gets me a "Please select a valid data range" - I need to select the rows only - then it works. The problem I have is my data…"
May 23, 2014
Nigel Naicker replied to Reinhard Erb's discussion Power View - Not a valid Data Source
"Hi, I am able to create a power view report of RawDataCol as the option to insert >power view is available for me. i have attached a power view report that i created, try to get power view open and working on this report, i know it works fine on…"
May 22, 2014
Reinhard Erb posted a discussion

Power View - Not a valid Data Source

How can I select my entire data tab created from SAI without getting the above error. The only way I can see is by selecting a subset of rows and columns. IF I select the RawDataCol range nothing is available to power view on, if i select columns only I get Not a valid data source. How do you get around this when your data source range is going to be dynamic and you want all the columns in the data sheet?See More
May 22, 2014
Reinhard Erb replied to Reinhard Erb's discussion SQL Time Out Error
"I glad as well - i didnt know how I was going to get the data I needed other wise."
May 21, 2014
Ruth Gray replied to Reinhard Erb's discussion SQL Time Out Error
"Great, glad that is sorted."
May 21, 2014

Profile Information

Sage Intelligence powers the following Accounting/ERP/Payroll solutions, pick yours
Sage Accpac Intelligence
Website
http://www.heritage.net.au
Where did you hear about us?
Other

Comment Wall (2 comments)

You need to be a member of The Sage Intelligence Community to add comments!

Join The Sage Intelligence Community

At 7:50am on February 25, 2010, Stephen Coull said…
Hi Reinhard, welcome to the BI COmmunity and looking forward to contributiuons and trust that you will learn plenty
At 5:33pm on February 5, 2010, Ruth Gray said…
Welcome to the BI Community.

We look forward to your contribution.
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service