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
0
votes
1 answer

Need to Slice data based on Count of Boolean Flags (Same Dimension, No Hierarchy)

I need to slice the data based on Multiple Flags on the Transactional record. The Flags are on the same dimension but not in the same hierarchy. Below is the sample transnational data and corresponding fact table that we have generated. I need to…
Kritul Rathod
  • 75
  • 1
  • 11
0
votes
1 answer

MDX query to count number of product names

I am new to MDX and trying to count number of product names on a week basis. I have written the below MDX query, but I get all product count as a result. WITH MEMBER [Measures].[Count Of Members] AS Count(Existing [Product…
Shivang
  • 231
  • 1
  • 5
  • 17
0
votes
1 answer

How to filter by measure values in MDX while having dimension members in both axis

I'm developing an application that uses a tabular database to show some business data. I need to provide some basic filtering over measures values (equal to, greater than, lesser than etc.) and I'm currently analyzing the proper way to generate the…
SMarello
  • 309
  • 4
  • 11
0
votes
1 answer

MDX: Distinct Count of members summarized by another dimension

From my cube, I am trying to get a distinct count of all non-empty [ID].[FullID]s but summarized by [Underlying]. I know that, for example, there are two IDs for [Underlying].[Underlying1] at this particular WHERE slice and I can see this by running…
hulked
  • 15
  • 6
0
votes
1 answer

How to remove null rows from MDX query results

How can I remove the null row from my MDX query results? Here is the query I'm currently working with select non empty { [Measures].[Average Trips Per Day] ,[Measures].[Calories Burned] ,[Measures].[Carbon Offset] ,[Measures].[Median…
Emily
  • 11
  • 1
0
votes
1 answer

Translating a T-SQL query to MDX

I am a new MDX user. I can easily get what I need using T-SQL but getting the equivalent using MDX has proven difficult. use [AdventureWorksDW2012] ------------------------------------------------------------ --Select customers that purchased…
user2607686
  • 47
  • 2
  • 8
0
votes
1 answer

MDX Question - Using Top Count with Rank/Order Function

How do I use a top count so it only returns the first 2 records with the highest sales for each sales territory group (North America, Pacific, etc...) WITH MEMBER [Measures].[Group_Ranking_InternetSales] AS RANK( [Sales Territory].[Sales…
user2607686
  • 47
  • 2
  • 8
0
votes
1 answer

MDX calculated measure slow when adding operations

I have created a calculated measure through BIDS in a SSAS cube and it's like the following: IIF([Measures].[RatePct] >= 0.90, [Measures].[measureA], [Measures].[measureB]) The point is that if I convert the above to this: IIF([Measures].[RatePct]…
Yiannis A
  • 3
  • 2
0
votes
1 answer

Hirereachy is used more than Once in the cross Join Function

I have MDX query which throws an error - "The portalID hierarchy is used more than once in the cross Join Function" The query fails at the where clause WHERE (-{[SG Location].[PortalID].[30], [SG Location].[PortalID].[46]}, …
Sachin Pakale
  • 292
  • 2
  • 4
  • 19
0
votes
1 answer

SSRS - floating sum (previous 5)

In SSRS I have column group per days (user can change range). I need to evaluate for each day for the previous five days. I found PREVIOUS function which gives me only one previous value. Is there any option how to evaluate, for example, last 5…
Ondrej Pospisil
  • 1
  • 3
0
votes
1 answer

ActivePivot: Parsing Multidimensional Cellset data into JSON for React-vis Charts

I have just started working with MDX queries so I am not an expert. We have been provided with MDX queries to be triggered from our front-end application through a web socket connection. The response received is a multi-dimensional dataset rather…
CodingMum
  • 53
  • 8
0
votes
1 answer

MDX records by row values

I currently have the following code in MDX that I've been struggling on getting formatted in the way I need. WITH MEMBER measures.Quantity_Chicago_Madison AS IIF([Tb Consumer].[City].currentmember is [Tb Consumer].[City].& [Chicago] and…
peakstatus
  • 381
  • 1
  • 3
  • 15
0
votes
1 answer

MDX Filter & Date Range Issue

Trying to accomplish the following: How many customers purchased from a specific product for any given date range What were the total sales for customers noted above for any given date range Current query: My query below gives me exactly what I…
user2607686
  • 47
  • 2
  • 8
0
votes
0 answers

MDX Query to get Last Year data without filtering based on current month

i have been doing a query to get previous year value in MDX but can't the the desired output. In sql i would do it like this. Question is how do i apply this query in MDX? select data1, sum(data2) as sumthisyear, sumlastyear from table1 a left…
Kiddo Gabaldon
  • 3
  • 3
0
votes
1 answer

Mondrian MDX Query error:- All arguments to function '{}' must have same hierarchy

I am using Tibco Jaspersoft to generate the report. Expected result:- Created Schema File: …
Dharita Chokshi
  • 1,133
  • 3
  • 16
  • 39
1 2 3
…
9 10