Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Semi-additive measure calculations plus sub-totals equals slow queries

Status
Not open for further replies.
RiverGuy

RiverGuy

Programmer
Jul 18, 2002
5,011
US
I'm using SSAS 2005 Standard Edition. I've got some calculations to create some semi-additive measures. They're basically beginning and ending amounts (non-additive over time). Query performance is OK until I include sub-totals and totals in my MDX report generator, wherein my report takes over one minute to run.

I'm not an MDX expert by any means. I've used the following article for help in designing my calculation code.


Any help would be appreciated.
 
Status
Not open for further replies.

Similar threads

Rolaper
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta SCD at the same time?
Replies
0
Views
109
Rolaper
Rolaper
eo
  • Locked
  • Question
MDX Calc measure to accomdate Smi-Additive and delta at the same time? 1
Replies
5
Views
109
eo
eo
naga5566
  • Locked
  • Question
Time Intellegence Parallelperiod calculations for missing months
Replies
0
Views
88
naga5566
naga5566
RiverGuy
  • Locked
  • Question
Measure group containing Additive and Semiadditive measures 1
Replies
3
Views
55
RiverGuy
RiverGuy
flurk118
  • Locked
  • Question
Semi-additive issue...
Replies
7
Views
64
flurk118
flurk118

Part and Inventory Search

Sponsor

Back
Top