How to implemet ROLAP and HOLAP in ssas (What are the steps)?

Vishakha Singh 1 Reputation point
2020-12-17T07:21:33.19+00:00

I am new to SSAS. my requirement is my one Fact table(Eg Table A) continuously insert the new entries as it is a Production( Live data) and other tables (Eg Table B) contains getdate-1 data . Hence not able to apply the MOLAP on (table A) . I have read the concept of ROLAP and HOLAP but not able to implement this.

I am not finding any relevant source or video's for reference. Please help

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,790 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,245 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,996 Reputation points
    2020-12-17T07:31:21.343+00:00

    I am not finding any relevant source or video's for reference

    See Partitions - Partition Storage Modes and Processing, it's mainly the property "StorageMode" for dimensions; but not for measures, as it seems you are looking for.

    0 comments
  2. Lukas Yu -MSFT 5,816 Reputation points
    2020-12-17T08:23:13.967+00:00

    Hi,

    If you want to video tutorial and introduction, I think this one is easy to understand : SSAS - Partitioning - MOLAP, ROLAP, HOLAP

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    What can I do if my transaction log is full?--- Hot issues November
    How to convert Profiler trace into a SQL Server table -- Hot issues November