So, i have almost completed the book “Step by Step” and only have the report building chapter left which i will take care of tomorrow. I found myself at a crossroad regarding where to go next week. Either i plan to go through the books summaries and try create queries against my real ERP data. While i am doing this i need to investigate the different measures that´s already included in the cube. I also should investigate all four cubes which contain different kinds of data, logistic, accounting etc. I have also some thoughts about creating the reports and how to make the drilldown possibility between the main dashboard and different detailed reports i.e sub reports. I found this blog that contains great stuff about creating a dashboard and i will surely implement some of his thoughts. http://globaljimmy.com/post/12258930948/planning-a-dashboard-project
So, tomorrow do the last chapter with simple reports and then continue with planning for the dashboard while i´m investigating the economic KPI´s inside the cubes and also look at the different dimensions more.
One more week investigating and running queries and then it´s time to write the report. What i want after the report is to know as much there is about MDX so that it wont be a problem when i am creating the reports and also be familiar with the cubes of the ERP so that i can find information quickly and swift.