This feels like a really basic question, because it's a really basic function I'm looking for. I know you can do this: ([Dimension].CurrentMember IS [Dimension].[AParticularMember]) and you get...

I would like to understand what might be the highest-level groupings of how query languages can be broken up into, and why one grouping might be fundamentally different than another. For example, t...

I am using PowerBI Desktop/Service as a Front-End and Analysis Services Multidimensional as Back-End. I want to create a complex calculated member but I have a problem in some part of the member. ...

I have a dimension called [Band] and it can have several different values: [Band].&[A]&[Under $400] [Band].&[B]&[$400 - $1,000] [Band].&[C]&[$1,000 - $2,500] [Band].&[D...

How can i round a calculated mdx measure up to the nearest integer without having Excel on the server? The Excel-function is CEILING(number, significance), but it is not possible to install Excel o...

I have some numbers in a fact table, and have generated a measure which use the SUM aggregator to summarize the numbers. But the problem is that I only want to sum the numbers that are higher than,...

I have a sales cube deployed in SSAS that need to be displayed using Power BI. Assume that I have arrange a layout – simulated with Excel - like the following, a dimension (Product - with 5 members...

Anyone know if there are plans for LINQ to MDX . Does any way currently exist to use LINQ with MDX / CUBES

This question might not be well researched but I need to find out proper way to implement this solution before starting design. Question is, Can we consume SSAS MDX query as datasource in Azure Da...

I was wondering if there is a in-memory OLAP server which can handle MDX. I found the Wikipedia article. But it says nothing about in-memory functionality... The only one I know of them is ...

This is for an application which dynamically sets data for and renders reports. I have an MDX query for a report which relies on a parameter. The query is: SELECT NULL ON COLUMNS, strtomember(@Da...

I want to implement an application that provides support for MDX queries. For this purpose I would like to use one of libraries from pentaho mondrian (an open source OLTP server with the MDX interf...

Hi I am having troubles configuring the SSIS task to run an MDX query. The parse works fine but it doesn't allow me to display the different columns of the query to map it Here is the query i us...

When I browse the cube and pivot Sales by Month ,(for example), I get something like 12345.678901. Is there a way to make it so that when a user browses they get values rounded up to nearest two ...

The relevant structures from my cube are that I have a Hierarchy with "Class" and "SubClass". I also have a Measure called "Value" which is what im trying to obtain. A simple query may look like:...

I need a bit of help with my SSRS parameter code in MDX context I'm trying to return Country locations with and type = matter and a house count (not used as a parameter) for the drop down list ...

I have an SSAS-2014 cube. I want to set a particular measure to NULL if a particular dimension is being used in either axis or the filter pane of a pivot table in excel. Now, the most intuitive sol...

I am having an extremely hard time with Excel being very slow whenever interacting with a pivot table. Adding/removing a field, changing a filter or slicer, all take several minutes of Excel being ...

I need an MDX query for Mondrian filtered by date, where one or both of the boundry dates may not exist. I'm using the query below that works as long as both 2013-01-01 and 2013-01-08 dimensions ex...

I have two time dimensions, production period and accounting period, and a measure that I want to aggregate with either dimension but not with both when users query the cube from excel. To do that ...

Am having trouble in understanding how FILTER function works in MDX. Here is my query which gets all the non-empty Internet Order Count values for all Sales Territory Countries across all the Cale...

In Sql Server Management Studio once I browse a cube I can drop column fields, row fields and filter fields. This displays the required data. I want to know if there is a way to view the MDX quer...

Is there a way to list dimension members without fetching default Measure for each member?

Parser: The query contains the XXXXXName parameter, which is not declared. (msmgdsrv) I have no idea why I keep getting this error. It occurs when I change the MDX in the query designer and trying...

In an OLAP database I work with there is a 'Location' hierarchy consisting of the levels Company -> Region -> Area -> Site -> Room. I am using the following MDX to get all the descendants of a part...