Untitled

SUBMITTED BY: Guest
DATE: Nov. 12, 2013, 6:49 p.m.
FORMAT: Text only
SIZE: 3.3 kB
Raw Download
HITS: 1082
Report
	

    SELECT
    {
        Hierarchize
        (
            {
                [Bookings].[DEFAULT_HIERARCHY].[ALL].[AllMember],
                [Bookings].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children
            }
        )
    } ON COLUMNS,
    {
        Hierarchize
        (
            {
                [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember],
                [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children
            }
        )
    } ON ROWS
    FROM [EquityDerivativesCube]
           
    SELECT
    {
        Hierarchize
        (
            {
                [Bookings].[DEFAULT_HIERARCHY].[ALL].[AllMember],
                [Bookings].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children
            }
        )
    } ON COLUMNS,
    {
        Hierarchize
        (
            {
                [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember],
                [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children,
                [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember].[2M].Children
            }
        )
    } ON ROWS
    FROM [EquityDerivativesCube]
           
    SELECT
    {
        Hierarchize
        (
            {
                {0}
            }
        )
    } ON COLUMNS,
    {
        Hierarchize
        (
            {1}
        )
    }
    ON ROWS FROM [EquityDerivativesCube]
           
    SELECT
    Hierarchize(
        Union(
            CrossJoin(
                {[Bookings].[DEFAULT_HIERARCHY].[ALL].[AllMember]},
                 {[Underlyings].[DEFAULT_HIERARCHY].[ALL].[AllMember]}
            ),
             Union(
                CrossJoin(
                    {[Bookings].[DEFAULT_HIERARCHY].[ALL].[AllMember]},
                     [Underlyings].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children
                ),
                 Union(
                    CrossJoin(
                        [Bookings].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children,
                         {[Underlyings].[DEFAULT_HIERARCHY].[ALL].[AllMember]}
                    ),
                     CrossJoin(
                        [Bookings].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children,
                         [Underlyings].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children
                    )
                )
            )
        ))
    ON COLUMNS,
    {Hierarchize(
        {[TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember],
         [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children})}
    ON ROWS
    FROM [EquityDerivativesCube]
           
    DrilldownMember({ [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember]}, { [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember], [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember].[2M]}, RECURSIVE)
           
    {
        {[TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember]},
        [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember].Children,
        [TimeBucket].[DEFAULT_HIERARCHY].[ALL].[AllMember].[2M].Children
    }