What is the best way to setup a demo database?

Ian Bradley

We would like to setup a demo copy of our database where we can demo to user groups but mask customer data. Is there a best practice way to achieve this?

Samson Sunny

Hi Ian,

You can create a Database Security profile and use the Cube visibility feature where you can set the access level of the cubes to "No Access". Users associated with this Cube access level will not have access to the data displayed in the Screen objects.

To know more about the Database Security and Cube Visibility sections you can go through them in the Board Manual:

https://www.boardmanual.com/2021/summer/data-modeling/2_Database_design_functions/11_Database_security/the-database-security-section.htm?rhsearch=security%20profile&rhhlterm=security%20%E2%80%9Csecurity%20profiles%20profile%20profile%E2%80%9D

https://www.boardmanual.com/2021/summer/whats-new-release-notes/2022-summer-release/main-features/cube-visibility.htm

Thanks,
Samson.

Ian Bradley

When I do this we can't demo the functions of the data model. Essentially I'd like to just mask customer and rep names etc.

I tried creating a new model to copy data to and then load different descriptions, but the transporter package won't copy it as the original model was built before version 11.

Are there any other suggestions

Federico Cazzalini

Dear @Ian Bradley

with which version was built the database you want to start from?

in the past there was a dedicated tool, the "Board Randomizer" - but it worked only with Board 10. (open an idea and ask for it also in Board 12 and upcoming versions!)

Basically, with Board 12, your way of work is the right one: upload a different description.

Best Regards,

federico

Ian Bradley

We have decided to go with using the language functionality, using a language we don't currently use. That way we can use our production database and switch the language of the presenter. We're not showing standard board menu options only ones we've defined on the screens so this should work perfectly for our purposes.

Federico Cazzalini

great workaround (and suggestion) !!

thanks for sharing with us :)

Ian Bradley

Would be great if we could actually define our own language just for entities