Stack Overflow
Stack Overflow

Questions tagged [mdxstudio]

MDX Studio is a tool for write a MDX query

MDX Studio is a tool for write a "Multidimensional Expressions" (MDX) query.

The IDE have a code formatting feature, an embedded system to analyze query performance and many other features for writing MDX queries.

Download and info here

21 questions
1
vote
2 answers

Get Top 5 by Different years MDX

I have a top 5 of Customers by year and I want to create a query that gets this information per year in different years at the same time, I mean: select [Measures].[Ventas] on columns, non empty topcount ( [Dim Cliente].[Company…
Antonio Labra
  • 1,694
  • 2
  • 12
  • 21
1
vote
0 answers

filter particular column value based on rows using mdx or in SSRS

I have defectcode 0,1,2... what i need is, for service failure column mentioned in the image i need only values for defect >0 and it(servicefailure) should not display value for defect 0. so that i can use these value to sum up in report or give…
author4
  • 125
  • 2
  • 12
1
vote
1 answer

Fast dynamic named set calculation

I have a long complex query with a lot of calculations and conditions but the main structure looks like this: WITH MEMBER [Id1] AS [Level].[Level1].CurrentMember.Member_Key MEMBER [Id2] AS [Level].[Level2].CurrentMember.Member_Key MEMBER…
K V
  • 23
  • 5
1
vote
1 answer

Case statement not working for all conditions

with member test as case when ([All Products].[All Products].[Group 2].&[1],[Measures].[minus-prod-trx])>0 then (ancestor([All Products].[All Products].[Group 2].&[1],2),[Measures].[minus-prod-trx]) when ([All Products].[All Products].[Group…
Anil
  • 39
  • 2
1
vote
1 answer

wrong result of parallelperiod() for DATE in MDX

I want to extract data for same period last year and last month. for this i am using Parallelperiod(), for eg PARALLELPERIOD([date].[year],1,[date].[date].[20-Sep-2014]) , for which I am getting output : 21-Sep-2014 and…
sam140
  • 219
  • 1
  • 5
  • 27
0
votes
0 answers

MDX Query Subtotal

I am trying to get a subtotal in MDX on a separate column. Example below: This is what I current have: Table This is what I am looking for: Looking for this If someone could please help me? Currently this is the code I am using: (I ALSO HAVE A SALES…
Code Learn
  • 1
0
votes
0 answers

Saving MDX query results to Table or csv file

I am not from SSAS background. We are trying to automate a process where we are currently switching multiple filters on excel sheets that are connected to SSAS cubes and do a visual comparison against the data on a Netezza table. Basically, we are…
user9254573
  • 1
0
votes
1 answer

MDX Calculated Measure to get Cumulative Sum from First Month to Last Month of each year

I would like to get Cumulative Sum from Jan - Dec for each year Something similar to Below But replace First Month and Last Month with the current year data. I have data from 2014 -2017 Sum( [Ship Date].[Date].CURRENT_MEMBER.FirstMonth : [Ship…
SKenneth
  • 19
  • 11
0
votes
2 answers

MDX Calculated Measure

Below is my requirement in the picture The 1st table is at least granularity.The avg is calculated by Date + Place.So the avg is 565 = (2865/5). Coming to the second table.The avg for place 702 is 114 which is right and for 704 it is 866 which is…
Krish Dev
  • 13
  • 5
0
votes
2 answers

How can i use a subquery or (WITH)statment in MDX Query?

I have a CustomerToFactor as a Measure and Customer as a Dimension. Now I want to create a MDX code like this SQL code but I can't. because (WITH) statements has another meaning in MDX. with Total_Customer( select cus_id …
Hamid ajdari
  • 1
  • 2
0
votes
1 answer

TRIMMEAN in MDX

In Excel I can use this formula to calculate the average in a certain period and ignore the top 20% most extreme values: TRIMMEAN(AY13:BH13,20%) I cannot find any result when searching on MDX TRIMMEAN. I think I have to do something with RANK and…
Kees Netelvrees
  • 119
  • 1
  • 8
0
votes
1 answer

Counts Based on Multiple condition in OLAP MDX in a single statement

I am stuck with merging different MDX conditions into one single statement on MDX-SSAS. Details: I have a cube (Acceptance) with following data as below: Uniq_ID Acceptance_Type Responsible_Area 1 Accepted …
Ravi J
  • 1
  • 2
0
votes
1 answer

how to get Min values for dimension members?

I have a cube with few dimensions. Report Date and Account are two of them. One account id may come under multiple Report dates. I need to find minimum report date for every accountid. Any ideas?
Anubhav Sharma
  • 1
0
votes
1 answer

Changing the dimension value as measure

i want to use the dimension value as calculated measure case when [time].[month].current member is [time].[month].&[januaray] then 'januaray' when [time].[month].&[feb] then 'feburary' else 'None' end i want to display for these…
Adi
  • 232
  • 1
  • 9
0
votes
0 answers

How market growth for each product under that particular market would be same?

I have All_Product hierarchy in All_product dimension. strength-->product-->market I want calculation for product growth and market growth on monthly basis((current-prev)/prev). I used scripts to calculate product growth (wrt product) and market…
Anil
  • 39
  • 2
1
2