SQL Server Performance

All Member Formula property

Discussion in 'SQL Server 2005 Analysis Services' started by tboonleong, May 18, 2007.

  1. tboonleong Member

    In Anlaysis services 2k version, a dimesion have a 'All Member Formula' property for configuration suing mdx express.

    But I ssas 2005, I can not see it . May I know where the property setting it is?
    Anyone knows?
    Thanks.
  2. satya Moderator

    What options you see when you choose that dimension's properties?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. satya Moderator

    To add a custom member formula, you use the Business Intelligence Wizard, and select the Create a custom member formula option on the Choose Enhancement page. This wizard then guides you through the steps of selecting a dimension to which you want to apply a custom member formula and enabling the custom member formula.



    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  4. tboonleong Member

    Actual the senario is as below where a date dimension and sales figure(measure):

    ALL Date
    --Year
    --Quarter
    --Mth


    The All date dimesion should show the sales figure for that current mth instead of showing sum of the sales figure.
    I think customer member is not the right way for doing this scenario.
    As the version analysis services 2000, ALL MEMBER FORMULA property is avaiable , but I not see this property at SSAS2005.
    Is it other alternative way for this scenario?
    Thanks

  5. satya Moderator

    Have you looked at the other response above, you have to use BIDS for that wizard.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  6. tboonleong Member

    This is the solution that I had tried :

    Go to the related measures property and change the AggreagationFunction property to the LastNonEmpty and then reprocess the cube .The result will be show as expected.

    Thanks to Satya again since introduce BIDS wizard which I not aware.
    Thanks again to you if you able to provide more information for the BIDS wizard usage.
  7. satya Moderator

    As explained the wizard is already exists in BIDS and only with relevant data sources & dimensions you can pickup the relevant forumla. Your reply enabled me to blog the BIDS wizard usage, thanks.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page