Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
truchuynh
Starting Member
4 Posts |
 Posted - 2012-02-22 : 13:56:37
|
| Hi all,We have a SSAS cube in SQL Server 2008R2.Fact table columns: Year, Province, Amount, SaleMode( can be "retail' or 'wholesale') .Dimensions: Year, ProvinceMeasure: AmountWe want to add a new calculated member to the YEAR dimension in our cube.It will be named "Latest Year for Retail".It would contain the most recent Year member with data for SaleMode=Retail in the fact table.So when browsing the cube,the Year dimension should look like follows:------------------------Year200020012002Latest Year for Retail------------------------What kind of function is required in the MDX ?Does SaleMode need to become a dimension (we prefer a solution without this dimension) ?Any advice/comment will be appreciated.Thanks in advance. |
|
|
|
|
|
add a new member to dimension