Menu
Cart 0

Our Blog — Excel

Make Common Queries Available For Everyone By Saving Them To Office365

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

Queries are like mining for gold, because everyone is searching for the motherload of data that is hidden within Dynamics AX, and once they find it, they mine it until it dries out and they have to start prospecting again.  Also, the secret maps to that data are hidden away, usually on someone’s own personal …

Read More

Read more →

Publish Queries As OData Document Sources For Users To Query In Excel

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

If you want to publish out data to the users so that they can create their own reports, or run their own analysis, there is in a simple and secure way built into Dynamics AX.  You can register your queries as Document Data Sources and then they automatically become available through the OData service within …

Read More

Read more →

Create Reports Directly Off the Dynamics AX Cubes Through Excel

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

Excel is probably the number one reporting tool because it is on everyone’s computer, and also because it is so easy to manipulate the data and create your own analysis, charts and tables.  In the past though, the more technical users have had a slight advantage over the general users because they knew the secret …

Read More

Read more →

Exporting Data to Your Client Version of Excel When Using Remote Desktop

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

Just because you are using a remote desktop to access Dynamics AX, doesn’t mean that you have to do everything there.  One example of this is that you can choose to export data to your local version of Excel rather than to the version of Office that may be running on your remote desktop.  All …

Read More

Read more →

Export to Excel when there is no Ribbon Bar

Posted by Author, Curator, Visually Impared Squirrel Literacy Advocate & Dynamics AX Technical Solution Professional (TSP) at Microsoft on

Not all of the forms within Dynamics AX have the ribbon bar enabled with the Export to Excel icon handy for you to use when you want to gram a copy of the data, but that doesn’t mean that there is no way to quickly get your data moved over to a linked worksheet. All …

Read More

Read more →