September 24, 2015 at 6:05 am
Thanks for being patient with me. I have worked in the SQL server world for many years, but now just created my first OLAP cube. This cube is mostly based on demographical data (age, dates, employment status, education level, etc). I now need to create a report in SSRS that shows percentages. Right now the only measure I have in the cube is row counts. What I need to do is to compare last Fiscal Year with Current Fiscal year and then compare both of those against a standard goal. So I guess I have a few questions in this regard.
1) Should I be doing the processing at the report level or in the cube with calculated measures and then delivering those to the report?
2) I am starting to get a handle on MDX, but it is confusing. The first measure I need for instance is employment. So I need to get the number of registered users for the fiscal year (and also last fiscal year) and divide that by the number that have gainful employment.
And this is just one of several demographic data I need to deliver in this report. So do I need several different calculated measures or write the MDX into the report? I am used to writing some stored procedure that can do this for me. I am not asking anyone to write this for me, just point me in the right direction.
Thanks!
September 26, 2015 at 6:10 am
If you have to do a lot of time-based calculation then there is no better place to start than by setting up a date tool dimension:
It's one of the first things I set up in almost every cube I do. It's also a good introduction to the murky world of MDX scoped assignments, which will help prevent you from writing many distinct calculations and instead do something more dynamic and scale-able.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply