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 |
|
delpiero
Yak Posting Veteran
98 Posts |
 Posted - 2005-07-08 : 04:46:58
|
| Hi all, Suppose I have a dimension containing members which are some sort of group numbers, e.g. 111,123,155, ....,266,288, ....... Querying my cube will give this result:111 6123 8155 9...266 16288 18.............. If I want to insert a member, call it 100, which contains the total value of all group numbers starting with "1", i.e. 1XX, and this member '100' is NOT belonging to the original dimension ... So it would look like:100 23111 6123 8155 9...200 34266 16288 18.............. What should I use to achieve this? Custom rollup formula or calculated member? Thanks.delpiero |
|
|
|
|
|
custom rollup formulas VS calculated members