Generate relational schema - old tables are always deleted and not recreated

I want to use the top down modelling features and generate tables from the OLAP objects by generating relational schema.

The problem:

First time using the "generate relational schema" - the tables are created.

Next time using this feature: new tables are generated, but all tables created in the past are lost. There is a warning, the schema can't be created, because there are user defined tables.

I found a way to reset this status, if I open the code for a dimension and delete the section from <Source to /Source>:

<Source xsi:type="DataSourceViewBinding" dwd:design-time-name="51a3fe82-65d2-402e-a846-d2b9689b177c">

<DataSourceViewID>LR OLAP</DataSourceViewID>

</Source>

After this I can recreate the tables. But there must be another way. I can't delete the source information from all object before each using of the "generate relational schema".

In the past, when I was evaluating the SSAS 2005, I had no such problems. What happens? Why are the tables deleted each time, if I generate relational schema?

The way you are trying to use Analysis Services is not exactly how it was envisioned originally.

The logic for which tables needs to be created is pretty simple. If object doesnt have bindings, the schema generation wizard will create a table in relational database supporting it.

Now, creating relational database schema is considered one time operation. Analysis Services is not exactly application to use for generating relational schemas. You go through the wizard, it creates all the tables for you and then you expected to keep and maintain set of tables created.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.