1

Topic: Inquiry: you use what model SSAS - tabular or multidimentional?

You use what model SSAS - tabular or multidimentional?
Whether there are plans to pass with one to another and if is, why?

2

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

The multidimentional
To pass plans is not present, as and so all works

3

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

Any it is not used, and to use plans is not present

4

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

TJ001;
So a questionnaire fasten

5

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

Both

6

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

The multidimentional. At us the standard , also is fears that in tabular all does not get after a while.

7

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

s_ustinov wrote:

Multidimentional. At us the standard , also is fears that in tabular all does not get after a while.

And on great volumes of a brake and the price list receive

8

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

Alex_496 wrote:

it is passed...
And on great volumes of a brake and the price list receive

?
I looked standard restrictions - there storage is restricted. Whence brakes and the price list undertake?

9

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

s_ustinov wrote:

it is passed...
?
I looked standard restrictions - there storage is restricted. Whence brakes and the price list undertake?

Std Ed I do not consider. For small volumes and the desktop-krutilok suffices

10

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

TJ001;
The multidimentional
Plans on passage are not present, for are not present in  reverse notation

11

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

Alex_496 wrote:

it is passed...
And on great volumes of a brake and the price list receive

Rarely here I come but each time I am surprised as discussions are conducted - often  very doubtful announcements, and without any argumentation are declared. Though, answers normally same))) Probably, because of it rarely also I come))))
This year there was entertaining enough official rate from a microsoftware on EDX
Microsoft: DAT224x Developing a Multidimensional Data Model
Under the link the unit of this course with rather accurate arguing of this favourite by many to subject
Selecting the Right Model Type
Where, as the singularity of multidimentional model, is considered possibility of scalability to terabytes.
As the example is resulted that 24  a cube yahoo with 2  storage.

12

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

Evolex _;
All the same the turbid criteria and much is not clear
1. Whether there are any useful calculations which can be made in Multidimensional and which in essence are not implemented in Tabular and on the contrary?
2. Admit volume of storage some hundreds gigabyte. What will be faster? What will be more economic from the point of view of the budget?
3. Why the Microsoft threw development MOLAP and whether it plans to return to it?

13

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

bideveloper;
To me here these questions, on first of which for a long time and well answered , seem in times more turbid than that that in course is stated

14

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

Evolex _;
Present itself on a place of the customer.
It has a certain budget and approximate understanding of volume of storage and demanded high-speed performance.
How to it to select, what model to use?

15

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

bideveloper;
Probably, first of all, to find the adviser before whom there are no questions which answered about 80 years ago.

16

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

Evolex _;
It is Generally clear that under calculations I meant calculations with comprehensible productivity, instead of  )
And certain types of calculations in one model can be much more effective, than in another.
And you carp at the form, and from an essence evade. Means do not know.

17

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

bideveloper;
And about 100 years ago Young formulated that that correctly brought attention to the question gives 50 % of the decision.
I normally offer people who want to guarantee with someone to do the most part of these first 50 % of the decision to communicate with sellers - they and money for it are able to take is better and is cheaper, probably will be in the total is not technical questions generally.

18

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

For some tasks the relational model, for others - multidimentional is better approaches. Traditionally users Qlik suffer without multidimensionality, and users SSAS - without . Therefore it is necessary to use  BI the decision in which both approaches get on. Thus at MS a quite good relational DBMS for registration systems and data stores, here questions are not present.

19

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

The tabular.
While suffices.

20

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

In two places where worked, both models are used.

21

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

Jurii wrote:

and users SSAS - without

Yury, it is possible to ask  to explain you more in detail this point?

22

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

tashkafox wrote:

In two places where worked, both models are used.

It it is necessary to pay many money for licenses

23

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

Jurii wrote:

and users SSAS - without

And as users  (pivot tables) without  suffer... smile))

24

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

wrote:

it it is necessary to pay many money for licenses

The first place - . with special model of licensing of type "take that you want". Licensing questions  me the side, therefore I can not tell more in detail.

25

Re: Inquiry: you use what model SSAS - tabular or multidimentional?

tashkafox wrote:

In two places where worked, both models are used.

In what see advantages of this or that model?