how to remove the NULL rows of cells? RRS feed

  • Question

  • I've got the following query in the next URL

    [Date Type].[Date Type].[Date Type].MEMBERS
    ON 0,
    [Date].[Calendar Year].[Calendar Year].MEMBERS
    ON 1
    FROM [M2MTest]
    WHERE([Measures].[Sales Amount])

    What is the syntax to prevent showing of the rows of the cells having NULL?

    Secondly, How to get the previous year?


            [Date Type].[Hierarchy].[Date Type Key].MEMBERS
            ON 0,

    //        [Date].[Calendar Date].[Year].MEMBERS  // Hier
            [Date].[Calendar Date].[Year].PREVMEMBER  // Doesn't work. expect member expression
            ON 1

            [SOS OLAP]
    WHERE(    [Measures].[Internet Sales Amount]    )

    Executing the query ...
    Query (10, 3) The PREVMEMBER function expects a member expression for the 1 argument. A level expression was used.
    Execution complete

    -- IBM has jobs for USA employee to work oversea (India) and get their wages.

    • Edited by light_wt Tuesday, August 13, 2013 8:52 PM update
    Tuesday, August 13, 2013 8:49 PM


All replies