Dinamic Query in Excel
Hello i am working in a company that whants to include excelsius in their reports, but the problem is the following. They whant a behavior like this...
Main plant <
-> Business Units <-> Cost Centers <-- > Details and whant a roll back if one of the cost centers are not in the target area so sending the info like this <--- to an status icon so the manager can have a warning icon if some of his business units are out of the target zone and drill down to the problem.
But Xcelsius doesnt give to many option so i try to do it in excel, i make a query that updates my info if every time my "filter cell" has a change, very usefull when doing reports, so i thougth of using 4 querys in 4 spreedsheets so i can administrate the data and not loading all in the excel... excel doesnt sopport it and obviusly xcelsius is out of question.
Can Xcelsius export parameter to the querys in any kind of conections and how does it do it?
Configuring the querys like add -ins in excel can be and option?
Or do you have and idea on how to do it?
I have xcelsius 2008 engage and microsoft office 2003. The trail is almost done and i have to make a desicion if Xcelsius its work buying.