Hi all,
does anyone know how it is possible to include the percent of base
calculated measure in a cube in analysis services. I have a measure that I
need to know what percentage it is of the grand total. I know little about
MDX and was wondering if tis possible.

Thanks
Dave

Not sure what the desired report is, but does this MDX sample query come
close to what you want?

http://www.tomchester.net/articlesdo...desamples.html

Works with any set and any measure (assumes measure being operated upon
is in first column)

WITH MEMBER Measures.[% Total] AS

' ( StrToSet("Axis(1)").Item(0).Item(0).Dimension.Curr entMember, --
cur row mbr

StrToSet("Axis(0)").Item(0).Item(0) ) / --
1st measure on cols

( StrToSet("Axis(1)").Item(0).Item(0), --
assume 1st row=total

StrToSet("Axis(0)").Item(0).Item(0) ) ' , --
1st measure on cols

Format_String = '0%'

SELECT

{ [Store Sales] , [% Total] } ON AXIS(0),

{ Product.DefaultMember, [Product Family].Members} ON AXIS(1)

FROM Sales

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

"Deepak Puri" wrote: