Dynamics AX
  RSS Feed  LinkedIn  Twitter
Want to turn you're data into a true asset? Ready to break free from the report factory?
Ready to gain true insights that are action focused for truly data informed decisions?
Want to do all of this across mutliple companies, instances of Dynamics and your other investments?
Hillstar Business Intelligence is the answer then! (www.HillstarBI.com)

Hillstar Business Intelligence for Microsoft Dynamics AX and NAV on Mobile, Desktop, Tablet


Let us prove to you how we can take the complexity out of the schema and truly enable users to answer the needed questions to run your business! Visit Hillstar Business Solutions at: www.HillstarBI.com

Friday, December 21, 2012

Merry Christmas!





I wanted to take the time and wish everyone a very, Merry Christmas! Further Happy Holiday's for everyone throughout the different days we take time with our faith's and families. May you all be equally blessed!

This time of year, is a special time of year for many of us. Let us keep in our thoughts and prayers all those that are hurting, and be thankful for the time we have with our friends & families. Faith, Hope & Love are the three things we can all have, and can all use to battle the negative sides of life.

My Grandmother, may she rest in peace, use to always tell me when I was a kid to find ways to turn life's lemon's into lemonade! So here to many, many sweet glasses of lemonade this coming year!

We have an exciting year ahead of us in the Dynamics Ecosystem. With Microsoft Convergence 2013 just around the corner. We have now Dynamics AX 2012 R2 alive, and well, with support for SharePoint 2013 & Office 2013.

With that, be safe, have fun, enjoy & laugh! Finally, let me say it one more time Merry Christmas & Happy Holidays!


Follow Me @:
   RSS Feed  LinkedIn  Twitter

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , , ,

Tuesday, December 04, 2012

OData Query Utility for Dynamics AX 2012





Well I hope everyone is doing well, and finding yourself very productive in this Exciting Week for Microsoft Dynamics. Of course, I'm talking in reference to the now released Microsoft Dynamics AX 2012 R2.

While that for sure deserve's a lot of attention, there is something I wanted to give to the community at large, as my Christmas present if you will to everyone. What I'm talking about is an Open Source Project I created called.: AX-OData Queries



As the above image implies, it's the gift that keeps on giving! That is, this open source project has ready to use, a Utility Wizard, and context action that makes understanding which Queries in a Dynamics AX 2012 instance, are valid candidates to become PowerPivot OData Feed sources!



Further as part of this project, there is a Library component that I started, in which I have placed a customer aging query, in the standard folder location. You can read more, by visiting the project's home page.

Further, important, is the documentation, so the following is a direct link to that.: AX-OData Queries Project Documentation. Make sure to read the Read Me, and then following along from there. This includes from Install, through to How To Use Guide.



The above image is the Dynamics AX 2012 project that currently comprises as v1.0.0 of the OData Query Utility scope. This again, includes a Wizard as well as an Context menu, that lives under the Add-in's section.



Like all projects, this needs revision and refinement. This is an Open Source project, and so I do encourage you to get involved as you can. Help make this better! Further, the changes and impacts of AX 2012 R2 has not be tested against this. So there is plenty of chances to make this a much better set of tools, and queries for common data sets.



As-is, you can download the Utility as an XPO file, and import it into a target Dynamics AX 2012 RTM or Feature Pack instance. Then you can either run the Wizard, or you can execute the Context Menu for a specific single query element. The goal, is to help enable the continued theme of creating a System of Engagement with Microsoft Dynamics AX. This specific will help on the Personal BI landscape, in helping faster enable use of PowerPivot, via OData Feeds.

Well that's all for now! (Early) Merry Christmas! As updates happen, of course I will take the time and let everyone know. Please visit the project, download, test, enjoy, contribute! Till Next Time!

Update: There was a slight feature added this afternoon. One that I thought was important to make the first grid, in which you filter the searching of queries by layers. We have added a new field called "Number of Queries".



Now I admit the speed in which the utilElements table can be read, which is a key to the majority of this, is not at the level I like. This is one of the area's that will be focused on next.
Follow Me @:
RSS Feed  LinkedIn  Twitter

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , , , , , , , , , , , ,

Thursday, December 22, 2011

Merry Christmas!





I just wanted to take the time, and wish Everyone a Merry Christmas! I will be back writing some next week, and so will wish you all a Happy New Year then.

May your Christmas be blessed, and Happy Holidays! Thank you for reading my blog, and always giving me challenges that make this social exploration of Dynamics knowledge so fun.

For an early Christmas present, if you will, the following is a blast from the past. First up we have: Twas the night before implementation

Finally, if you dare, When squirrels attack! - A True Christmas Tale



Merry Christmas!

Follow Me @:
RSS Feed  LinkedIn  Twitter

"Visit the Dynamics AX Community Page today!"

Labels: ,

Tuesday, December 28, 2010

Merry (late) Christmas and a Happy New Year!

Well I am sure that most of you took some vacation, as did I last week. I realized I did not post a Merry Christmas entry, so here is a Late Merry Christmas! :-) Better late than never right?

Also I hope that it was a blessed Christmas for each of you, and that 2011 is the best year yet!

I have a good bit in store and a lot to do coming up. With a year end closing post, reflecting on a recent blog post on Dynamics and the cloud. Will hope close the year on a topic that we started it, 2010 being called the Year of the Cloud!

I also have some guest blog post coming soon, as well as coverage of the Microsoft Dynamics AX 2011 - Technical Conference. This is being hosted at the campus in Redmond. A LOT of great tracks!

So here to closing out 2010 with a bang, and welcoming the new year of 2011!

"Visit the Dynamics AX Community Page today!"

Labels: , , , , , , , , , ,

Monday, December 21, 2009

Merry Christmas!

Well, It's that wonderful time of year again. Christmas time!

I wanted to make sure and get out to everyone a very Merry Christmas!



May you and your families have a very blessed Christmas. I hope that your able to keep in your heart and mind of what this time of year celebrates. The birth of Yeshua --- Jesus Christ, our Lord and Savior!

Through him do we have the ultimate gift of salvation, because we are all sinners, and therefore all need this gift!

I will be back posting regular after the holidays, and might get some post in here and there during!

Again Merry Christmas!




"Visit the Dynamics AX Community Page today!"


Labels: , , , , , ,

Monday, December 22, 2008

Merry Christmas: What is really means...

I know at times, the "Holiday Seasons" seem tough for folks. People get depressed and down, but it's only because of what our focus is during this time.

The commerical world around us, has really hijacked what should be a time for family, love and being thankful.

So with that, and with everything that I am, I give thanks to God on High, to our Creator, YHWH - YHVH (English Translation not exact you see, so both of them I choose to use here.) And the gift, the gift that should truly be reconized is our salvation, in that we find our savior Christ Yeshua, Jesus.

And with that, Merry Christ-mas:

Luke 2
The Birth of Jesus
1 In those days Caesar Augustus issued a decree that a census should be taken of the entire Roman world. 2 (This was the first census that took place while Quirinius was governor of Syria.) 3 And everyone went to his own town to register.
4 So Joseph also went up from the town of Nazareth in Galilee to Judea, to Bethlehem the town of David, because he belonged to the house and line of David. 5 He went there to register with Mary, who was pledged to be married to him and was expecting a child. 6 While they were there, the time came for the baby to be born, 7 and she gave birth to her firstborn, a son. She wrapped him in cloths and placed him in a manger, because there was no room for them in the inn.

The Shepherds and the Angels
8 And there were shepherds living out in the fields nearby, keeping watch over their flocks at night. 9 An angel of the Lord appeared to them, and the glory of the Lord shone around them, and they were terrified. 10 But the angel said to them, "Do not be afraid. I bring you good news of great joy that will be for all the people. 11 Today in the town of David a Savior has been born to you; he is Christ[a] the Lord. 12 This will be a sign to you: You will find a baby wrapped in cloths and lying in a manger."
13 Suddenly a great company of the heavenly host appeared with the angel, praising God and saying,
14 "Glory to God in the highest,
and on earth peace to men on whom his favor rests."


