Re: Calculated member value v/s relational totals

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

Hi Ashok,

Not sure what your date hierarchies look like, but there are 2 immediate
issues that I can see:

- You would need to divide 2 SUM()'s in MDX as well, since Sum(A/B) may
not be the same as Sum(A)/Sum(B)

- MDX date range is Jan14:Jan20, vs. SQL of Jan15:Jan20


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Relevant Pages

  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... MDX is the 'spreadsheet language of the database world' ... SQL Server Books Online (again-- Access ships with freeware SQL Server ...
    (microsoft.public.excel)
  • Re: WHY
    ... Access, SQL Server, OLAP, MDX and VB.Net.. ... MDX has what-- 80% of the functionality of Excel ... ...
    (microsoft.public.excel)
  • Re: MDX equivalent to SQLs IN operator
    ... You could also create a named set which includes the values, ... Wayne Snyder, MCDBA, SQL Server MVP ... "Francisco Alvarado" wrote in message ... > Does MDX have an equivalent to sql's IN operator? ...
    (microsoft.public.sqlserver.olap)
  • Re: OLAP, MDX, and Crystal Reports
    ... In the past I have used the technique of creating a linked server from ... SQL Server to Analysis Services and using OpenQuery to pass it an MDX ... >> Reporting Services would be better for this? ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: how ans where MDX should be used...
    ... Here's an MDX tutorial article, from a series by William Pearson, which ... Introducing the SQL Server 'MDX in Analysis Services' Series ... This is the first tutorial of a new series, MDX in Analysis Services, ...
    (microsoft.public.sqlserver.olap)