The EQD is a wonderful tool within a tool that allows you to set up reports and spreadsheets with the aid of an easy to use visual interface tool. Once you have a query designed just the way you want it you can save it off and use it over and over again to retrieve your data.
As mentioned earlier, one huge side benefit of the EQD is that when saving your custom designed query, you have the option to tell the EQD to also save the query as an Essbase report script file. Like we mentioned in the previous chapter, this option lets you utilize the powerful and easy to use data selection functionality of the EQD to create complicated and specific report scripts as well. Apart from the complicated selection criteria, you can also sort the data in either ascending or descending order, rank your data, and also filter your data based on your own needs. It is with these report scripts and a little editing that you will find yourself in possession of complex data extraction...