I've discussed that with a customer but with the resulting databases being distributed to different servers, thus implemeting the cluster. In that particular case we decided otherwise. And--just like Sebastian Gurt mentioned--I've only implemented that for test cases on my local machine with a really small database.

I did once discuss the idea (but did not implement!) of distributing child databases to a sales team for offline use. You could run a master database on your central board server and use the data mart function to create child databases along an entity (e. g. sales representative). These child dbs (containing only their slice of the data) would then be distributed to the user clients. The clients would run their own board environment and would be able to work "offline".

Another use case could be, to quickly create a smaller copy of your database, that only contains a portion of the data (e. g. for testing purposes with only one year of data).

But to really answer your question: besides showing the function in trainings I am not using it :-)

I wouldn't call it synchronization as it only works in one direction (it is only a copy from the original db with the different options to create slices by time, by entity, by user profile, ...).

Etienne CAUSSE wrote:

I have been wondering if this kind of use could help us in managing some contradictory access rights that might be requested, as mentioned in other topics.

A copy of a single slice in a separate DB could allow access through a different DB profile, for the same user ?

I did not try or even think about something like that yet - but it sounds interesting. In theory it should work. As the datamart function creates a new database with a new name you could have a different db profile assigned for this database.

Contact BOARD

Discover BOARDVille

Follow us

BOARD is an all-in-one
Corporate Performance Management and Business Intelligence software solution that makes it easy to build any
business analytics and planning applications without coding. BOARD offers all the
functionalities, tools and analytic capabilities needed to quickly create
dashboards, reports and self-service analyses fully integrated with
enterprise planning and simulation processes. BOARD is included in Gartner's
“Business Intelligence & Analytics” Software Vendors and “CPM Suites” Magic Quadrants. Recent comparison reports have rated
BOARD the best product for Overall Customer Satisfaction among a
comprehensive list of BI and CPM software vendors. Compare our customer list and case studies to discover more about the benefits of the best in class decision making platform.