Forum

Adding a static sheet to be included in the pivot data 2 Replies

Started by Gary Vilinsky in Sage 300 ERP Intelligence Reporting. Last reply by Gary Vilinsky 19 hours ago.

Sage BI Addin Not Enabling for non Admin user in Excel 2010 1 Reply

Started by Vineeth Abraham in General. Last reply by Keeveshin Naidoo on Friday.

Pastel Partner V17 Dashboard Report 1 Reply

Started by Sitwell Mukali in Sage Pastel Intelligence Reporting. Last reply by Keeveshin Naidoo on Friday.

Sage 100 Inventory Item Image 1 Reply

Started by Dan St. John in Sage 100 and 500 ERP Intelligence Reporting. Last reply by Keeveshin Naidoo on Friday.

Latest Activity

Gary Vilinsky replied to Gary Vilinsky's discussion Adding a static sheet to be included in the pivot data
"Hi Nigel, Thank you for your reply.  With your suggestion how do I avoid the data being overwritten when the BI report is run again generating the raw data? Thanks, Gary"
19 hours ago
Nigel Naicker replied to Gary Vilinsky's discussion Adding a static sheet to be included in the pivot data
"Hi Gary, if I am understanding you correctly, I don't see an automated way to do this, the only thing I would try  is copy your static data to the same sheet 1 as the Sales Master report, then modify the RawData named range to include the…"
yesterday
Gary Vilinsky posted a discussion

Adding a static sheet to be included in the pivot data

Hi,I am looking for the best way to add a static sheet that needs to be combined with Sage 300 sales data in the same output data.  The static sheet has all the same information as BI sales master report, however, it is coming from another system that can not be connected.  I have tried creating additional fields in the pivot table but can not manage to group the fields together. ie  customer name or item codes.Any insight on how to accomplish this would be apricated.Thank you.See More
yesterday
Keeveshin Naidoo replied to Vineeth Abraham's discussion Sage BI Addin Not Enabling for non Admin user in Excel 2010
"Hi Vineeth, This would most likely be due to User Access Control being active on the machine. Please have a look at the below links to see the issues that this could cause (yours being one of them): - Understanding UAC - UAC in Vista - UAC in…"
Friday
 
 
 

The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2018   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service