question

rehaan avatar image
rehaan asked

SSAS Cube

Hi friends, Is is possible to restore tabular ssas database as multidimensional database ?
backup-restoressas-tabular
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

@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.
1 Like 1 ·
Thanks Oleg for your help. I will try and recreate then
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.