Home Dashboard Directory Help
Search

Implement display folders in SSAS tabular models through SSDT by Paul Turley


Status: 

Active


7
0
Sign in
to vote
Type: Suggestion
ID: 841253
Opened: 3/26/2014 9:44:02 AM
Access Restriction: Public
0
Workaround(s)
view

Description

Having support for display folders is critical in large models and should be a native feature to support a formal build process. Using the BIDS Helper third-party tool to add folders works when manually deploying a model from the development environment but does not address scripted and automated deployment scenarios.

In our daily build cycle, every application component in our solution is built and deployed directly from checked-in TFS projects. When the tabular model is deployed from the latest .asdatabase file using XLMA script, it does not include display folder definitions. This requires the deployment administrator to make an exception by opening the project in Visual Studio/SSDT and then manually deploying to a temporary location to invoke BIDS Helper. The deployed database is then scripted and added to the solution build for packaged deployment.

Deployment automation is important. Our solution is a large multi-tenant web application with integrated analytics and reporting. We make frequent changes to the model definition which is replicated to many AS databases. The model contains hundreds of measures so display folders are needed to provide a good user experience.
Details
Sign in to post a comment.
Posted by Joseph Milner on 3/26/2014 at 10:15 AM
This is a critical issue we are facing. We need the ability for the display folders to be supported in our build process, in order to get them out smoothly to production.
Sign in to post a workaround.