none
how to speed up cubevalue

    Question

  • May I have question.. please, help..

    I am using excel 2007, and olap user..

    1. Is there a difference between these? (Sometimes I see EXITS(FILTER..) )

            FILTER(EXISTS ..  

            EXISTS(FILTER..

    2. Is there way to speed up below cubevalue..?  ( I have to use below function  250 times at once, chaging  &[iii] everytime.   I guess, It takes more than 1 minite every time.. )

          =N(CUBEVALUE("connection name"

                              ,"[i].[ii].&[&iii]" ,"[t].[&tt]", "[Measures].[m]"," --- cubeset --- "))

      ※the Cubeset above uses below filter, in which EXISTS used.

        FILTER(EXISTS([a].[aa].[aa].members 
    , {[a].[aaa].[q] , [a].[aaa].[w] , [a].[aaa].[C] , [a].[aaa].[e] , [a].[aaa].[f] , [a].[aaa].[m] , [a].[aaa].[n] , [a].[aaa].[t]} ) , ([b].[bb],[bbb].[bbbb].[bbbbb],[c].[cc].[ccc],[Measures].[m])>0)







    • Edited by soon5 Tuesday, February 28, 2012 5:36 AM
    Monday, February 27, 2012 7:03 AM

Answers