dbTalk Databases Forums  

MDX Query

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


Discuss MDX Query in the microsoft.public.sqlserver.olap forum.



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

Default MDX Query - 08-26-2004 , 07:08 AM






Hi
Can anybody please help me to write a query where i can compare
the data of the measures of two dates,show the difference between them
and also the %change.
asset is one dimension and i have 10 measures.customer selects two
dates and he wants that his assets perfomance between two dates ,the
change and the change%.

e.g the dataset should be like;-

Assets Balance COA ROI Holding
stocks (Date1,date2,change,change%)
Mutual funds
cash
securities
bonds

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 - 2013, Jelsoft Enterprises Ltd.