It seems you need to have an history table for some values so that you can use the correct values for the needed date/time for the calculation and then maybe to select a formula from a finite list of formulas depending on some input values or their range
?

It seems you need to have an history table for some values so that you can use the correct values for the needed date/time for the calculation and then maybe to select a formula from a finite list of formulas depending on some input values or their range ?

exactly

if there is no need to use multidimensionnel model, please,what do you advise me for i can design my database? any guid?

It seems to me you just want to retrieve a row from a quantity, network, storage center, flight type table and read a 5th column that gives which formula should be used (maybe as a "key, formulas being part of your code).

Your code will then use this key to call the correct formula. This is really a different formula rather than just some factor that should be changed (possibly being 0 ?). Or cout ie be just the unit price that changes depenbing on that...

These do not seem to be very complex business logic problems. Going multidimensional on this is going to be an overkill. We use multidimensional for heavy duty stuff with a lot of data sauces like hundreds of
IoT and complex logic. At most you I could suggest you to look into Tabular SSAS rather than MD. At the first sight, I would go about this by creating a data mart or even a separate staging tables under its own schema pushing most of
the logic to source and run the queries through stored procedures or simple sql queries.

Member

11 Points

84 Posts

## do i need use multidimensionnel model in this case?

Jan 08, 2018 09:43 AM|bensam16|LINK

Hello

I have to develop a computer application using ASP.NET MVC technology, for the calculation of the JET A1 fuel product prices for the aviation.

I want to know, the way to go for I can do the design of the system. do do i need use multidimensionnel model in this case? what do you advice me?

it should be known that the calculation is done in several stages according to my information.

For step # 1:the user must determine:

For step # 2:On all the data of step 1 the exchange rate is determined.

For step # 3:The calculation of the weighted margin and deduce the applied margin.

For step # 4:On all the data of stage 2 and 3, the price calculation of JET A1, is subordinated for certain formulas according to criteria which are:

see you soon

All-Star

48080 Points

17851 Posts

## Re: do i need use multidimensionnel model in this case?

Jan 08, 2018 01:05 PM|PatriceSc|LINK

Hi,

Not sure to get what you call a multidimensional model (to me it would be rather https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/multidimensional-models-ssas )

It seems you need to have an history table for some values so that you can use the correct values for the needed date/time for the calculation and then maybe to select a formula from a finite list of formulas depending on some input values or their range ?

Member

11 Points

84 Posts

## Re: do i need use multidimensionnel model in this case?

Jan 08, 2018 01:33 PM|bensam16|LINK

thank you for response

exactly

if there is no need to use multidimensionnel model, please,what do you advise me for i can design my database? any guid?

All-Star

48080 Points

17851 Posts

## Re: do i need use multidimensionnel model in this case?

Jan 09, 2018 12:19 PM|PatriceSc|LINK

It seems to me you just want to retrieve a row from a quantity, network, storage center, flight type table and read a 5th column that gives which formula should be used (maybe as a "key, formulas being part of your code).

Your code will then use this key to call the correct formula. This is really a different formula rather than just some factor that should be changed (possibly being 0 ?). Or cout ie be just the unit price that changes depenbing on that...

Member

2 Points

5 Posts

## Re: do i need use multidimensionnel model in this case?

Mar 09, 2018 11:19 PM|Natasha Schuster|LINK

bensam16,

These do not seem to be very complex business logic problems. Going multidimensional on this is going to be an overkill. We use multidimensional for heavy duty stuff with a lot of data sauces like hundreds of IoT and complex logic. At most you I could suggest you to look into Tabular SSAS rather than MD. At the first sight, I would go about this by creating a data mart or even a separate staging tables under its own schema pushing most of the logic to source and run the queries through stored procedures or simple sql queries.

Thanks