Page 1 of 1
Two cubes and TI
Posted: Thu Apr 07, 2011 11:36 am
by viswaraju
Hi,
can clarify my doubt,Example;
i have two cubes when one cube is opened the data should flow into another cube into another cube.
when Cube A has opened and the sane Cube A data shuld flow into Cube B, by running TI.
Why this means cube A has calculated data that should flow into cube B.
Thanks and regards
TM 9.5.1
excel 2007.
Re: Two cubes and TI
Posted: Thu Apr 07, 2011 11:56 am
by Alan Kirk
viswaraju wrote:Hi,
can clarify my doubt,Example;
i have two cubes when one cube is opened the data should flow into another cube into another cube.
when Cube A has opened and the sane Cube A data shuld flow into Cube B, by running TI.
Why this means cube A has calculated data that should flow into cube B.
I'm genuinely uncertain whether that's an attempt at a haiku, or whether it's just a question that is in need of a
huuuuuuge amount of clarification.
Or, indeed, whether the data really
is sane.
For a start, what on earth do you mean "when it is opened"? Much as it would be a "nice to have", no current version of TM1 has event-triggered processes. They either fire when run manually, or when scheduled.
I have no idea what to make of the final question, though.
Re: Two cubes and TI
Posted: Thu Apr 07, 2011 2:13 pm
by viswaraju
Boss it is like requirement request by my senior. I was not confirmed for this option is available in TM1,please ask few to get from what you need?
Re: Two cubes and TI
Posted: Thu Apr 07, 2011 2:14 pm
by viswaraju
Boss it is like requirement request by my senior. I was not confirmed for this option is available in TM1,please ask few to get from what you need?
Re: Two cubes and TI
Posted: Thu Apr 07, 2011 5:38 pm
by lotsaram
viswaraju wrote:Boss it is like requirement request by my senior. I was not confirmed for this option is available in TM1,please ask few to get from what you need?
Well boss man that be up for you clearing things?
Re: Two cubes and TI
Posted: Thu Apr 07, 2011 8:41 pm
by Martin Ryan
viswaraju wrote:Hi,
can clarify my doubt,Example;
i have two cubes when one cube is opened the data should flow into another cube into another cube.
when Cube A has opened and the sane Cube A data shuld flow into Cube B, by running TI.
Why don't you use rules?
Just because your boss asks for something doesn't mean they know anything. As a TM1 specialist it's up to you to take their ideas and make them work sensibly. You can't expect them to know how all of their systems work at the detailed level. A management consultant would call it "adding value", I'd call it earning your pay cheque.
viswaraju wrote:
Why this means cube A has calculated data that should flow into cube B.
I think this is just a restatement of the same problem?
Re: Two cubes and TI
Posted: Thu Apr 07, 2011 8:57 pm
by Alan Kirk
Why this means cube A has calculated data that should flow into cube B.
With the benefit of a few hours' sleep, what I suspect this meant was:
"
What this means is that cube A has calculated data which should flow into cube B." Apparently this is supposed to happen when someone opens cube A.
Working on that assumption, then:
(a) What I said in the original post still stands; there are no event-triggered TI processes even though this has been
raised as an enhancement suggestion.
(b) I'd reiterate what Martin said about this being something that rules could be used for, but
(c) I'd go one step further than that and ask the question of whether there is in fact a genuine business need to have the same numbers in two places, or whether the required reporting and analysis could all be done out of cube A. Sometimes we can get too fixated on what
can be done without asking whether it
should be done.
Re: Two cubes and TI
Posted: Fri Apr 08, 2011 9:23 am
by viswaraju
Allan,
here in our condition yes because cube A data exactly i mean same data is flowing into cube B, but in Cube B the hierearchy is diiferent in way that,
cube A values are distributed in cube B in different hierarchy with different values but values(Input) are same, thats why the scenario has raised.
Thank you very much for your support.
Re: Two cubes and TI
Posted: Mon Apr 11, 2011 9:17 pm
by Martin Ryan
You can have multiple hierarchies in a dimension, so you could just have one cube and use those two different hierarchies in the key dimension to report the numbers differently.
Martin