1

Topic: SSAS. To filter measurement

Hello!
The task is that:
Is  - the reference manual of shops
[spoiler Store]
StoreID, set of other fields of important necessary fields
1...
2...
3...
4...
5...
[/spoiler]
On  the measurement with the same name is based. Measurement is connected to set of the facts, all works perfectly
There was a task to add grouping for subdividings, namely:
Is  - comparison of shops and groups of shops
[spoiler StoreGroupStore]
GroupID, StoreID
1,1
1,3
1,5
2,1
2,4
2,5
3,2
3,5
[/spoiler]
I.e. one shop can enter into some groups
The amount of groups is in advance not known, their amount will increase
As it is possible to make so that at a group choice the list of shops was filtered
The most simple and obvious variant to add in  with shops of a field, type IS_GroipID1 . IS_GroipIDN
I.e. something of type
[spoiler Store]
StoreID, other fields, IS_GroipID1, IS_GroipID2, IS_GroipID3
1..., 1, 1;
2..., 1
3..., 1,
4..., 1,
5..., 1, 1, 1
[/spoiler]
And using the corresponding we weed, in the report, to deduce the necessary group of subdividings
Minuses of such approach are obvious - if to add in table StoreGroupStore new group it is necessary to recreate twist, that there there was a field with new group,  twist in a cube, to add a new field,  all cube
Whether it is possible to create somehow such, for example measurement StoreGroupStore , at a choice  which measurement Store will be filtered?
Or as a whole - whether is what  a method (and what?) allowing to implement this idea in cubes?

2

Re: SSAS. To filter measurement

SSAS_;
The method for SSAS is, is called M2M or Many-to-Many measurements. Short - gives the chance analysts on measurement of "group of shops". How to implement - look to start the description and  Microsoft, there explicitly enough it is written.

3

Re: SSAS. To filter measurement

And the small chest simply opened
It was necessary to create measurement with the list of groups StoreGroup
To create the fact with comparison of groups and measurements StoreGroupFact . To connect their Regular-communication
Then to connect measurement Store to the fact StoreGroupFact - regular-communication
And after all measures to connect to measurement StoreGroup at help Many-To-Many

4

Re: SSAS. To filter measurement

Ferdipux, you outstripped me))
Thanks big!
Close please a subject