Sage 200cloud Help Series: How do you refresh data in a BI report?

Posted by Marek Golinski on 29-Aug-2018 11:22:49

In order to run a BI Report, you will first have to create a new Data Warehouse using the Sage 200cloud BI Admin utility, which you will find in All Programs > Sage Tools > Sage 200 > Sage 200 Business Intelligence as below:

Once open, you will see listed the name of the company you want to create a warehouse for. To create it, click on that company, and click the “New Warehouse” button. 


Next you will see this screen, fill this in and press OK.


Then you get this screen: 



Now Press OK.


You can create the scheduled task for nightly cube refresh later as a separate exercise.


When finished it takes you back to this screen, and please note you have now created the warehouse and it is ready for you to run the BI reports.


If you now log into Sage 200cloud – into that company “Marek” which you created, you can now run a BI report – just go into “Business Intelligence” in the left menu > Finance > Balance Sheet Analysis: double click to open , and Excel will open the report for you:


If you would like to know more about Sage 200cloud or any of the Sage products we offer, please fill out the form below and a member of our team will be in contact: 

Alternatively, contact us here.

Topics: Sage 200cloud, Sage 200, Support, Acuity Support, Help Series, Acuity innovation, Innovation

Regular Insight and Updates from Acuity

Industry News and Knowledge sharing regarding Sage Solutions

Acuity Blog series, providing regular information to the UK and Global community.

Topical Blog's covering:

  • Sage Support series for Sage 200, Sage 300 & Sage X3
  • Information from the Team at Acuity, leading provider of Sage Solutions in the UK
  • Contact us for more information, or join the conversation

Subscribe to Email Updates

Recent Posts

Posts by Topic

see all