Issue many to many currency in SSAS - Updated issue RRS feed

  • Question

  • Hi,

    So I followed this blog post to the exact details

    Good and bad new. When I browse the cube I get the following data:

    First problem is that I get 8 hotels, while I have 150 hotels in the cube. When I drag in the currency dimension, I get all hotels shown!

    If I then drag in the reporting currency dimension, the conversion is done correctly!

    First problem, how come I don't get any data (or well a few hotels) when I don't drag in the currency dimension?

    Sescond problen, in Excel nothing is working, I get the error "type missmatch" when I drag in the measure only.

    Anyone has an idea what is happening? Also I think it is affected by the link with the currency dimension. Once I connect this it affects all ,measures and not all data is shown in the cube when the currency is not used in any way.

    • Edited by Yvanlathem Tuesday, February 6, 2018 9:35 AM
    Tuesday, February 6, 2018 7:32 AM

All replies

  • There's no indication that any M2M relations exist from your Dimension Usage pic., all dimensions seems to be connected directly to relevant measure groups.
    Tuesday, February 6, 2018 12:46 PM