greetings,

in my cube, i need to compare net change over two periods

dimensions period1 period2 difference

what would be the easiest way to do that? i can't just add
two date dimensions, cause by default they'll crossjoin and only show
result which matches both, right? so how should i approach this..

thank you.

Are you using any specific client tool to display this?

I've built a specific report to handle this problem but it's
fundemetally Excel based.

Steve

You're right that if you add both Time dimensions to the cube you'll run into
issues, but using virtual cubes it is possible to have one working Time
dimension and one which has no effect on the base data and which can be used
only for your calculated member. See here for details
http://groups.google.co.uk/groups?hl...TK2MSFT NGP12

HTH,

Chris

"QQ" wrote:

The clients are using Excel to display the cubes.. so your solution could
work perhaps.

"Steve McHugh" <steve (AT) oneleg (DOT) net> wrote in news:1099561107.041370.262390
@z14g2000cwz.googlegroups.com:

Hmm, this sounds interesting, but I believe it only gives solution for one
period.. for second one I would need 2 more Time dimensions, and I can
already see it getting messy..

"=?Utf-8?B?Q2hyaXMgV2ViYg==?=" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com>
wrote in news:9741954E-739A-495E-87FD-494091CDADC8 (AT) microsoft (DOT) com: