Page 1 of 1
How to make a data changed when another data is changed?
Posted: Fri Apr 20, 2012 9:13 am
by 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.
Re: How to make a data changed when another data is changed?
Posted: Fri Apr 20, 2012 10:22 am
by asutcliffe
guoshock wrote: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?
Re: How to make a data changed when another data is changed?
Posted: Mon Apr 23, 2012 1:43 am
by guoshock
asutcliffe wrote:guoshock wrote: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.
Re: How to make a data changed when another data is changed?
Posted: Mon Apr 23, 2012 3:27 am
by winsonlee
asutcliffe wrote:guoshock wrote: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.
Re: How to make a data changed when another data is changed?
Posted: Mon Apr 23, 2012 6:26 am
by guoshock
winsonlee wrote:asutcliffe wrote:guoshock wrote: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.