Multiple Data Models

lma2356 — Thu, 09 Jan 2020 14:26:01 GMT

Hello--

I see there is a way to have multiple layouts of data models in the Relationship View tab.

Distinct from the 'All Tables' tab can you have: one page operate off one data model with different relationships, let's call it 'Tab A' and then another page operate off a separate data model with different relationships, calling this 'Tab B'?

Each of these models would be have distinct uses from one another for reporting purpose.

Appreciate any input thank--especially if I am looking at it from a wrong/harder way. Thank you.

Re: Multiple Data Models

d_gosbell — Thu, 09 Jan 2020 21:30:02 GMT

@lma2356 wrote:
Distinct from the 'All Tables' tab can you have: one page operate off one data model with different relationships, let's call it 'Tab A' and then another page operate off a separate data model with different relationships, calling this 'Tab B'?

No you can't have different relationships. The separate tabs just let you view a sub-set of the full model. It is purely a way of filtering the All Tables view, but under the covers it is still just a single data model.

To utilize different relationships you either need to setup inactive relationships and use the USERELATIONSHIP or CROSSFILTER functions within specific measures or create a separate file with another copy of your tables.

topic Re: Multiple Data Models in Report Server

Multiple Data Models

Re: Multiple Data Models