Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can i convert select statment of an mdx query into an calculated member Expand / Collapse
Author
Message
Posted Wednesday, July 24, 2013 4:04 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 19, 2014 4:13 AM
Points: 210, Visits: 1,211

Please find the select query as below


SELECT {[Measures].[SO Actual Qty],[Measures].[Estimated Value]} ON COLUMNS,([Business Unit].[Business Unit].[Business Unit].ALLMEMBERS ) ON ROWS FROM
[SMS_CURRENT_WW]

Please let me know whether this can be done or not
Post #1476954
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse