0 Replies Latest reply on Jul 17, 2009 8:16 AM by Brijesh Gaur

    Issue with start with,add,keep clause

    Brijesh Gaur

      I am querying a cube with following condition through BI excel addin

      Step 1. Start with 'ALL'
      Step 2. add members for which YTD >100000
      Step 3. keep members for which YTD < YTD prior period

      The query execution order should be as mentioned above. The members obtained from step 2 should be again filtered with the condition mentioned in #3.

      The issue is that when I use just #1 and #2 i get 300 members and when i put #3 also the number increases to 500.

      Keep should filter the records and should not add members? Am I missing something?


      Edited by: Brijesh Gaur on Jul 17, 2009 1:46 PM