Hi,

I am new to the MDX syntax, would like some advice of following:

I had a dimension, namely: Account Year Month (value consists from 1990
to 2020). and another dimension: Product

with measure: Premium Amount

I would like to generate cummulative amount, I manage to do by applying
method:

Sum([AccountDate].CurrentMember.Level.Members.Item(0):
[AccountDate].CurrentMember, [Premium Amount])

I managed to get the results:

Product Year (cumulative)
1990 1991 .... 2005 2006.....2020
A 100 200
B 30 700
C 20 900

I do have collect output, however, is there any method to show only
year value exists at the fact table? If not can I create range i.e.
show only from 2000 to 2008

Kindly need your advice.

Thanks

regards,
Mango

Can you use a "Non Empty" clause in your MDX query?

'Sum(PeriodsToDate([Time].[All]),
[Measures].[Premium Amount]'

Select Non Empty [Time].[Year].Members on columns,
[Product].[ProductName].Members on rows
from [AmountCube]
where ([Measures].[Cumulative Amount])

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Hi,

Currently, I am creating the cubes not from the MDX query but from the
Analysis Manager - Cube (drag and drop method). And I had added the
above calculated measures for the purpose, do you think if it's
possible to use the Non Empty function?

Thanks in advance for your advice.

Regards,
Mangorind.


Deepak Puri wrote:

The Cube Browser of Analysis Manager is geared to development purposes -
not sure whether it can be customized as you want. This should be easy
with standard cube client tools like Excel Pivot Tables, though.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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