I'm trying to create a dimension containing financial accounts in SSAS 2008 R2 where individual accounts can belong to one or more hierarchies. I also need to be able to specify a unary operator since a leaf level account may be subtracted
from one parent but additive to another parent. For example revenues and expenses may be grouped one way for statutory reporting and a completly different way for management reporting and further belong to some arbitraty groupings that users find necessary.
I can't seem to find a way to have a leaf level member in a dimension more than one time in a Parent child hierarchy, and I can't seem to find any way to include the unary operator in a hierarchy where I use attributes to define the hierarchy.
Are there any work arounds that anyone knows about? What I found from the help file was that multiple parent child hierarchies which supported in SSAS 2000 are not supported in 2008. However there is no suggestion for what to do.
Any insight would be greatly appreciated.
View Complete Post