Calculated Measures and aggregation

From: Vivek Vaidya (vivek.vaidya_at_rapt.com)
Date: 08/10/04 

Date: 10 Aug 2004 09:39:16 -0700

Hello All,

In my cube, I have a Calculated Measure (say A) that is derived from
another Calculated Measure (say B). B is derived from some native
measure (say C). In my application, I generate MDX queries on the fly
using metadata that I've retrieved using XML/A.

My problem is that when my query just contains A, the aggregation at
different levels of all my hierarchies gets messed up. What I want is
a way to determine that A is dervied using B and then add the
expression for B to my query also with a lower SOLVE_ORDER than A.

I can easily get the Expression used to calculate A, but I can't seem
to find a way to get the measures that A is dependent on. If that is
not possible, then I have thought of another solution using
SOLVE_ORDER which I explicitly set in the Cube for every measure. But
it looks like, the SOLVE_ORDER attribute of a measure is not returned
as part of the response to a MDSCHEMA_MEASURES query.

Can anyone pleas help?

Thanks,
Vivek.

Relevant Pages

  • RE: Troubleshooting Execution Location
    ... It's much faster on the server. ... If I run the query once via HTTP, then I change the date range and run the query again, it's almost instantaneous the second time. ... have you made sure that each Distinct Count measure is in a cube ... the axis that I think would benefit the most from aggregation doesn't show up. ...
    (microsoft.public.sqlserver.olap)
  • Re: CPU and MDX
    ... specially if you have changed the cube structure after an initial aggregation. ... also try to preload the cache by executing the query a first time. ... > be able to use all my CPU. ...
    (microsoft.public.sqlserver.olap)
  • RE: Troubleshooting Execution Location
    ... "Jonathan Levine" wrote: ... > If I run the query once via HTTP, then I change the date range and run the query again, it's almost instantaneous the second time. ... have you made sure that each Distinct Count measure is in a cube ... the axis that I think would benefit the most from aggregation doesn't show up. ...
    (microsoft.public.sqlserver.olap)
  • help! with averaging within a cube
    ... I have a cube defined as ... My measurecome from the following query: ... data GROUP BY datepartAS datetime))) ... allow aggregation by sum and not average. ...
    (microsoft.public.sqlserver.olap)
  • Re: Timeout problems due to huge Fact Table
    ... I've also experienced very poor performing queries that the cube itself has ... of dimensions & with 'materialize' set on the relationships in the dimension ... to fill your cube you are using a very complex query instead of a table. ... level and adding required table in the database. ...
    (microsoft.public.sqlserver.olap)