question

zara-6464 avatar image
0 Votes"
zara-6464 asked LukasYu-msft commented

Can i make data marts in SSAS?

I followed kimball approach but the problem is I didn't make data marts before star schema. Now my question is can I make data marts in SSAS or is it mandatory to make these marts before schema in kimball approach?

sql-server-integration-servicessql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

Hi,

A data mart is a subset of you data warehouse. SSAS and data marts / data warehouse are not nessasary for each other.

As they are only loose concept, SSAS can build your data mart as well as your data house. You could also add tables into your project and enrich you data warehouse or creat/ add new data mart.

Please also see this thread, which clarifies the relation between them : What is the difference between SSAS & Data Mart?

Regards,
Lukas

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

But my question is as in kimball approach we have to make data marts before star schema. So, is it okay if I didn't make data marts before star. I mean I didn't followed kimball approach completely. So, what will be this approach called?

0 Votes 0 ·

It is still called Kimball.
The core is that the data marts pull data directly from OLTP then give the data to cube. No matter you create it first or lately. The "kimball" approach is named for its structure . You could create it any time in the project.

0 Votes 0 ·

Have you resolved the issue ? Do you have further questions?

0 Votes 0 ·