15 When the angels had left them and gone into heaven, the shepherds said to one another, "Let's go to Bethlehem and see this thing that has happened, which the Lord has told us about."

16 So they hurried off and found Mary and Joseph, and the baby, who was lying in the manger. 17When they had seen him, they spread the word concerning what had been told them about this child, 18and all who heard it were amazed at what the shepherds said to them. 19But Mary treasured up all these things and pondered them in her heart. 20The shepherds returned, glorifying and praising God for all the things they had heard and seen, which were just as they had been told.


Check back soon...




"Visit the Dynamics AX Community Page today!"


Labels: , , , , , ,

Friday, December 19, 2008

One year ago... "When squirrels attack!"

Well it's been a year since that fateful day. The day the world stood still. When everything changed, and no one was left the same...

Of course I am refering to when my family and I were attacked by a crazed, blood thirsty squirrel!

It's such a horrible thing, I am sorry I have to bring images of such a thing back up, but that's the only way we heal, the only way we learn. If you dare, you can read about the events, by going here: When squirrels attack!

I still have the horrible image in my head, of that red hat wearing squirrel, leaping, teeth nashing at me... I lost 3 fingers that day... at least almost. (Not really but, still it's funny)

Maybe this year we will be spared, maybe this year when my wife sees a squirrel outside she will not freeze and pass out from fright...



Check back soon!




"Visit the Dynamics AX Community Page today!"


Labels: , , ,

Monday, December 24, 2007

Merry Christmas & Happy New Year!

I wanted to take the time to wish you all a very Merry Christmas and a Happy New Year!

May we keep in our hearts, the love that this time of year is suppose to be about. May you be blessed beyond your ability to count, and most of all give thanks to the Creator for the greatest gift, the offer of his love and salvation.

Merry Christmas, and a Happy, Blessed New Year!

Check back in 2008!

Find a job at: www.DynamicsAXJobs.com

Labels: , ,

Monday, December 17, 2007

Twas the night before implementation

Alright, so I had the following emailed to me from a client. The author is unknown that started this. (Or at least unknown to me) And I have made some small modifications to this from what was sent to me. Either way, this is Very fitting, funny, and hope that is brings a smile to everyone's face that read's it!


"Twas the night before implementation, and all through the house
not a program was working, not even a browse.

The consultants were hung by their laptops in despair, with hopes that a miracle would soon be there.

The users were nestled all snug in their beds, while visions of inquiries danced in their heads.

When out of the hall arose such a clatter, I sprang from my desk to see what was the matter.

And to my wondering eyes should appear, but a Super consultant with a six pack of beer.

His resume glowed with experience so rare, he turned out great code with that special consultant's flair.

More rapid than eagles, his customizations they came, and he whistled and shouted and called them by name:

On Update! On Add! On Inquire! On Delete!
On Migrate! On Closing!
On Dynamics AX Complete!

His eyes were glazed over, fingers nimble and lean, from weekends and nights spent in front of a screen.

A wink of his eye and a twist of his head,
soon came me to know, I had nothing to dread.

He spoke not a word, but went straight to his work, turning specs into code, then turned with a jerk.

And laying his finger on the ENTER KEY,
the system came up and worked properly.

The updates updated; the deletes, they deleted; The inquiries inquired; and the closings completed.

He tested each whistle, and tested each bell, with nary a failure, and all had gone well.

The system was finished and all tests were considered.
The client's last changes were even configured.

The clients exclaimed with a snarl and a taunt,
'It's just what I asked for, but not what I want.'"


I hope you enjoyed that! Merry Christmas! May God bless each and everyone of you. May peace, joy, and love be with all of you now and going forward into the new year. Make sure to give thanks to our Creator for the days you have, and the love of the people in your lives!

Check back soon!


Find a job at: www.DynamicsAXJobs.com

Labels: , , , , , ,


Copyright 2005-2011, J. Brandon George - All rights Reserved