CODEWITHSUNDEEP
sql-serverdata-warehousessas-tabularsaprfc
Deva
Deva

Reputation: 1

How to create a SQL Data Warehouse in SSAS tabular model with denormalized tables?

We have 4 to 5 denormalized tables generated from SAP. How can we create a tabular data warehouse with denormalized tables? What is the recommended warehousing technology? All tables are pushed into SQL by SSIS by processing flat files from SAP RFC reports.

Upvotes: 0

Views: 446

Answers (1)

Michael buller
Michael buller

Reputation: 586

It doesn't sound like you are using Tabular for any pre-aggregation, but rather a transport mechanism to get it to Power BI. You can model these tables directly in Power BI and get all of the benefits that you have to date. You would get additional benefits as well. Power BI would then allow the user to create their own measures, enhance the model with other tables, etc. If the issue is that you don't want people accessing this SQL instance directly, you have a lot of options there as well.

Upvotes: 0

Related Questions