To be able to restrict access to which cubes BI users are able to report on. Currently users have to given full access to all BI reporting data, even if available reports are restricted they are still able to create new reports on any data cube.
Tom Blatchford
over 6 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
BI Data Warehouse database should be created with the Recovery Model that is set on the Model database
When creating a brand new data warehouse database it is configured to use the Full Recovery model. It should be created with the recovery model that is set on the Model database. If I create a brand new database it takes recovery model set on the ...
Richard Cunningham
about 7 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
We have a customer that has created a BI report but he has to manually refresh it for every company they have. Having built-infunctionality to run BI reports for multiple entities would massively decrease his workload.
John Dunn
over 7 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
Currently Memo Accounts are not available to use in Sage 200 BI. Only group and posting accounts are shown. Memo accounts are present in the Data warehouse. Can these be added for future use?
Allow correction of foreign currency receipts in Sage 200
It is currently impossible to make a correction to a foreign currency receipt, or to reverse one. However it is possible to reverse the allocation & thus reverse any revaluation that would have occurred. The user then has to manually post a pa...
As many Sage 200 customers have been using Business Intelligence for potentially several years now there is no way to remove/shrink the size of the database for it other then creating a new database which then looses the As At cube information
Andrew Siddles
almost 7 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
At the moment we can only use Product Group Code, which is fine for me as I can remember which is which. But my Directors want to see sales by Product Group Name, can this be added into a Cube?
Catherine Bywater
over 7 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
Original budget values not available in Business Intelligence
On the Winter 2017 enhancements a new feature was introduced for Original budget values on nominal accounts. It seems this is not currently available in BI.
Jamie Davies
almost 8 years ago
in Business Intelligence
0
Idea Accepted - Gauging Support
When you make an amendment to a reference on the Sales Ledger it does not get updated on the cashbook. Is it possible to update this so that it can update?
