July 21, 2009 at 2:48 am
Hi
I am looking for any advice from people who are making use of Dynamics AX 2009 in conjunction with Dynamics AX 2009 and the SSRS/SSAS functionality for BI reporting.
I am trying to write reports in SSRS however there are a lot of obsticles to overcome as this is not the pure SSRS that I am familiar with. If anyone has any information on how to get around issues such as making use of date ranges with parameters and the like it would be very much appreciated.
Thanks
John
June 21, 2010 at 4:31 pm
Hi John,
The main considerations are really the versions. SSRS 2008 deployment for example is quite different from SSRS 2005, the principle remains the same but there are additional steps in deployment from Visual Studio for example.
The company where I work, implement AX 2009 as a solution provider and I work closely with our in-house BI specialist. His preference is to build data-marts / data warehouses outside of AX from the AX DB and then preform BI from here and I have to say that even the case for having Enterprise Portal consuming KPI's / Gauges / Charts and so forth, can as readily be achieved this way as the presentation layer is either MOSS or WSS (Windows Share Point Services) which is free and installed by default with Enterprise Portal.
The disadvantage's to consider with deployment and federating server instances are really down to Kerberos authentication. Keeping everything on a single instance removes this issue.
If you already have the environment correctly laid out, it's really just a case of going into the AOT and selecting one of the Report Libraries, right clicking and editing in visual studio. When the report library loads into visual studio, you will be presented with the layouts, the business logic, data methods and everything else that you need to get started. The best way forward in this instance is to ensure that everything connects, deploys and updates as it should.
As a side note, have you looked into the default AX cubes? It's like looking at a circuit board diagram and is practically impossible to understand. It's machine generated and certainly not accurate. Each deployment has different requirements and as for the bells and whistles that you visualize in web parts within role centers or share point, the same can be done with human build cubes that are accurate, readable by human beings and actually process!
Best wishes!
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply