Re: MDX to calculate dead stock.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Mahesh,


For the NonEmptyCrossJoin() option (assuming that it gives the right
results), there's a couple of things to look at:

- What's the structure of the Product dimension, and number of members
at the leaf level? You can get an idea of the performance of
"Descendants(Products,,Leaves)" by returning just that as the rows in an
MDX query and measuring the response time. If Product is a regular
dimension, then you could compare the performance with using
"Products.LeafLevel.Members" instead.

- If the Time dimension has a Week level, you could optimize
"Time.CurrentMember.Lag(30):Time.CurrentMember" by using an equivalent
set of week and day members, as discussed here in Chris Webb's blog:

http://spaces.msn.com/members/cwebbbi/Blog/cns!1pi7ETChsJ1un_2s41jm9Iyg!
107.entry
>>
Tuning YTD-style calculations
...
>>


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: Conditional MDX Staement
    ... What do you want the calculation to show when you're at the all member in ... the product dimension? ... The way the calculation is set up, ... > The products dimension has 3 levels. ...
    (microsoft.public.sqlserver.olap)
  • Re: parent-child -
    ... I had hidden misconfiguration on a many-to-many dimension related to the PRODUCT dimension. ... Ohjoo Kwon wrote: ...
    (microsoft.public.sqlserver.olap)
  • Custom Member formula problem
    ... All are using a rollup column in each table. ... In my Product dimension, I have ... In the Accounts dimension, I have an unbalanced, parent/child table. ... My leaf level member has a custom member formula in it, ...
    (microsoft.public.sqlserver.olap)
  • Re: Snowflake schema in AS2005
    ... You can refer to the Product dimension in the Adventure Works DW AS 2005 ... Dimension based on a Snowflake Schema Design ...
    (microsoft.public.sqlserver.olap)
  • Re: Calculated measures in virtual cube visible form Excel Pivot T
    ... by default doesn't display this level (maybe there's a connection string ... Once I moved the Calculated Members onto a lower level, ... fine in Excel 's non-dimension hierarchy. ... In article, Deepak Puri says... ...
    (microsoft.public.sqlserver.olap)