CODEWITHSUNDEEP
sql-server-2008visual-studio-2008ssasbids
Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17363

Filter out data loaded into dimension

I know it is recommended to build dimension using a view on source table because it allows to make changes to the dimension contents without opening the SSAS project. However, I cannot create a view in the source system.

How can I load only a subset of data into a dimension?

Upvotes: 1

Views: 817

Answers (1)

Marek Grzenkowicz
Marek Grzenkowicz

Reputation: 17363

A named query can be used to filter out unnecessary dimension members. Conceptually it is similar to a database view and the source RDBMS will take care of data processing (e.g. filtering it), but it is defined in the SSAS project.

  1. Open the data source view.
  2. Right-click on the dimension source table and choose Replace Table / With New Named Query... from the context menu.
  3. Add a WHERE clause to the query and make any other changes you need:

SSAS - named query

Upvotes: 3

Related Questions