Forum Discussion

szelenko's avatar
szelenko
Frequent Visitor
5 years ago
Solved

Recommended Approach for Large Project

Hello friends, im currently working in a large project for an insurance company. Until now i got approx 10 dimensions and 8 fact tables.   Dimensions (some of them) - Date - Customers - Locati...
Need Help
  • littlemojopuppy's avatar
    littlemojopuppy
    5 years ago

    I had a similar project...about 50 tables, 800 measures, 50M records.  I developed the data model in Azure Analysis Services and used that as the source for dozens of individual reports.  Simplified maintenance since measures were all centrally located, performance was adequate (used S0 AAS so it was kind of a weakling, but later upgraded to S1).  That may/may not be an option for you, but if possible it's worth looking at.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi szelenko ,


Could you tell me if your problem has been solved?
If it is, kindly Accept it as the solution. More people will benefit from it.
Or you are still confused about it, please provide me with more details about your problem.


Best Regards,
Stephen Tao