One of the benefits of Microsoft Dynamics AX is that the schema is fairly easy to navigate around. Every day I thank Microsoft for not going down the obfuscation route. Have you ever worked on ACCPAC? It’s a nightmare. Peoplesoft isn’t that much better. Most AX systems I’ve worked on have some external reporting running on the database. Because of
Continue readingCategory: Technology Tips
Analysis services, perspectives and different granularities
One of the wonderful features of Analysis Services (SSAS) are perspectives. Perspectives allow you to limit what measure groups, measures, dimensions, attributes and hierarchies are displayed. This is great if you have lots of measure groups and dimensions because you can build them all in one cube and use a perspective to display only a subset of them. You can
Continue reading