How to make a data changed when another data is changed?

[guoshock]

Hi,all.
I have created a cube through Turbo Integrator with OBDC(Sql Server) data source,there are three datas in the cube：A,B,and C.
A and B are metadatas,C=A*B.But when I change A or B,C isn't changed.How can i make C changed when A or B is changed?
Thanks for reading.

[asutcliffe]

Hi,all.
I have created a cube through Turbo Integrator with OBDC(Sql Server) data source,there are three datas in the cube：A,B,and C.
A and B are metadatas,C=A*B.But when I change A or B,C isn't changed.How can i make C changed when A or B is changed?
Thanks for reading.

Hmmm, not entirely sure what you mean but essentially you need to create a rule in your cube to set C = B * A. It sounds like what you've done is calculate C at load time in your TI process instead. Is that about right?

[guoshock]

Hi,all.
I have created a cube through Turbo Integrator with OBDC(Sql Server) data source,there are three datas in the cube：A,B,and C.
A and B are metadatas,C=A*B.But when I change A or B,C isn't changed.How can i make C changed when A or B is changed?
Thanks for reading.

Hmmm, not entirely sure what you mean but essentially you need to create a rule in your cube to set C = B * A. It sounds like what you've done is calculate C at load time in your TI process instead. Is that about right?

I'm Sorry that I didn't describe the problem clearly.The fact is:
I have set C=A*B in the column 'formula' of "variables" tab in Turbo Integrator,and at load time C was calculated as I wanted,but waht puzzled me is that after created the cube, when I changed A or B,the data C wasn't changed at all.
What I wanted is that when I change A or B,the data C will be also changed,for C=A*B.
Hope that I have described the problem clearly.

[winsonlee]

Hi,all.
I have created a cube through Turbo Integrator with OBDC(Sql Server) data source,there are three datas in the cube：A,B,and C.
A and B are metadatas,C=A*B.But when I change A or B,C isn't changed.How can i make C changed when A or B is changed?
Thanks for reading.

Hmmm, not entirely sure what you mean but essentially you need to create a rule in your cube to set C = B * A. It sounds like what you've done is calculate C at load time in your TI process instead. Is that about right?

asutcliffe pointed out that you are loading C using TI process. so when the data is in the cube, it exist as a data instead of a calculated field. On the TI process, you only have to load A and B. define c in the rules.

[guoshock]

Hi,all.
I have created a cube through Turbo Integrator with OBDC(Sql Server) data source,there are three datas in the cube：A,B,and C.
A and B are metadatas,C=A*B.But when I change A or B,C isn't changed.How can i make C changed when A or B is changed?
Thanks for reading.

Hmmm, not entirely sure what you mean but essentially you need to create a rule in your cube to set C = B * A. It sounds like what you've done is calculate C at load time in your TI process instead. Is that about right?

asutcliffe pointed out that you are loading C using TI process. so when the data is in the cube, it exist as a data instead of a calculated field. On the TI process, you only have to load A and B. define c in the rules.

Thanks,winsonlee and asutcliffe,because of your posts,I get what I wanted through creating rules.