Hi friends,

Is is possible to restore tabular ssas database as multidimensional database ?

more ▼

asked Aug 12, 2017 at 01:57 AM in Default

avatar image

81 1 4 11

@rehaan From what I know, this is not possible. Tabular and multidimensional are different semantics of SSAS. In fact, you can have only one or the other per instance (determination is made at installation time). Tabular calculations are done with DAX while multidimensional with MDX. There is no way to restore tabular as multidimensional, the multidimensional will have to be created from scratch using the same source. The calculations will be pretty easy to translate from DAX to MDX, but the dimensions, facts, and the cube, along with it dimension usage specifications, need to be created.

Aug 14, 2017 at 01:16 PM Oleg

Thanks Oleg for your help. I will try and recreate then

Sep 01, 2017 at 09:10 PM rehaan
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Aug 12, 2017 at 01:57 AM

Seen: 26 times

Last Updated: Sep 01, 2017 at 09:10 PM

Copyright 2018 Redgate Software. Privacy Policy