Use Excel Data tools (Goal seek) in Ax

[Celeste]

Hi
I want to use the 'What-if analysis' tool in Excel on a table in Ax –
specifically the Goal seek function. I have no idea how to go about it.
There is no specific function name that I can see, and it does not refer to
any dll's or other controls that can be used.

Do I have to use Sql Server Analysis Services for this? (Which I hope is
not the case – I doubt that my customer will not agree to the extra
requirements.)

Thanks
Celeste

[Huzaifa Gain]

I am afraid you have to BI solution for AX otherwise pull the data using biz
connector and write a custom solution in .NET

Post by Celeste
Hi
I want to use the 'What-if analysis' tool in Excel on a table in Ax –
specifically the Goal seek function. I have no idea how to go about it.
There is no specific function name that I can see, and it does not refer to
any dll's or other controls that can be used.
Do I have to use Sql Server Analysis Services for this? (Which I hope is
not the case – I doubt that my customer will not agree to the extra
requirements.)
Thanks
Celeste
--
//https://www.xing.com/profile/Celeste_Lategan