The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Help with OLAP Cubes and MDX Expressions
Lanchester
Registered User regular
Registered User regular
Hey Everyone,
Does anyone have any experience with OLAP cubes and MDX expressions? I don't have any...have not taken any classes on any such thing and now find myself in the middle of it.
I've got an OLAP cube built, and I need to create a calculation that determines if a user is overworked. Now, I've done the calculation, but the problem is that it does the calculation by whatever timeframe you're viewing in the report. So if you have it spread out by months, it calculates the amount of scheduled work by the amount of available hours in that month.
I need it to make the calculations on a day basis, but if you're viewing it by month, it shows the count of how many days they are overworked instead of the monthly calculation. I can get down to the day level where it makes that calculation, but having a spreadsheet going out 365 cells for every resource doesn't really work for a report. Thanks!
Does anyone have any experience with OLAP cubes and MDX expressions? I don't have any...have not taken any classes on any such thing and now find myself in the middle of it.
I've got an OLAP cube built, and I need to create a calculation that determines if a user is overworked. Now, I've done the calculation, but the problem is that it does the calculation by whatever timeframe you're viewing in the report. So if you have it spread out by months, it calculates the amount of scheduled work by the amount of available hours in that month.
I need it to make the calculations on a day basis, but if you're viewing it by month, it shows the count of how many days they are overworked instead of the monthly calculation. I can get down to the day level where it makes that calculation, but having a spreadsheet going out 365 cells for every resource doesn't really work for a report. Thanks!
0
Posts