CODEWITHSUNDEEP
mdxbusiness-intelligenceolapcube
ahmad behmagham
ahmad behmagham

Reputation: 17

How to save MDX query and use it for next time?

I can write MDX queries in SSAS project but, I don't know how to save that and use MDX'queries for next time.

for example I Wrote MDX queries

WITH 
 MEMBER [Measures].[Max key] AS 
  Max
  (
   nonempty(
    [Date Skey].[Date Key].MEMBERS
    ,[Measures].[Qty - Fact Out Puts Warehouse]
  )
 ,[Date Skey].[Date Key]
) 
SELECT 
 {
  [Measures].[Max key]
 } ON COLUMNS
FROM [Cas Dw];

how Can I Use From Member [Max key] In PowerPivot Excel

Upvotes: 1

Views: 259

Answers (1)

zoe zhi
zoe zhi

Reputation: 164

You could add this query in SSS project->Cube->Calculation like below enter image description here Then deploy it and you could use it next time.

Upvotes: 2

Related Questions