scripting - If I used views for my SSAS DSV, can the relationships in SSAS Data Source View be scripted? -


I have an SSAS 2005 cube based on a data source view included in the views of tables with relationships in relation I did not use schema binding. Now I need to rebuild two projects with these projects, but there is a fear to add ideas and facts to DSV again. Is there any script that will re-establish or remember relationships, or do I have to make in the relational layer, or should I be in tables during the construction of the cube? Thanks very much Drew

Regarding your question, what happened to the original DSV? DSV is ultimately just an XML file. If you check your project folder, then it is the Analysis Services data source view file with the .dsv file extension file. So if you only want to recreate cubes and dimensions, then just add your original DSV to the new project and it should work as you make a new project from scratch.

Using ideas as a source is usually better than using simple tables because you can use table locking signals like NOLOCK. In addition, you can modify the underlying view without changing the DSV.


Comments

Popular posts from this blog

Eclipse CDT variable colors in editor -

AJAX doesn't send POST query -

wpf - Custom Message Box Advice -