All Member Formula property | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

All Member Formula property

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.
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.
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.
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
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.
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.
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.
]]>