Can i make data marts in SSAS?

zara 1

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?

Quien 0 Reputation points

2024-09-04T11:37:15.66+00:00

Cudd hi hi hi 8100547640

1 answer

Lukas Yu -MSFT 5,821 Reputation points

2021-04-02T08:21:59.82+00:00

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
Please sign in to rate this answer.
zara 1 Reputation point

2021-04-02T09:43:00.823+00:00

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?

Lukas Yu -MSFT 5,821 Reputation points

2021-04-05T02:20:03.993+00:00

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.

Lukas Yu -MSFT 5,821 Reputation points

2021-04-12T01:39:06.92+00:00

Have you resolved the issue ? Do you have further questions?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Can i make data marts in SSAS?

1 answer

Your answer