Home Forums Data Warehousing Analysis Services The sub-total and total indicators must be retrieved by MDX in the cube. RE: The sub-total and total indicators must be retrieved by MDX in the cube.

  • July 19, 2013 at 6:05 am

    #1633964

    For Example.

    Refer the figure.

    Considering First Hierarchy tree:

    [Dim Marketing Product].[Product Version].[Product Version] as "France Term Life + Assistance"

    [Dim Marketing Campaign].[Campaigns].[Campaign Country] as "France"

    [Dim Marketing Campaign].[Campaign Market].[Campaign Market] as "DIGITAL"

    [Dim Marketing Campaign].[Campaign Partner].[Campaign Partner] as "iQuitis"

    [Dim Marketing Campaign].[Campaign].[Campaign] as "FRPDOF05PN"

    [Dim Marketing Campaign].[Campaign Origin].[Campaign Origin] as "IQ01"