dbTalk Databases Forums  

MDX Help needed. Highest Time member from the selected set

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss MDX Help needed. Highest Time member from the selected set in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Harry
 
Posts: n/a

Default MDX Help needed. Highest Time member from the selected set - 07-08-2003 , 06:41 PM






I want to write a calculated measure to achieve the below results:
My cibe has three dimensions. Product, Time and Measures

Three measures: Base, Adjs, Comp
Base and Adjs are fact table measures. Comp is a calculated member.

Suppose the user selects 2001, 2002, 2003 on either rows or columns.
Example:

2001 2002 2003
Base 10 15 20
Adjs 5 8 9
Comp 10/9 15/9 20/9


And if the user selects:

1997 2000 2002
Base 60 35 25
Adjs 8 7 8
Comp 60/8 35/8 25/8


And even if the users select Products and Measures on roes and
columns, but slice it by Time:

Base Adjs Comp
Prod1 9 5 9/5
Prod6 7 5 7/5


Slice by Time: {1999, 2001}

If you follow:

I want the CALCULATED MEMBER "Comp" to be always based on Adjs value
of Highest Year in the selections.

Can you please help? I don't know how to refer to an item from current
selection.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.