Two cubes and TI

Post Reply
viswaraju
Regular Participant
Posts: 177
Joined: Thu Nov 05, 2009 8:45 am
OLAP Product: IBM COGNOS TM1
Version: 9.5
Excel Version: 2007

Two cubes and TI

Post 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.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Two cubes and TI

Post 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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
viswaraju
Regular Participant
Posts: 177
Joined: Thu Nov 05, 2009 8:45 am
OLAP Product: IBM COGNOS TM1
Version: 9.5
Excel Version: 2007

Re: Two cubes and TI

Post 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?
viswaraju
Regular Participant
Posts: 177
Joined: Thu Nov 05, 2009 8:45 am
OLAP Product: IBM COGNOS TM1
Version: 9.5
Excel Version: 2007

Re: Two cubes and TI

Post 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?
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Two cubes and TI

Post 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?
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Two cubes and TI

Post 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?
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Two cubes and TI

Post 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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
viswaraju
Regular Participant
Posts: 177
Joined: Thu Nov 05, 2009 8:45 am
OLAP Product: IBM COGNOS TM1
Version: 9.5
Excel Version: 2007

Re: Two cubes and TI

Post 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.
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Two cubes and TI

Post 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
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Post Reply