dbTalk Databases Forums  

Urgent!calculating mod prices using MDX is it possible

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


Discuss Urgent!calculating mod prices using MDX is it possible in the microsoft.public.sqlserver.olap forum.



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

Default Urgent!calculating mod prices using MDX is it possible - 09-20-2004 , 08:51 AM






Hi,
I have a RetailPrice measure which is stored at SKU product the lowest
level in the fact table.This price need not be aggregated in the cube.

If we are creating partitions monthly.If i select Jan to March(it can
be dynamic) as time period
I wanted to know is it possible to calculate the mod price for this
measure for the above period by MDX in the cube

It would be great,any one please let me know how can i achieve it
using MDX


Regards
Prasanna

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.