Share via

Implementation of OLAP as a relational database

amir krugliak 0 Reputation points
2023-10-12T09:30:41.39+00:00

Hello .

I am looking for a solution to the issue of OLAP cubes in the organization. Right now we have a task of taking one cube and replacing it with Tableau reports. In other words, this means taking an OLAP cube, flattening it into a relational structure so that the same aggregate data that OLAP presents will also be displayed in Tableau report. There is, of course, a solution of saving the data in aggregated tables so that January will contain only the January data and February data will contain the January and February data, and so on, but this is data duplication, which is not correct in my view.

I am Looking for another solution for how to store OLAP data relationally.

I am open for any option available such as keeping the data not in sql server.

Thanks in Advanced,

Amir Krugliak

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,850 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,248 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 41,006 Reputation points
    2023-10-12T10:41:11.8266667+00:00

    Sorry to say, but that all don't make sense.

    flattening it into a relational structure ... be displayed in Tableau report.

    Tableau can utilize OLAP data sources, see https://help.tableau.com/current/pro/desktop/en-us/cubes.htm

    I am Looking for another solution for how to store OLAP data relationally.

    And from where do the source data for the cube comes from; a relational database?

    So relational => OLAP => relational => Tableau?