Stack Overflow
Stack Overflow

Questions tagged [mdx-query]

A sample MDX query looks like below. 

[ WITH <SELECT WITH clause> [ , <SELECT WITH clause> ... ] ]   
SELECT [ * | ( <SELECT query axis clause>   
    [ , <SELECT query axis clause> ... ] ) ]  
FROM <SELECT subcube clause>   
[ <SELECT slicer axis clause> ]  
[ <SELECT cell property list clause> ]
140 questions
1
vote
0 answers

Case Statements in MDX

I need to create a calculated measure Internal Quantity for the following equation, Internal quantity = Quantity where [X].[Category Id] = A or B/ Quantity The calculated measure Quantity calculates the SUM of a column. So, for example if the…
Krishi H
  • 526
  • 8
  • 26
1
vote
1 answer

Identify login with Administrative access on SSAS instance using query or Powershell

Want to identify the users/login with Administrative access on server to migrate them to new server's. I have tried Select * from $System.TMSCHEMA_ROLE_MEMBERSHIPS but these give information regarding the particular database i need more at server…
Dhirendra Patil
  • 134
  • 1
  • 7
1
vote
0 answers

How do I reformat a measure in a mdx query

I have an MDX query running on SSAS instance. The amount that gets displayed as a currency with spaces and , in the column. eg R 1 200,10. I do not want to change anything on the data warehouse but want to change the format in the MDX query so that…
Gary Ballentine
  • 11
  • 2
1
vote
1 answer

Return 'n' rows from MDX output

How to filter MDX output for first 'n' rows and then loop over the next 'n' rows and so on using following example. SELECT { [Measures1].members, [Measures2].members } ON COLUMNS, { [Date].members } ON ROWS FROM [cube] I'm trying this…
User1493
  • 481
  • 2
  • 7
  • 23
1
vote
1 answer

MDX query runs for more than an hour

I am new to MDX queries. I have written a query which uses lead function to get values for (Current Week plus 1) as a new column for each of the metrics. Basically comparing current week value with last week's value. Without the new members the…
user11099655
  • 11
  • 3
1
vote
2 answers

Calculate Cumulative Month Value in MDX

I wanna calculate the cumulative values by month/year My dimensions period as follow: Period Dimension I ve tried any ways to perform this operation, but unsucessfull with member [Measures].[Valor Acumulado] as…
Tonny Alves
  • 23
  • 3
1
vote
1 answer

Aggregate Facts bases on selected Dimension members

How to add a Total Column like in below image. the Query Structure is as below WITH MEMBER [Measure].[Total Responses] AS [Measures].[Responses] MEMBER [Measure].[Option 1] as CoalesceEmpty([Measures].[Option1],0) MEMBER…
Kritul Rathod
  • 75
  • 1
  • 11
1
vote
1 answer

MDX divide a set by a measure

I have a set lets just say: set [A] as { ([Measures].[X],[somedimension].[A]) [Measures].[Y],[somedimension].[A]) [Measures].[Z],[somedimension].[A]) } What I need to do is I have to divide this set with a specific value say: [Measures].[P] Is it…
Aveg Chaudhary
  • 35
  • 4
1
vote
1 answer

MDX query to group on year of date dimension with specific date range

I have SQL query SELECT YEAR(DATE),SUM(AMOUNT) FROM TABLE WHERE DATE BETWEEN '2017-09-01' AND '2018-09-30' GROUP BY YEAR(DATE). This will give me sum of amount for 2017 and 2018 for selected date range. Same I am trying in mdx query with date…
Hardik Shah
  • 83
  • 2
  • 5
1
vote
1 answer

ranking within MDX

I have this MDX Query: WITH MEMBER [COUNT_RANK] AS RANK(([TKT].[SP].CURRENTMEMBER, [TKT].[SA].CURRENTMEMBER) , [TKT].[SP].CURRENTMEMBER *[TKT].[SA].[SA] ) SELECT { [COUNT_RANK], [Measures].[TKT Count], [Measures].[Est Hours] } ON 0, ORDER…
arcee123
  • 101
  • 9
  • 41
  • 118
1
vote
0 answers

how to pick max date in cube and stored in variable for plsql stored_procedure

I have cube in which I want to pick max_date for which data is populated and store it in variable. How can I do it using MDX. The name of cube is Open_Closed. I can do it easily pl/sql for fact table but is there any way of doing it in cube. I am…
NewtoPython
  • 167
  • 1
  • 2
  • 10
1
vote
2 answers

Azure Data Factory V2: MDX Query on SAP BW exception Microsoft.DataTransfer.Common.Shared.HybridDeliveryException

I am trying to fetch data from SAP BW system into Azure Data Lake using MDX Query in SAP BW connector. But I am getting exception message in Azure is following : { "errorCode": "2200", "message": "Failure happened on 'Source' side.…
PSM
  • 21
  • 4
1
vote
2 answers

How to Visualize properties with Mdx

I m new to the mdx query. I have spatial properties that i want to visualize in a geomondrian table, this is the schema of simple_geofoodmart.xml :
A.HADDAD
  • 1,809
  • 4
  • 26
  • 51
1
vote
1 answer

Combine different hierarchy levels using MDX Query

1.Description Now I have two mdx query, the only differences is the ON ROWS settings. Here is each query and its results. Query 1 : SELECT NON EMPTY { [PLOwner].[PLOwner].Members } ON ROWS , NON EMPTY Crossjoin( { …
Frank.Cui
  • 11
  • 2
1
vote
1 answer

Return Employee Count > 1 MDX SQL Server 2012

I am trying to write a simple MDX query to get employee counts that are more than one. I am able to use filter in the rows but how can I get the query to only return values whose count is more than one? select NON EMPTY {[Measures].[Employee Count]}…
Shaji
  • 741
  • 2
  • 9
  • 23
1 2 3
…
9 10