What seems to be like a very simple request/idea, also seems to be impossible to do in Transformer.
I have a measure, Days in Month.... it is just way it says.
But the rollup depends on timestate obviously.
If I'm rolling up on the time dimension, I want to SUM.
If I'm rolling up on any other dimension, I want to average/max/min (it'll all return the same)
Unfortunately, in Transformer, for whatever reason, SUM is not an option for Timestate roll-up.
Any idea why?
Any thoughts on how I can get around this?
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
2 replies Latest Post - 2013-01-04T16:59:26Z by KevinSlanicky
Pinned topic Transformer - Days in Month - Rollup
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2013-01-04T16:59:26Z at 2013-01-04T16:59:26Z by KevinSlanicky
yangling 0600018QDQ38 Posts
KevinSlanicky 270003A1AR5 PostsACCEPTED ANSWER
Re: Transformer - Days in Month - Rollup2013-01-04T16:59:26Z in response to yanglingI did check that, but I still can't see/figure out how it would help.
Surely I'm not the only one who's ever needed to SUM across the time dimension, but AVERAGE across a regular dimension, am i??