1

Topic: SSAS 2012. M2M

Hello World! Cuba has the following architecture:
Measurements:
The nomenclature (the Key - Product Key)
The order (the Key - Document Key)
Groups of measures:
Groups of measures, Communication Type
[Orders the goods], (Communication with measurements - Regular )
, (Communication with the Nomenclature - ManyToMane ; with remaining - Regular )
[Distinkt of a measure], (Communication with measurements - Regular )
Communication ManyToMane goes through the intermediate group of measures [Distinkt of a measure] in which the amount unique Product Key is counted.
Still such moment, one order => is a lot of nomenclatures.
Prompt, why value of a measure from group of measures [], it was tightened only to one nomenclature?

2

Re: SSAS 2012. M2M

1 thought at once to pull out mdx through  and  already to look on it that there and as.

3

Re: SSAS 2012. M2M

At you there inadvertently it is not included "Materialize" in "Referenced Relationship"?
[img=http://sqlblog.com/blogs/alberto_ferrari/mat_thumb_4DFD3A77.png]

4

Re: SSAS 2012. M2M

At me other type of communication

5

Re: SSAS 2012. M2M

Yagrus2 wrote:

At me other type of communication

It is clear, but on road is not present Referenced communications?

6

Re: SSAS 2012. M2M

Yuri Abele, I you did not understand Izvenite

7

Re: SSAS 2012. M2M

I about that if any of the affected measurements not directly is connected, and  (referenced) there there is such effect that at materialzed=checked something there in M:N ceases to work normally.
I any more do not remember precisely - simply check up, and suddenly?